/// <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);
}
/// <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 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>
/// 添加一条记录
///</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);
}
