/// <summary> /// 查看数据绑定 /// </summary> private void Bind() { tid = Utils.GetInt(Utils.GetQueryStringValue("tid"), 0); if (tid > 0) { wrModel = wrBll.GetModel(tid); if (wrModel.OperatorId == SiteUserInfo.ID || dBll.JudgePermission(wrModel.OperatorId, SiteUserInfo.ID) > 0) { isshow = true; } } }
/// <summary> /// 修改 /// </summary> /// <param name="model">工作汇报实体</param> /// <returns>true:成功 false:失败</returns> public bool Update(EyouSoft.Model.PersonalCenterStructure.WorkReport model) { dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString); EyouSoft.Data.WorkReport obj = dcDal.WorkReport.FirstOrDefault(item => item.ReportId == model.ReportId); if (obj != null) { obj.CompanyId = model.CompanyId; obj.DepartmentId = model.DepartmentId; obj.Description = model.Description; obj.FilePath = model.FilePath; obj.ReportId = model.ReportId; obj.Status = (byte)model.Status; obj.Title = model.Title; dcDal.SubmitChanges(); } return(dcDal.ChangeConflicts.Count == 0 ? true : false); }
/// <summary> /// 审核工作计划 /// </summary> private void Check() { bool res = false; tid = Utils.GetInt(Utils.GetFormValue("tid")); if (tid > 0) { wrModel = wrBll.GetModel(tid); if (wrModel.OperatorId != SiteUserInfo.ID) { int sta = Utils.GetInt(Utils.GetFormValue("status"), 0); string comment = Utils.GetFormValue("comment"); res = wrBll.SetChecked(tid, (EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState)sta, comment); } } Response.Clear(); Response.Write(string.Format("{{\"res\":{0}}}", res?1:-1)); Response.End(); }
/// <summary> /// 添加 /// </summary> /// <param name="model">工作汇报实体</param> /// <returns>true:成功 false:失败</returns> public bool Add(EyouSoft.Model.PersonalCenterStructure.WorkReport model) { dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString); EyouSoft.Data.WorkReport obj = new EyouSoft.Data.WorkReport() { CompanyId = model.CompanyId, DepartmentId = model.DepartmentId, Description = model.Description, FilePath = model.FilePath, OperatorId = model.OperatorId, OperatorName = model.OperatorName, Status = (byte)model.Status, Title = model.Title, ReportingTime = model.ReportingTime, CheckerId = 0, IsDelete = "0" }; dcDal.WorkReport.InsertOnSubmit(obj); dcDal.SubmitChanges(); return(dcDal.ChangeConflicts.Count == 0 ? true : false); }
/// <summary> /// 修改 /// </summary> /// <param name="model">工作汇报实体</param> /// <returns>true:成功 false:失败</returns> public bool Update(EyouSoft.Model.PersonalCenterStructure.WorkReport model) { if (model == null) { return(false); } bool Result = idal.Update(model); if (Result) { HandleLogsBll.Add( new EyouSoft.Model.CompanyStructure.SysHandleLogs() { ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.个人中心_工作交流, EventCode = Model.CompanyStructure.SysHandleLogsNO.EventCode, EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + Model.EnumType.CompanyStructure.SysPermissionClass.个人中心_工作交流.ToString() + "修改了工作交流!编号为:" + model.ReportId, EventTitle = "修改" + Model.EnumType.CompanyStructure.SysPermissionClass.个人中心_工作交流.ToString() + "数据" }); } return(Result); }
/// <summary> /// 分页工作交流集合 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="CompanyId">公司编号 =0返回所有</param> /// <param name="OperatorId">操作人编号</param> /// <param name="QueryInfo">工作汇报查询实体</param> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkReport QueryInfo) { IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> list = new List <EyouSoft.Model.PersonalCenterStructure.WorkReport>(); string tableName = "tbl_WorkReport"; string fields = "ReportId,Title,ReportingTime,OperatorName,Status,(select DepartName from tbl_CompanyDepartment where Id=tbl_WorkReport.DepartmentId) as DepartName "; string primaryKey = "ReportId"; string orderbyStr = " ReportingTime DESC "; StringBuilder strWhere = new StringBuilder(" IsDelete='0' "); if (CompanyId > 0) { strWhere.AppendFormat(" and CompanyId={0} ", CompanyId); } if (OperatorId > 0) { strWhere.AppendFormat(" and ((dbo.fn_ValidUserLevDepartManagers({0},OperatorId)>0) OR (OperatorId={0})) ", OperatorId); } if (QueryInfo != null) { if (!string.IsNullOrEmpty(QueryInfo.Title)) { strWhere.AppendFormat(" and Title like '%{0}%' ", QueryInfo.Title); } if (!string.IsNullOrEmpty(QueryInfo.OperatorName)) { strWhere.AppendFormat(" and OperatorName like '%{0}%' ", QueryInfo.OperatorName); } if (QueryInfo.DepartmentId > 0) { strWhere.AppendFormat(" and DepartmentId={0} ", QueryInfo.DepartmentId); } if (QueryInfo.CreateSDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,ReportingTime,'{0}')<=0 ", QueryInfo.CreateSDate.Value.ToString()); } if (QueryInfo.CreateEDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,ReportingTime,'{0}')>=0 ", QueryInfo.CreateEDate.Value.ToString()); } } using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref RecordCount, tableName, primaryKey, fields, strWhere.ToString(), orderbyStr)) { while (dr.Read()) { EyouSoft.Model.PersonalCenterStructure.WorkReport model = new EyouSoft.Model.PersonalCenterStructure.WorkReport(); if (!dr.IsDBNull(dr.GetOrdinal("ReportId"))) { model.ReportId = dr.GetInt32(dr.GetOrdinal("ReportId")); } if (!dr.IsDBNull(dr.GetOrdinal("Title"))) { model.Title = dr[dr.GetOrdinal("Title")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorName"))) { model.OperatorName = dr[dr.GetOrdinal("OperatorName")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("DepartName"))) { model.DepartmentName = dr[dr.GetOrdinal("DepartName")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Status"))) { model.Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState) int.Parse(dr[dr.GetOrdinal("Status")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ReportingTime"))) { model.ReportingTime = dr.GetDateTime(dr.GetOrdinal("ReportingTime")); } list.Add(model); model = null; } } return(list); }
/// <summary> /// 保存修改 /// </summary> private void Save() { tid = EyouSoft.Common.Utils.GetInt(Utils.GetFormValue("tid")); if (tid > 0)//修改得到实体 { wrModel = wrBll.GetModel(tid); } else//新增初使化 { wrModel.ReportingTime = DateTime.Now; wrModel.OperatorName = this.SiteUserInfo.ContactInfo.ContactName; wrModel.DepartmentId = SiteUserInfo.DepartId; wrModel.DepartmentName = this.SiteUserInfo.DepartName; wrModel.OperatorId = this.SiteUserInfo.ID; wrModel.CompanyId = this.CurrentUserCompanyID; wrModel.Status = EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState.未审核; wrModel.DepartmentId = this.SiteUserInfo.DepartId; } wrModel.Title = Utils.GetFormValue("title"); wrModel.Description = Utils.EditInputText(Request.Form["description"]); if (Request.Files.Count > 0) { string filepath = string.Empty; string oldfilename = string.Empty; bool result = EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["upfile"], "UserCenterFile", out filepath, out oldfilename); if (result) { wrModel.FilePath = filepath; } } bool res = false; if (tid > 0) { //修改 res = wrBll.Update(wrModel); } else { //新增 res = wrBll.Add(wrModel); } if (res) { string conti = Utils.GetFormValue("continue"); if (conti == "continue") { MessageBox.ShowAndRedirect(this, "操作成功!", "WorkReportAdd.aspx"); } else { MessageBox.ShowAndRedirect(this, "操作成功!", "WorkReport.aspx"); } } else { MessageBox.ShowAndReturnBack(this, "操作失败!", 1); } }
/// <summary> /// 修改数据绑定 /// </summary> private void Bind() { tid = Utils.GetInt(Utils.GetQueryStringValue("tid"), 0); wrModel = wrBll.GetModel(tid); }