/// <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); }