public static List<CompleteMO> GetCompleteProductMO(EnumProductMOState status, string isRework) { List<CompleteMO> moList = new List<CompleteMO>(); string strSQL = @"SELECT MO, IsParentMO, count(MO) AS Qty FROM ProductMO WHERE Status=@Status AND IsRework=@Rework GROUP BY IsParentMO, MO ORDER BY IsParentMO, MO "; DataTable dt = SQLHelper.ExecuteDataFill(SQLHelper.ConnectionString_CFG(), System.Data.CommandType.Text, strSQL, SQLHelper.CreateSqlParameter("@Status", 20, status.ToString().Trim()), SQLHelper.CreateSqlParameter("@Rework", 1, isRework)); foreach( DataRow dr in dt.Rows) { moList.Add(new CompleteMO { MOId = dr["MO"].ToString().Trim(), IsParentMO = dr["IsParentMO"].ToString().Trim(), Qty = (int)dr["Qty"] }); } return moList; }
public static void UpdateProductMOReworkStatusAndInsertLog(string function, string action, List<string> productIdList, string txnId, string station, DateTime udt, string editor, EnumProductMOState CheckReworkState, string moId) { string strSQL = @"UPDATE ProductMO SET IsRework='Y', LastTxnId =@LastTxnId, Udt =@now WHERE ProductID in ({0}) AND MO=@moId AND Status!=@ReworkState INSERT ProductMOLog(ProductID, MO, [Function], [Action], IsParentMO, Station, PreStatus, Status, IsRework, IsHold, TxnId, Comment, Editor, Cdt) SELECT ProductID, MO, @Function, @Action, IsParentMO, @Station, Status, Status, 'Y', IsHold, @LastTxnId,'',@editor , @now FROM ProductMO WHERE ProductID in ({0}) AND MO=@moId AND Status!=@ReworkState "; string inSQLStr = "'" + string.Join("','", productIdList.ToArray()) + "'"; strSQL = string.Format(strSQL, inSQLStr); SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString_CFG(), System.Data.CommandType.Text, strSQL, SQLHelper.CreateSqlParameter("@Function", 32, function), SQLHelper.CreateSqlParameter("@Action", 32, action), SQLHelper.CreateSqlParameter("@LastTxnId", 32, txnId), SQLHelper.CreateSqlParameter("@Station", 32, station), SQLHelper.CreateSqlParameter("@editor", 32, editor), SQLHelper.CreateSqlParameter("@now", udt), SQLHelper.CreateSqlParameter("@moId", 32, moId), SQLHelper.CreateSqlParameter("@ReworkState", 32, CheckReworkState.ToString().Trim())); }