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_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 SqlDataReader SPExecuteDataReader(StoredProcedure sp)
{
return SqlHelper.ExecuteReader(ConnectionString, CommandType.StoredProcedure, sp.SPName, sp.SPParams.ToArray());
}
public object SPExecuteScalar(StoredProcedure sp)
{
return SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, sp.SPName,sp.SPParams.ToArray());
}
public int SPExecuteNonQuery(StoredProcedure sp)
{
return SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, sp.SPName, sp.SPParams.ToArray());
}
public DataSet SPExecuteDataSet(StoredProcedure sp)
{
return SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, sp.SPName, sp.SPParams.ToArray());
}
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_DeleteUserInfo(string UserUID)
{
StoredProcedure sp=new StoredProcedure("SP_DeleteUserInfo");
sp.AddParameter("UserUID",UserUID,DbType.AnsiString);
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_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_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 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);
}