public static void ResetAllTask()
{
ArrayList arrList = new ArrayList();
//String upOrderTable = "update t_produce_order set state='完成' where billcode in (select billcode from t_produce_task where tasknum='" + taskNum + "')";
String upTaskTable = "update t_produce_task set state='20'";
log.Write(upTaskTable);
String upPokeTable = "update t_produce_poke set status='10' ";
//arrList.Add(upOrderTable);
arrList.Add(upTaskTable);
arrList.Add(upPokeTable);
try
{
DataPublic.ExecuteSqlTrans(arrList);
}
catch (Exception e)
{
Console.WriteLine("拨烟事物提交信息报错：" + e.StackTrace);
//e.Message();
}
}
public static bool updateTaskState(String taskNumfrom, String taskTo, String pokeStatus, String taskStatus)
{
bool retVal = false;
ArrayList arrList = new ArrayList();
//String upOrderTable = "update t_produce_order set state='完成' where billcode in (select billcode from t_produce_task where tasknum='" + taskNum + "')";
String upTaskTable = "update t_produce_task set state='" + taskStatus + "' where tasknum>=" + taskNumfrom + " and taskNum<=" + taskTo;
String upPokeTable = "update t_produce_poke set status='" + pokeStatus + "' where tasknum>=" + taskNumfrom + " and taskNum<=" + taskTo;
//Console.WriteLine("拨烟事物提交更新报告：" + taskNum);
//arrList.Add(upOrderTable);
arrList.Add(upTaskTable);
arrList.Add(upPokeTable);
try
{
DataPublic.ExecuteSqlTrans(arrList);
}
catch (Exception e)
{
Console.WriteLine("拨烟事物提交信息报错：" + e.StackTrace);
//e.Message();
}
return(retVal);
}