/// <summary> /// 增加一条数据 /// </summary> public bool Add(DutyInfo model,out int DutyID) { string procName = "OA_SP_SM_Duty_ADD"; LogBuilder log = new LogBuilder(); MssqlDatabase Mssql = null; #region 日志信息 log.Desc = "添加职务"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("DutyInfo", model); #endregion DutyID = 0; try { Mssql = new MssqlDatabase(); int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@DutyID", SqlDbType.Int,4), new SqlParameter("@DutyName", SqlDbType.VarChar,50), new SqlParameter("@DepID", SqlDbType.Int,4), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@State", SqlDbType.Int,4), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@Creator", SqlDbType.Int,4)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.DutyName; parameters[2].Value = model.DepID; parameters[3].Value = model.Remark; parameters[4].Value = model.State; parameters[5].Value = model.Created; parameters[6].Value = model.Creator; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { if (parameters[0] != null) { DutyID = (int)parameters[0].Value; log.Append("DutyID", DutyID, ParamDirection.OUT); } } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); if (Mssql != null) { Mssql.Close(); } } return DutyID > 0; }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int DutyID) { string procName = "OA_SP_SM_Duty_Delete"; LogBuilder log = new LogBuilder(); MssqlDatabase Mssql = null; #region 日志信息 log.Desc = "删除职位"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("DutyID", DutyID); #endregion try { Mssql = new MssqlDatabase(); int rowsAffected=0; SqlParameter[] parameters = { new SqlParameter("@DutyID", SqlDbType.Int,4) }; parameters[0].Value = DutyID; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { return true; } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); if (Mssql != null) { Mssql.Close(); } } return false; }
/// <summary> /// 查询职位列表 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="totalRows"></param> /// <param name="ParentID">上级ID</param> /// <returns></returns> public IList<DutyInfo> GetList(int pageSize, int pageIndex, out int totalRows) { List<DutyInfo> DutyList = null; DutyInfo ui = null; totalRows = 0; string procName = "OA_SP_SM_Duty_GetList"; MssqlDatabase Mssql = null; LogBuilder log = new LogBuilder(); try { Mssql = new MssqlDatabase(); #region 日志信息 log.Desc = "查询职位列表"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("PageSize", pageSize.ToString()); log.Append("PageIndex", pageIndex.ToString()); #endregion SqlParameter[] param ={ Mssql.MakeInParam("@PageSize", SqlDbType.Int,4, pageSize), Mssql.MakeInParam("@PageIndex", SqlDbType.Int,4,pageIndex), Mssql.MakeOutParam("@TotalRows",SqlDbType.Int,4) }; DataTable dt = null; Mssql.ExecuteProc(procName, param, out dt); totalRows = SqlComponents.ReaderGetInt32(param[3].Value); log.Append("TotalRows", totalRows.ToString(), ParamDirection.INOUT); if (dt != null && dt.Rows.Count > 0) { DutyList = new List<DutyInfo>(); for (int i = 0; i < dt.Rows.Count; i++) { ui = new DutyInfo(); ui.RowId = SqlComponents.ReaderGetInt32(dt.Rows[i]["rowid"]); ui.DepID = SqlComponents.ReaderGetInt32(dt.Rows[i]["DepID"]); ui.DutyID = SqlComponents.ReaderGetInt32(dt.Rows[i]["DutyID"]); ui.State = SqlComponents.ReaderGetInt32(dt.Rows[i]["State"]); ui.DutyName = SqlComponents.ReaderGetString(dt.Rows[i]["DutyName"]); ui.Remark = SqlComponents.ReaderGetString(dt.Rows[i]["Remark"]); DutyList.Add(ui); } } return DutyList; } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); if (Mssql != null) { Mssql.Close(); } } return null; }
/// <summary> /// 得到一个对象实体 /// </summary> public DutyInfo GetDutyInfo(int DutyID) { DutyInfo model = null; string procName = "OA_SP_SM_Duty_GetModel"; LogBuilder log = new LogBuilder(); MssqlDatabase Mssql = null; #region 日志信息 log.Desc = "获取职位信息"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("DutyID", DutyID); #endregion try { Mssql = new MssqlDatabase(); SqlParameter[] parameters = { new SqlParameter("@DutyID", SqlDbType.Int,4) }; parameters[0].Value = DutyID; DataTable dt = Mssql.ExecuteProcDt(procName, parameters); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; model = new DutyInfo(); model.DutyID = DutyID; model.DutyName = SqlComponents.ReaderGetString(dr["DutyName"]); model.DepID = SqlComponents.ReaderGetInt32(dr["DepID"]); model.Remark = SqlComponents.ReaderGetString(dr["Remark"]); model.State = SqlComponents.ReaderGetInt32(dr["State"]); return model; } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); if (Mssql != null) { Mssql.Close(); } } return null; }
/// <summary> /// 添加用用户信息 /// </summary> /// <param name="user"></param> /// <param name="UserID"></param> /// <returns></returns> public bool AddUser(UserInfo user, out int UserID) { UserID = 0; string procName = "OA_SP_SM_User_Add"; LogBuilder log = new LogBuilder(); #region 日志信息 log.Desc = "添加用用户信息"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("UserInfo", user); #endregion try { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@UserAccount", SqlDbType.VarChar,50), new SqlParameter("@Pwd", SqlDbType.VarChar,50), new SqlParameter("@UserName", SqlDbType.VarChar,50), new SqlParameter("@DepID", SqlDbType.Int,10), new SqlParameter("@DutyID", SqlDbType.Int,10), new SqlParameter("@Email", SqlDbType.VarChar,100), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@Creator", SqlDbType.Int,10), new SqlParameter("@UserID", SqlDbType.Int,10) }; parameters[0].Value = user.UserAccount; parameters[1].Value = user.Pwd; parameters[2].Value = user.UserName; parameters[3].Value = user.DepID; parameters[4].Value = user.DutyID; parameters[5].Value = user.Email; parameters[6].Value = user.Remark; parameters[7].Value = user.Creator; parameters[8].Direction = ParameterDirection.Output; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { if (parameters[0] != null) { UserID = (int)parameters[8].Value; log.Append("UserID", UserID, ParamDirection.OUT); } } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); } return UserID > 0; }
/// <summary> /// 编辑用户信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public bool UpdateUser(UserInfo user) { string procName = "OA_SP_SM_User_Update"; LogBuilder log = new LogBuilder(); #region 日志信息 log.Desc = "更新职位"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("UserInfo", user); #endregion try { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int,10), new SqlParameter("@UserName", SqlDbType.VarChar,50), new SqlParameter("@DepID", SqlDbType.Int,10), new SqlParameter("@DutyID", SqlDbType.Int,10), new SqlParameter("@Email", SqlDbType.VarChar,100), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@Modifier", SqlDbType.Int,10)}; parameters[0].Value = user.UserID; parameters[1].Value = user.UserName; parameters[2].Value = user.DepID; parameters[3].Value = user.DutyID; parameters[4].Value = user.Email; parameters[5].Value = user.Remark; parameters[6].Value = user.Creator; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { return true; } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); } return false; }
/// <summary> /// 删除用户 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public bool DeleteUser(int UserID) { string procName = "OA_SP_SM_User_Delete"; LogBuilder log = new LogBuilder(); #region 日志信息 log.Desc = "删除用户"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("UserID", UserID); #endregion try { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int,10) }; parameters[0].Value = UserID; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { return true; } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); } return false; }
/// <summary> /// ����һ������ /// </summary> public bool Update(DepartmentInfo model) { string procName = "OA_SP_SM_Department_Update"; LogBuilder log = new LogBuilder(); #region ��־��Ϣ log.Desc = "���²���"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("DepartmentInfo", model); #endregion try { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@DepID", SqlDbType.Int,4), new SqlParameter("@DepName", SqlDbType.VarChar,50), new SqlParameter("@ParentID", SqlDbType.Int,4), new SqlParameter("@Remark", SqlDbType.VarChar,200), new SqlParameter("@State", SqlDbType.Int,4), new SqlParameter("@ModifyTime", SqlDbType.DateTime,4), new SqlParameter("@ModityUesrID", SqlDbType.Int,4)}; parameters[0].Value = model.DepID; parameters[1].Value = model.DepName; parameters[2].Value = model.ParentID; parameters[3].Value = model.Remark; parameters[4].Value = model.State; parameters[5].Value = model.Created; parameters[6].Value = model.Creator; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { return true; } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); } return false; }
/// <summary> /// ��鲿���Ƿ��Ѿ����� /// </summary> /// <param name="DepID">����ʱ��0 </param> /// <param name="DepName"></param> /// <returns></returns> public bool Exists(int DepID, string DepName) { string procName = "OA_SP_SM_Department_Exists"; LogBuilder log = new LogBuilder(); #region ��־��Ϣ log.Desc = "��鲿���Ƿ��Ѿ�����"; log.Method = MethodBase.GetCurrentMethod().Name; log.Path = MethodBase.GetCurrentMethod().DeclaringType.FullName; log.StroreProcedure = procName; log.Append("DepID", DepID); log.Append("DeptName", DepName); #endregion try { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@DepID", SqlDbType.Int,4), new SqlParameter("@DepName", SqlDbType.VarChar,50)}; parameters[0].Value = DepID; parameters[1].Value = DepName; Mssql.ExecuteProc(procName, parameters, out rowsAffected); if (rowsAffected > 0) { return true; } } catch (Exception ex) { log.Exception = ex.ToString(); log.Error(); } finally { log.Debug(); } return false; }