Table name Tb_sysuser
Page storage location and rules
Sysmanage
Sysuserlist.aspx
Sysuseredit.aspx
Sysuserdetail.aspx
Model class Sysuser Entity or Sysuser Info, note: One solution requires a unified
DAL class name Sysuserdal
Method (Please try to reuse the method)
1. Add int Add (sysuserentity model) (can be merged in edit)
2. Modify int edit (sysuserentity model)
3, delete int Deletebat (string IDs, int Isdel)//IDs multiple IDs comma separated, Isdel tombstone identity
4. Read single entity sysuserentity getobj (string id)//input parameter type varies by primary key type according to Id
5. Query all Datasets GetList (sysuserentity model) according to the conditions
return type available for DataTable or list< sysuserentity >
6, according to the conditions page DataSet getpaged (int pagesize, int pageindex, ref int recordCount, sysuserentity model)
PageSize display of records per page
PageIndex Current page number
RecordCount Total number of records
return type available for DataTable or list< sysuserentity >
If there are special methods, rules such as
Search by name
Single sysuserentity Getbyusername (string UserName)//input parameter type varies by type
Result set DataSet Getbyusername (String UserName)//input parameter type varies by type
BLL The class name Sysuserbll method is consistent with the Dal class
The stored procedure naming table corresponds to the Dal method
1. Adding Up_tb_sysuser_Add
2, modify Up_tb_sysuser_Edit
3. Delete Up_tb_sysuser_Del
4. Read a single entity Up_tb_sysuser_Get by ID
5, according to the conditions of the page Up_tb_sysuser_Paged
If there are special methods, rules such as
Search by name Up_tb_sysuser_Getbyusername
Page method naming
NET program Naming conventions