public override string add(HttpContext context) { try { LogMonthCreate log = new LogMonthCreate(); log.Id = System.Guid.NewGuid().ToString(); log.YearMonth = MyData.Utils.getLastYearMonth(); log.CreateTime = DateTime.Now; log.State = (int)MyData.LogMonthCreateState.执行中; log.UpdateTime = DateTime.Now; log.CreatePerson = "dingshi"; log.UpdatePerson = "dingshi"; new BLL.LogMonthCreateBLL().zhixing(log); return("0"); } catch (Exception ex) { } return("执行失败!"); }
public String zhixing(LogMonthCreate logMonthCreate) { //判断本月是否存在已生成记录 String sql = " and YearMonth=" + MyData.Utils.getLastYearMonth(); List <LogMonthCreate> logMonthCreateList = getLogMonthCreateList(sql); if (logMonthCreateList != null && logMonthCreateList.Count > 0) { var logMonthCreate1 = logMonthCreateList.OrderByDescending(o => o.CreateTime).First(); if (logMonthCreate1.State != (int)MyData.LogMonthCreateState.执行中) { if (logMonthCreate.CreatePerson != "dingshi") { DAL.LogMonthCreateDal logdal = new DAL.LogMonthCreateDal(); //step1 添加一条记录到表 logdal.Insert(logMonthCreate); //执行操作 new BLL.AgentsBLL().jisuan(); //修改状态 logdal.UpdateState(logMonthCreate.Id); return("执行成功!"); } } } else { DAL.LogMonthCreateDal logdal = new DAL.LogMonthCreateDal(); //step1 添加一条记录到表 logdal.Insert(logMonthCreate); //执行操作 new BLL.AgentsBLL().jisuan(); //修改状态 logdal.UpdateState(logMonthCreate.Id); return("执行成功!"); } return("执行失败!"); }