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); }