/// <summary>
/// 添加一条记录
///</summary>
public int Edit(SysUserEntity model)
{
int result = 0;
DbParameters.Clear();
ProcedureName = "up_Tb_SysUser_Add";
DataAccessChannelProtection = true;
DbParameters.Add(new DatabaseParameter("result", result, DatabaseType.SQL_Int, 4, ParameterDirection.Output));
DbParameters.Add(new DatabaseParameter("SysID", model.SysID, DatabaseType.SQL_NVarChar, 40));
DbParameters.Add(new DatabaseParameter("SysUserName", model.SysUserName, DatabaseType.SQL_NVarChar, 30));
DbParameters.Add(new DatabaseParameter("RealName", model.RealName, DatabaseType.SQL_NVarChar, 30));
DbParameters.Add(new DatabaseParameter("SysPwd", model.SysPwd, DatabaseType.SQL_NVarChar, 100));
DbParameters.Add(new DatabaseParameter("CellPhone", model.CellPhone, DatabaseType.SQL_NVarChar, 50));
DbParameters.Add(new DatabaseParameter("WeiXin", model.WeiXin, DatabaseType.SQL_NVarChar, 100));
DbParameters.Add(new DatabaseParameter("CreateUser", model.CreateUser, DatabaseType.SQL_NVarChar, 40));
DbParameters.Add(new DatabaseParameter("UserState", model.UserState, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Isdel", model.Isdel, DatabaseType.SQL_Int, 4));
STMessage stmessage = ExecuteStoredProcedure(DataOperationValue.IDU_OPERATION).DataReturn;
if (stmessage.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
DataAccessChannel.CommitRelease();
DataAccessChannelProtection = false;
result = Convert.ToInt32(DbParameters[0].Value);
return(result);
}
/// <summary>
/// 添加一条记录
///</summary>
public int Edit(DepartmentEntity model)
{
int result = 0;
DbParameters.Clear();
ProcedureName = "up_Tb_Department_Add";
DataAccessChannelProtection = true;
DbParameters.Add(new DatabaseParameter("result", result, DatabaseType.SQL_Int, 4, ParameterDirection.Output));
DbParameters.Add(new DatabaseParameter("DID", model.DID, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("DepName", model.DepName, DatabaseType.SQL_NVarChar, 50));
DbParameters.Add(new DatabaseParameter("Master", model.Master, DatabaseType.SQL_NVarChar, 40));
DbParameters.Add(new DatabaseParameter("PID", model.PID, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("DepOrder", model.DepOrder, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("DepType", model.DepType, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("DepMark", model.DepMark, DatabaseType.SQL_NVarChar, 500));
DbParameters.Add(new DatabaseParameter("Isdel", model.Isdel, DatabaseType.SQL_Int, 4));
STMessage stmessage = ExecuteStoredProcedure(DataOperationValue.IDU_OPERATION).DataReturn;
if (stmessage.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
DataAccessChannel.CommitRelease();
DataAccessChannelProtection = false;
result = Convert.ToInt32(DbParameters[0].Value);
return(result);
}
public EmployeeEntity GetObj(string id)
{
DbParameters.Clear();
ProcedureName = "up_Tb_Employee_Get";
DbParameters.Add(new DatabaseParameter("EID", id, DatabaseType.SQL_NVarChar, 40));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
return(First());
}
/// <summary>
/// 根据编号（主键）获取项:返回实体对象
/// </summary>
/// <returns></returns>
public DepartmentEntity GetObjByID(int id)
{
DbParameters.Clear();
ProcedureName = "up_Tb_Department_Get";
DbParameters.Add(new DatabaseParameter("DID", id, DatabaseType.SQL_Int, 4));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
return(First());
}
/// <summary>
/// 登录
/// </summary>
/// <returns></returns>
public SysUserEntity UserLogin(string uname, string pwd)
{
DbParameters.Clear();
ProcedureName = "up_Tb_SysUser_Login";
DbParameters.Add(new DatabaseParameter("SysUserName", uname, DatabaseType.SQL_NVarChar, 100));
DbParameters.Add(new DatabaseParameter("SysPwd", pwd, DatabaseType.SQL_NVarChar, 100));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
return(First());
}
public DataTable GetTable(int isdel, int pid, int deptype)
{
DbParameters.Clear();
ProcedureName = "up_Tb_Department_GetList";
DbParameters.Add(new DatabaseParameter("DepType", deptype, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Isdel", isdel, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("PID", pid, DatabaseType.SQL_Int, 4));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
return(DataReflectionContainer);
}
/// <summary>
/// 根据实体条件分页获取数据集，返回DataSet
/// </summary>
/// <param name="pagesize">每页显示条数</param>
/// <param name="pageindex">当前页码,从1开始</param>
/// <param name="recordCount">为-1时统计满足条件的记录总数</param>
/// <param name="model">条件实体</param>
public DataTable GetPaged(int pagesize, int pageindex, ref int recordCount, DepartmentEntity model)
{
DbParameters.Clear();
ProcedureName = "up_Tb_Department_Paged";
DbParameters.Add(new DatabaseParameter("pagesize", pagesize, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("pageindex", pageindex, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("recordCount", recordCount, DatabaseType.SQL_Int, 4, ParameterDirection.Output));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
recordCount = Convert.ToInt32(DbParameters[2].Value);
return(DataReflectionContainer);
}
/// <summary>
/// 根据主键编号集合删除记录
///</summary>
public int DeleteBat(string ids, int isdel)
{
DbParameters.Clear();
ProcedureName = "up_Tb_Department_DelBat";
DataAccessChannelProtection = true;
DbParameters.Add(new DatabaseParameter("Ids", ids, DatabaseType.SQL_NVarChar, 2000));
DbParameters.Add(new DatabaseParameter("Isdel", isdel, DatabaseType.SQL_Int, 4));
STMessage stmessage = ExecuteStoredProcedure(DataOperationValue.IDU_OPERATION).DataReturn;
if (stmessage.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
DataAccessChannel.CommitRelease();
DataAccessChannelProtection = false;
return(stmessage.AffectRows);
}
/// <summary>
/// 修改密码
///</summary>
public int PwdSet(string Ids, string pwd)
{
DbParameters.Clear();
ProcedureName = "up_Tb_SysUser_PwdSet";
DataAccessChannelProtection = true;
DbParameters.Add(new DatabaseParameter("Ids", Ids, DatabaseType.SQL_NVarChar, 2000));
DbParameters.Add(new DatabaseParameter("PassWord", pwd, DatabaseType.SQL_NVarChar, 100));
STMessage stmessage = ExecuteStoredProcedure(DataOperationValue.IDU_OPERATION).DataReturn;
if (stmessage.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
DataAccessChannel.CommitRelease();
DataAccessChannelProtection = false;
return(stmessage.AffectRows);
}
/// <summary>
/// 根据实体条件分页获取数据集，返回DataSet
/// </summary>
/// <param name="pagesize">每页显示条数</param>
/// <param name="pageindex">当前页码,从1开始</param>
/// <param name="recordCount">为-1时统计满足条件的记录总数</param>
/// <param name="model">条件实体</param>
public DataTable GetPaged(int pagesize, int pageindex, ref int recordCount, string realname, int roleid, int isdel)
{
DbParameters.Clear();
ProcedureName = "up_Tb_SysUser_Paged";
DbParameters.Add(new DatabaseParameter("pagesize", pagesize, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("pageindex", pageindex, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("recordCount", recordCount, DatabaseType.SQL_Int, 4, ParameterDirection.Output));
DbParameters.Add(new DatabaseParameter("RealName", realname, DatabaseType.SQL_NVarChar, 50));
DbParameters.Add(new DatabaseParameter("RoleID", roleid, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Isdel", isdel, DatabaseType.SQL_Int, 4));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
recordCount = Convert.ToInt32(DbParameters[2].Value);
return(DataReflectionContainer);
}
/// <summary>
/// 根据实体条件分页获取数据集，返回DataSet
/// </summary>
/// <param name="pagesize">每页显示条数</param>
/// <param name="pageindex">当前页码,从1开始</param>
/// <param name="recordCount">为-1时统计满足条件的记录总数</param>
/// <param name="model">条件实体</param>
public DataTable GetPaged(int pagesize, int pageindex, ref int recordCount, SysLogEntity model, DateTime begin, DateTime end)
{
DbParameters.Clear();
ProcedureName = "up_Tb_SysLog_Paged";
DbParameters.Add(new DatabaseParameter("pagesize", pagesize, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("pageindex", pageindex, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("recordCount", recordCount, DatabaseType.SQL_Int, 4, ParameterDirection.Output));
DbParameters.Add(new DatabaseParameter("Begin", begin, DatabaseType.SQL_DateTime, 8));
DbParameters.Add(new DatabaseParameter("End", end, DatabaseType.SQL_DateTime, 8));
DbParameters.Add(new DatabaseParameter("CreateUser", model.CreateUser, DatabaseType.SQL_NVarChar, 40));
DbParameters.Add(new DatabaseParameter("LogType", model.LogType, DatabaseType.SQL_Int, 4));
if (ExecuteStoredProcedure(DataOperationValue.SEL_OPERATION).DataReturn.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
recordCount = Convert.ToInt32(DbParameters[2].Value);
return(DataReflectionContainer);
}
/// <summary>
/// 添加一条记录
///</summary>
public int Edit(SysLogEntity model)
{
DbParameters.Clear();
ProcedureName = "up_Tb_SysLog_Add";
DataAccessChannelProtection = true;
DbParameters.Add(new DatabaseParameter("LogType", model.LogType, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("LogContent", model.LogContent, DatabaseType.SQL_NVarChar, 200));
DbParameters.Add(new DatabaseParameter("CreateUser", model.CreateUser, DatabaseType.SQL_NVarChar, 40));
STMessage stmessage = ExecuteStoredProcedure(DataOperationValue.IDU_OPERATION).DataReturn;
if (stmessage.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
DataAccessChannel.CommitRelease();
DataAccessChannelProtection = false;
return(stmessage.AffectRows);
}
/// <summary>
/// 添加一条记录
///</summary>
public int Edit(EmployeeEntity model)
{
//int result = 0;
DbParameters.Clear();
ProcedureName = "up_Tb_Employee_Add";
DataAccessChannelProtection = true;
//DbParameters.Add(new DatabaseParameter("result", result, DatabaseType.SQL_Int, 4, ParameterDirection.Output));
DbParameters.Add(new DatabaseParameter("EID", model.EID, DatabaseType.SQL_NVarChar, 40));
DbParameters.Add(new DatabaseParameter("RealName", model.RealName, DatabaseType.SQL_NVarChar, 30));
DbParameters.Add(new DatabaseParameter("Sex", model.Sex, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Birthdate", model.Birthdate, DatabaseType.SQL_DateTime, 8));
DbParameters.Add(new DatabaseParameter("CreateUser", model.CreateUser, DatabaseType.SQL_NVarChar, 40));
DbParameters.Add(new DatabaseParameter("Nationality", model.Nationality, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Polity", model.Polity, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Begindate", model.Begindate, DatabaseType.SQL_DateTime, 8));
DbParameters.Add(new DatabaseParameter("EType", model.EType, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("DepID", model.DepID, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("PostID", model.PostID, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("JobName", model.JobName, DatabaseType.SQL_NVarChar, 100));
DbParameters.Add(new DatabaseParameter("EmpCode", model.EmpCode, DatabaseType.SQL_NVarChar, 20));
DbParameters.Add(new DatabaseParameter("Censusaddr", model.Censusaddr, DatabaseType.SQL_NVarChar, 500));
DbParameters.Add(new DatabaseParameter("periodDay", model.periodDay, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("CorrectionDate", model.CorrectionDate, DatabaseType.SQL_DateTime, 8));
DbParameters.Add(new DatabaseParameter("EState", model.EState, DatabaseType.SQL_Int, 4));
DbParameters.Add(new DatabaseParameter("Isdel", model.Isdel, DatabaseType.SQL_Int, 4));
STMessage stmessage = ExecuteStoredProcedure(DataOperationValue.IDU_OPERATION).DataReturn;
if (stmessage.SqlCode != 0)
{
throw new Exception(DataReturn.SqlMessage);
}
DataAccessChannel.CommitRelease();
DataAccessChannelProtection = false;
//result = Convert.ToInt32(DbParameters[0].Value);
return(stmessage.AffectRows);
}