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