public void CommitEvent(object key)
{
Guid id = new Guid(key.ToString());
PTPrjInfoZTBService service = new PTPrjInfoZTBService();
PTPrjInfoService service2 = new PTPrjInfoService();
PTPrjInfoZTB byId = service.GetById(id);
if (byId.PrjState.ToString() == ProjectParameter.WinBid)
{
service2.ChangePrjInfo(byId, 5, 1);
}
}
public static void ClearPTPrjInfo(object o)
{
try
{
Log4netHelper.Error(new Exception("ClearPTPrjInfo 开始执行"), "ClearPTPrjInfo", "bery");
BasicConfigService service = new BasicConfigService();
BasicConfig byName = service.GetByName("IsClearPTPrjInfo");
if (byName == null)
{
byName = new BasicConfig {
Id = Guid.NewGuid().ToString(),
ParaName = "IsClearPTPrjInfo",
ParaValue = "0",
Note = "是否已经把PT_PrjInfo_ZTB表的数据导入PT_PrjInfo表中"
};
service.Add(byName);
}
if (byName.ParaValue != "1")
{
string cmdText = "SELECT PrjGuid FROM PT_PrjInfo_ZTB WHERE PrjGuid Not IN (SELECT PrjGuid FROM PT_PrjInfo)";
foreach (DataRow row in SqlHelper.ExecuteQuery(CommandType.Text, cmdText, new SqlParameter[0]).Rows)
{
Guid id = new Guid(row[0].ToString());
PTPrjInfoZTBService service2 = new PTPrjInfoZTBService();
PTPrjInfoService service3 = new PTPrjInfoService();
PTPrjInfoZTB byId = service2.GetById(id);
service3.ChangePrjInfo(byId, 2, 1);
}
byName.ParaValue = "1";
service.Update(byName);
}
}
catch (Exception exception)
{
Log4netHelper.Error(exception, "ClearPTPrjInfo", "bery");
}
}