/// <summary> /// 加薪提示表列表展示 /// </summary> /// <param name="page"></param> /// <param name="rows"></param> /// <param name="txtBM"></param> /// <returns></returns> public ActionResult ShowAdjust(int page, int rows, string txtBM) { int total; List <TBL_GZMXB> list = TBL_GZMXBService.GetPageListEx(page, rows, txtBM, out total); return(Content(SerializeHelper.SerializeToList(total, list).Callback())); }
/// <summary> /// 基本工资表列表展示 /// </summary> /// <param name="rows"></param> /// <param name="page"></param> /// <param name="searchModel"></param> /// <returns></returns> public ActionResult ShowModify(int rows, int page, TBL_GZMXBSearch searchModel) { searchModel.PageIndex = page; searchModel.PageSize = rows; var list = TBL_GZMXBService.LoadSerachEntities(searchModel); return(Content(SerializeHelper.SerializeToList(searchModel.TotalCount, list).Callback())); }
/// <summary> /// 基本工资表增加 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult Add(TBL_GZMXB model) { int maxId = TBL_GZMXBService.GetMaxId("ID", "TBL_GZMXB"); model.ID = maxId.ToString(); TBL_GZMXBService.AddEntity(model); return(Content("ok")); }
/// <summary> /// 基本工资表删除 /// </summary> /// <param name="ID"></param> /// <returns></returns> public ActionResult Remove(string ID) { var model = TBL_GZMXBService.LoadEntities(t => t.ID.Equals(ID)).FirstOrDefault(); if (TBL_GZMXBService.DeleteEntity(model)) { TBL_GZMXB_LOGService.DeleteEntitys(ID); return(Content(SerializeHelper.SerializeToString(new { success = "ok" }).Callback())); } else { return(Content(SerializeHelper.SerializeToString(new { success = "no" }).Callback())); } }
public ActionResult statistics(DateTime?txtTjrq, string txtBM, int rows, int page) { TBL_GZMXBService.GetPageListEx(); if (txtTjrq == null) { return(Content(SerializeHelper.SerializeToList(0, new List <Model.TBL_GZMXB_TJ>()).Callback())); } DateTime tjrq = Convert.ToDateTime(txtTjrq); int total; IQueryable <Model.TBL_GZMXB_TJ> list; if (string.IsNullOrEmpty(txtBM)) { list = TBL_GZMXB_TJService.LoadPageEntities(page, rows, out total, t => t.TJRQ.Year == tjrq.Year && t.TJRQ.Month == tjrq.Month, t => t.XM); } else { list = TBL_GZMXB_TJService.LoadPageEntities(page, rows, out total, t => t.TJRQ.Year == tjrq.Year && t.TJRQ.Month == tjrq.Month && t.BM == txtBM, t => t.XM); } return(Content(SerializeHelper.SerializeToList(total, list).Callback())); }
/// <summary> /// 加薪提示表执行加工资 /// </summary> /// <param name="data"></param> /// <returns></returns> public ActionResult Define(string data) { List <TBL_GZMXB_PARTIAL> list = SerializeHelper.DeserializeToObject <List <TBL_GZMXB_PARTIAL> >(data); foreach (TBL_GZMXB_PARTIAL item in list) { TBL_GZMXB model = TBL_GZMXBService.LoadEntities(t => t.ID == item.ID).FirstOrDefault(); TBL_GZMXB_TJ tjModel = TBL_GZMXB_TJService.LoadEntities(t => t.MID == item.ID).OrderByDescending(t => t.TJRQ).FirstOrDefault(); if (!(item.BYXZJBGZ == null && item.BYXZGWGZ == null)) { TBL_GZMXB_LOG logModel = new TBL_GZMXB_LOG() { ID = TBL_GZMXB_LOGService.GetMaxId("ID", "TBL_GZMXB_LOG"), XM = model.XM, BZ = model.BZ, MID = model.ID, JBGZ = model.JBGZ, GWGZ = model.GWGZ, JTBZ = model.JTBZ, HSBZ = model.HSBZ, HJ = Convert.ToDecimal(model.HJ) + Convert.ToDecimal(item.BYXZJBGZ) + Convert.ToDecimal(item.BYXZGWGZ), BYXZJBGZ = item.BYXZJBGZ, BYXZGWGZ = item.BYXZGWGZ, ZXSJ = DateTime.Now }; TBL_GZMXB_LOGService.AddEntity(logModel); } model.BYXZJBGZ = item.BYXZJBGZ; model.BYXZGWGZ = item.BYXZGWGZ; model.FLAG = item.YEARLESS; model.ZXSJ = DateTime.Now; if (model.JBGZ == null) { model.JBGZ = item.BYXZJBGZ; } else { if (item.BYXZJBGZ != null) { model.JBGZ += item.BYXZJBGZ; } } if (model.GWGZ == null) { model.GWGZ = item.BYXZGWGZ; } else { if (item.BYXZGWGZ != null) { model.GWGZ += item.BYXZGWGZ; } } decimal?sum = 0; if (model.JBGZ != null) { sum += model.JBGZ; } if (model.GWGZ != null) { sum += model.GWGZ; } if (model.HSBZ != null) { sum += model.HSBZ; } if (model.JTBZ != null) { sum += model.JTBZ; } if (sum == 0) { sum = null; } model.HJ = sum; TBL_GZMXBService.EditEntity(model); EntityHelper.EntityToEntity(model, tjModel, "ID", "TJRQ", "MID"); TBL_GZMXB_TJService.EditEntity(tjModel); } return(Content(SerializeHelper.SerializeToString(new { success = "ok" }).Callback())); }
/// <summary> /// 基本工资表查看 /// </summary> /// <param name="ID"></param> /// <returns></returns> public new ActionResult View(string ID) { var model = TBL_GZMXBService.LoadEntities(t => t.ID.Equals(ID)).FirstOrDefault(); return(Content(SerializeHelper.SerializeToString(model).Callback())); }
/// <summary> /// 基本工资表编辑 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult Edit(TBL_GZMXB model) { TBL_GZMXBService.EditEntity(model); return(Content("ok")); }