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("执行失败！");
}
