private List <TBL_GZMXB> GetTempList() { decimal MAXCQ = Convert.ToDecimal(ConfigHelper.Get("MAXCQ")); decimal MAXQT = Convert.ToDecimal(ConfigHelper.Get("MAXQT")); List <TBL_GZMXB> listSource = CurrentDal.LoadEntities(t => true).ToList(); List <TBL_GZMXB> listTarget = new List <TBL_GZMXB>(); foreach (TBL_GZMXB model in listSource) { if (model.BM == "拆迁中心" && model.HJ >= MAXCQ) { continue; } if (model.BM != "拆迁中心" && model.HJ >= MAXQT) { continue; } if (model.JRBDWSJ != null) { DateTime timeTarget = Convert.ToDateTime(model.JRBDWSJ); DateTime timeNow = DateTime.Now; int month = (timeNow.Year - timeTarget.Year) * 12 + (timeNow.Month - timeTarget.Month); if (month >= 12 && month <= 12 * 2 - 1) { if (model.FLAG != "1") { model.BYXZJBGZ = 500; model.BYXZGWGZ = null; model.YEARLESS = "1"; listTarget.Add(model); } } if (month >= 12 * 2 && month <= 12 * 3 - 1) { if (model.FLAG != "2") { model.BYXZJBGZ = 100; model.BYXZGWGZ = null; model.YEARLESS = "2"; listTarget.Add(model); } } int maxYear = 100; List <int> listNum = new List <int>(); for (int i = 1; i <= maxYear; i++) { if (i % 2 == 0) { listNum.Add(i + 2); } } foreach (int item in listNum) { if (month >= 12 * item && month <= 12 * (item + 2) - 1) { if (model.FLAG != item.ToString()) { model.BYXZJBGZ = 100; model.BYXZGWGZ = null; model.YEARLESS = item.ToString(); listTarget.Add(model); } } } } } int recordCount = CurrentDBSession.TBL_GZMXB_TJDal.GetRecordCount(); if (recordCount == 0) { foreach (TBL_GZMXB item in listTarget) { TBL_GZMXB_TJ tjModel = new TBL_GZMXB_TJ(); EntityHelper.EntityToEntity(item, tjModel, "TJRQ", "MID"); tjModel.ID = CurrentDBSession.TBL_GZMXB_TJDal.GetMaxId("ID", "TBL_GZMXB_TJ").ToString(); tjModel.TJRQ = DateTime.Now; tjModel.HJ = Convert.ToDecimal(tjModel.HJ) + Convert.ToDecimal(tjModel.BYXZJBGZ) + Convert.ToDecimal(tjModel.BYXZGWGZ); tjModel.MID = item.ID; CurrentDBSession.TBL_GZMXB_TJDal.AddEntity(tjModel); CurrentDBSession.SaveChanges(); } } return(listTarget); }
/// <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())); }