예제 #1
0
        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);
        }
예제 #2
0
        /// <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()));
        }