public static void updateCompleteStatus(int tasknum)
{
string sql = "update t_produce_poke set status=20 where tasknum=" + tasknum;
DataPublic.ExeDb(sql);
// sql = "select count(1) from t_produce_poke where status<>20 and tasknum= " + tasknum;// sortnum.ToString().Substring(1);
// int exist= (int)DataPublic.ExecuteScalar(sql);
//if (exist == 0)
//{
sql = "update t_produce_task set state=30 ,finishtime=sysdate where tasknum=" + tasknum;// sortnum.ToString().Substring(1);
DataPublic.ExeDb(sql);
//}
}
public void updateStatus(String taskNum, string status)
{
string upSql = "update t_produce_poke set status='" + status + "' where tasknum='" + taskNum + "' ";
DataPublic.ExeDb(upSql);
}
public static void updateStatus(int tasknum)
{
string sql = "update t_produce_poke set status=15 where tasknum=" + tasknum;
DataPublic.ExeDb(sql);
}
