示例#1
0
 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;
 }
示例#2
0
 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;
 }
示例#3
0
 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;
 }
示例#4
0
 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;
 }
示例#5
0
 public SqlDataReader SPExecuteDataReader(StoredProcedure sp)
 {
     return SqlHelper.ExecuteReader(ConnectionString, CommandType.StoredProcedure, sp.SPName, sp.SPParams.ToArray());
 }
示例#6
0
 public object SPExecuteScalar(StoredProcedure sp)
 {
     return SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, sp.SPName,sp.SPParams.ToArray());
 }
示例#7
0
 public int SPExecuteNonQuery(StoredProcedure sp)
 {
     return SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, sp.SPName, sp.SPParams.ToArray());
 }
示例#8
0
 public DataSet SPExecuteDataSet(StoredProcedure sp)
 {
     return SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, sp.SPName, sp.SPParams.ToArray());
 }
示例#9
0
 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;
 }
示例#10
0
 public static StoredProcedure SP_DeleteUserInfo(string UserUID)
 {
     StoredProcedure sp=new StoredProcedure("SP_DeleteUserInfo");
     sp.AddParameter("UserUID",UserUID,DbType.AnsiString);
     return sp;
 }
示例#11
0
 public static StoredProcedure SP_DeletePrivilege(string PrivilegeCode)
 {
     StoredProcedure sp=new StoredProcedure("SP_DeletePrivilege");
     sp.AddParameter("PrivilegeCode",PrivilegeCode,DbType.AnsiString);
     return sp;
 }
示例#12
0
 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;
 }
示例#13
0
 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;
 }
示例#14
0
        public void SaveOrgInfo(Organization d)
        {
            StoredProcedure sp = StoredProcedures.SP_SaveOrgInfo(d.OrgCode, d.OrgName, d.ParentCode, d.Remark, d.OrgType, d.Sequence, d.LastUpdateUserUID, d.LastUpdateUserName);

            base.SPExecuteNonQuery(sp);
        }