public static StoredProcedure SP_RemoveRoleUsers(int RoleID,string UserIDs) { StoredProcedure sp=new StoredProcedure("SP_RemoveRoleUsers"); sp.AddParameter("RoleID",RoleID,DbType.Int32); sp.AddParameter("UserIDs",UserIDs,DbType.AnsiString); return sp; }
public static StoredProcedure SP_RoleCheckUserRight(int RoleID,string UserID) { StoredProcedure sp=new StoredProcedure("SP_RoleCheckUserRight"); sp.AddParameter("RoleID",RoleID,DbType.Int32); sp.AddParameter("UserID",UserID,DbType.AnsiString); return sp; }
public static StoredProcedure SP_RemoveRoleUsers(int RoleID, string UserIDs) { StoredProcedure sp = new StoredProcedure("SP_RemoveRoleUsers"); sp.AddParameter("RoleID", RoleID, DbType.Int32); sp.AddParameter("UserIDs", UserIDs, DbType.AnsiString); return(sp); }
public static StoredProcedure SP_RoleCheckUserRight(int RoleID, string UserID) { StoredProcedure sp = new StoredProcedure("SP_RoleCheckUserRight"); sp.AddParameter("RoleID", RoleID, DbType.Int32); sp.AddParameter("UserID", UserID, DbType.AnsiString); return(sp); }
public static StoredProcedure SP_SetRoleRolePrivilege(int RoleID, string AddIDs, string MinusIDs, string UserID, string UserName) { StoredProcedure sp = new StoredProcedure("SP_SetRoleRolePrivilege"); sp.AddParameter("RoleID", RoleID, DbType.Int32); sp.AddParameter("AddIDs", AddIDs, DbType.AnsiString); sp.AddParameter("MinusIDs", MinusIDs, DbType.AnsiString); sp.AddParameter("UserID", UserID, DbType.AnsiString); sp.AddParameter("UserName", UserName, DbType.String); return(sp); }
public static StoredProcedure SP_DeletePrivilege(string PrivilegeCode) { StoredProcedure sp = new StoredProcedure("SP_DeletePrivilege"); sp.AddParameter("PrivilegeCode", PrivilegeCode, DbType.AnsiString); return(sp); }
public static StoredProcedure SP_DeleteUserInfo(string UserUID) { StoredProcedure sp = new StoredProcedure("SP_DeleteUserInfo"); sp.AddParameter("UserUID", UserUID, DbType.AnsiString); return(sp); }
public static StoredProcedure SP_SavePrivilege(string PrivilegeCode, string PrivilegeName, byte PrivilegeType, string Remark, string ParentID, string Uri, int Sequence, string LastUpdateUserUID, string LastUpdateUserName) { StoredProcedure sp = new StoredProcedure("SP_SavePrivilege"); sp.AddParameter("PrivilegeCode", PrivilegeCode, DbType.AnsiString); sp.AddParameter("PrivilegeName", PrivilegeName, DbType.String); sp.AddParameter("PrivilegeType", PrivilegeType, DbType.Byte); sp.AddParameter("Remark", Remark, DbType.String); sp.AddParameter("ParentID", ParentID, DbType.AnsiString); sp.AddParameter("Uri", Uri, DbType.AnsiString); sp.AddParameter("Sequence", Sequence, DbType.Int32); sp.AddParameter("LastUpdateUserUID", LastUpdateUserUID, DbType.AnsiString); sp.AddParameter("LastUpdateUserName", LastUpdateUserName, DbType.String); return(sp); }
public static StoredProcedure SP_SaveOrgInfo(string OrgCode,string OrgName,string ParentCode,string Remark,byte OrgType,int Sequence,string LastUpdateUserUID,string LastUpdateUserName) { StoredProcedure sp=new StoredProcedure("SP_SaveOrgInfo"); sp.AddParameter("OrgCode",OrgCode,DbType.AnsiString); sp.AddParameter("OrgName",OrgName,DbType.String); sp.AddParameter("ParentCode",ParentCode,DbType.AnsiString); sp.AddParameter("Remark",Remark,DbType.String); sp.AddParameter("OrgType",OrgType,DbType.Byte); sp.AddParameter("Sequence",Sequence,DbType.Int32); sp.AddParameter("LastUpdateUserUID",LastUpdateUserUID,DbType.AnsiString); sp.AddParameter("LastUpdateUserName",LastUpdateUserName,DbType.String); return sp; }
public static StoredProcedure SP_PAGESELECT(string SQLPARAMS,int PAGESIZE,int PAGEINDEX,string SQLTABLE,string SQLCOLUMNS,string SQLPK,string SQLORDER,int Count) { StoredProcedure sp=new StoredProcedure("SP_PAGESELECT"); sp.AddParameter("SQLPARAMS",SQLPARAMS,DbType.String); sp.AddParameter("PAGESIZE",PAGESIZE,DbType.Int32); sp.AddParameter("PAGEINDEX",PAGEINDEX,DbType.Int32); sp.AddParameter("SQLTABLE",SQLTABLE,DbType.AnsiString); sp.AddParameter("SQLCOLUMNS",SQLCOLUMNS,DbType.AnsiString); sp.AddParameter("SQLPK",SQLPK,DbType.AnsiString); sp.AddParameter("SQLORDER",SQLORDER,DbType.AnsiString); sp.AddParameter("Count",Count,DbType.Int32); return sp; }
public static StoredProcedure SP_SaveRoleInfo(int RoleID, string RoleCode, string RoleName, string Remark, int ParentID, bool IsSystem, string LastUpdateUserUID, string LastUpdateUserName) { StoredProcedure sp = new StoredProcedure("SP_SaveRoleInfo"); sp.AddParameter("RoleID", RoleID, DbType.Int32); sp.AddParameter("RoleCode", RoleCode, DbType.AnsiString); sp.AddParameter("RoleName", RoleName, DbType.String); sp.AddParameter("Remark", Remark, DbType.String); sp.AddParameter("ParentID", ParentID, DbType.Int32); sp.AddParameter("IsSystem", IsSystem, DbType.Boolean); sp.AddParameter("LastUpdateUserUID", LastUpdateUserUID, DbType.AnsiString); sp.AddParameter("LastUpdateUserName", LastUpdateUserName, DbType.String); return(sp); }
public static StoredProcedure SP_SaveOrgInfo(string OrgCode, string OrgName, string ParentCode, string Remark, byte OrgType, int Sequence, string LastUpdateUserUID, string LastUpdateUserName) { StoredProcedure sp = new StoredProcedure("SP_SaveOrgInfo"); sp.AddParameter("OrgCode", OrgCode, DbType.AnsiString); sp.AddParameter("OrgName", OrgName, DbType.String); sp.AddParameter("ParentCode", ParentCode, DbType.AnsiString); sp.AddParameter("Remark", Remark, DbType.String); sp.AddParameter("OrgType", OrgType, DbType.Byte); sp.AddParameter("Sequence", Sequence, DbType.Int32); sp.AddParameter("LastUpdateUserUID", LastUpdateUserUID, DbType.AnsiString); sp.AddParameter("LastUpdateUserName", LastUpdateUserName, DbType.String); return(sp); }
public static StoredProcedure SP_PAGESELECT(string SQLPARAMS, int PAGESIZE, int PAGEINDEX, string SQLTABLE, string SQLCOLUMNS, string SQLPK, string SQLORDER, int Count) { StoredProcedure sp = new StoredProcedure("SP_PAGESELECT"); sp.AddParameter("SQLPARAMS", SQLPARAMS, DbType.String); sp.AddParameter("PAGESIZE", PAGESIZE, DbType.Int32); sp.AddParameter("PAGEINDEX", PAGEINDEX, DbType.Int32); sp.AddParameter("SQLTABLE", SQLTABLE, DbType.AnsiString); sp.AddParameter("SQLCOLUMNS", SQLCOLUMNS, DbType.AnsiString); sp.AddParameter("SQLPK", SQLPK, DbType.AnsiString); sp.AddParameter("SQLORDER", SQLORDER, DbType.AnsiString); sp.AddParameter("Count", Count, DbType.Int32); return(sp); }
public static StoredProcedure SP_SaveRoleInfo(int RoleID,string RoleCode,string RoleName,string Remark,int ParentID,bool IsSystem,string LastUpdateUserUID,string LastUpdateUserName) { StoredProcedure sp=new StoredProcedure("SP_SaveRoleInfo"); sp.AddParameter("RoleID",RoleID,DbType.Int32); sp.AddParameter("RoleCode",RoleCode,DbType.AnsiString); sp.AddParameter("RoleName",RoleName,DbType.String); sp.AddParameter("Remark",Remark,DbType.String); sp.AddParameter("ParentID",ParentID,DbType.Int32); sp.AddParameter("IsSystem",IsSystem,DbType.Boolean); sp.AddParameter("LastUpdateUserUID",LastUpdateUserUID,DbType.AnsiString); sp.AddParameter("LastUpdateUserName",LastUpdateUserName,DbType.String); return sp; }
public static StoredProcedure SP_DeletePrivilege(string PrivilegeCode) { StoredProcedure sp=new StoredProcedure("SP_DeletePrivilege"); sp.AddParameter("PrivilegeCode",PrivilegeCode,DbType.AnsiString); return sp; }
public static StoredProcedure SP_DeleteUserInfo(string UserUID) { StoredProcedure sp=new StoredProcedure("SP_DeleteUserInfo"); sp.AddParameter("UserUID",UserUID,DbType.AnsiString); return sp; }
public static StoredProcedure SP_SavePrivilege(string PrivilegeCode,string PrivilegeName,byte PrivilegeType,string Remark,string ParentID,string Uri,int Sequence,string LastUpdateUserUID,string LastUpdateUserName) { StoredProcedure sp=new StoredProcedure("SP_SavePrivilege"); sp.AddParameter("PrivilegeCode",PrivilegeCode,DbType.AnsiString); sp.AddParameter("PrivilegeName",PrivilegeName,DbType.String); sp.AddParameter("PrivilegeType",PrivilegeType,DbType.Byte); sp.AddParameter("Remark",Remark,DbType.String); sp.AddParameter("ParentID",ParentID,DbType.AnsiString); sp.AddParameter("Uri",Uri,DbType.AnsiString); sp.AddParameter("Sequence",Sequence,DbType.Int32); sp.AddParameter("LastUpdateUserUID",LastUpdateUserUID,DbType.AnsiString); sp.AddParameter("LastUpdateUserName",LastUpdateUserName,DbType.String); return sp; }
public static StoredProcedure SP_SetRoleRolePrivilege(int RoleID,string AddIDs,string MinusIDs,string UserID,string UserName) { StoredProcedure sp=new StoredProcedure("SP_SetRoleRolePrivilege"); sp.AddParameter("RoleID",RoleID,DbType.Int32); sp.AddParameter("AddIDs",AddIDs,DbType.AnsiString); sp.AddParameter("MinusIDs",MinusIDs,DbType.AnsiString); sp.AddParameter("UserID",UserID,DbType.AnsiString); sp.AddParameter("UserName",UserName,DbType.String); return sp; }