public static List <R_BACKFLUSH_CHECK> DataAdapert(DataSet data, bool MulValue) { R_BACKFLUSH_CHECK obj = new R_BACKFLUSH_CHECK(); List <R_BACKFLUSH_CHECK> retL = new List <R_BACKFLUSH_CHECK>(); for (int i = 0; i < data.Tables[0].Rows.Count; i++) { obj = new R_BACKFLUSH_CHECK(); if (data.Tables[0].Rows[i]["WORKORDERNO"] != System.DBNull.Value) { obj.WORKORDERNO = (System.String)data.Tables[0].Rows[i]["WORKORDERNO"]; } if (data.Tables[0].Rows[i]["SKUNO"] != System.DBNull.Value) { obj.SKUNO = (System.String)data.Tables[0].Rows[i]["SKUNO"]; } if (data.Tables[0].Rows[i]["SAP_STATION"] != System.DBNull.Value) { obj.SAP_STATION = (System.String)data.Tables[0].Rows[i]["SAP_STATION"]; } if (data.Tables[0].Rows[i]["WORKORDER_QTY"] != System.DBNull.Value) { obj.WORKORDER_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["WORKORDER_QTY"]); } if (data.Tables[0].Rows[i]["BACKFLUSH_QTY"] != System.DBNull.Value) { obj.BACKFLUSH_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["BACKFLUSH_QTY"]); } if (data.Tables[0].Rows[i]["SFC_QTY"] != System.DBNull.Value) { obj.SFC_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["SFC_QTY"]); } if (data.Tables[0].Rows[i]["DIFF_QTY"] != System.DBNull.Value) { obj.DIFF_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["DIFF_QTY"]); } if (data.Tables[0].Rows[i]["SFC_STATION"] != System.DBNull.Value) { obj.SFC_STATION = (System.String)data.Tables[0].Rows[i]["SFC_STATION"]; } if (data.Tables[0].Rows[i]["HAND_QTY"] != System.DBNull.Value) { obj.HAND_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["HAND_QTY"]); } if (data.Tables[0].Rows[i]["LAST_SFC_QTY"] != System.DBNull.Value) { obj.LAST_SFC_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["LAST_SFC_QTY"]); } if (data.Tables[0].Rows[i]["DIFF_QTY1"] != System.DBNull.Value) { obj.DIFF_QTY1 = Convert.ToDecimal(data.Tables[0].Rows[i]["DIFF_QTY1"]); } if (data.Tables[0].Rows[i]["DIFF_QTY2"] != System.DBNull.Value) { obj.DIFF_QTY2 = Convert.ToDecimal(data.Tables[0].Rows[i]["DIFF_QTY2"]); } if (data.Tables[0].Rows[i]["HISTORY_HAND_QTY"] != System.DBNull.Value) { obj.HISTORY_HAND_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["HISTORY_HAND_QTY"]); } if (data.Tables[0].Rows[i]["MRB_QTY"] != System.DBNull.Value) { obj.MRB_QTY = Convert.ToDecimal(data.Tables[0].Rows[i]["MRB_QTY"]); } if (data.Tables[0].Rows[i]["REC_TYPE"] != System.DBNull.Value) { obj.REC_TYPE = (System.String)data.Tables[0].Rows[i]["REC_TYPE"]; } obj.AcceptChange(); retL.Add(obj); } return(retL); }
public static R_BACKFLUSH_CHECK DataAdapert(DataSet data) { R_BACKFLUSH_CHECK obj = new R_BACKFLUSH_CHECK(); if (data.Tables[0].Rows[0]["WORKORDERNO"] != System.DBNull.Value) { obj.WORKORDERNO = (System.String)data.Tables[0].Rows[0]["WORKORDERNO"]; } if (data.Tables[0].Rows[0]["SKUNO"] != System.DBNull.Value) { obj.SKUNO = (System.String)data.Tables[0].Rows[0]["SKUNO"]; } if (data.Tables[0].Rows[0]["SAP_STATION"] != System.DBNull.Value) { obj.SAP_STATION = (System.String)data.Tables[0].Rows[0]["SAP_STATION"]; } if (data.Tables[0].Rows[0]["WORKORDER_QTY"] != System.DBNull.Value) { obj.WORKORDER_QTY = (System.Decimal)data.Tables[0].Rows[0]["WORKORDER_QTY"]; } if (data.Tables[0].Rows[0]["BACKFLUSH_QTY"] != System.DBNull.Value) { obj.BACKFLUSH_QTY = (System.Decimal)data.Tables[0].Rows[0]["BACKFLUSH_QTY"]; } if (data.Tables[0].Rows[0]["SFC_QTY"] != System.DBNull.Value) { obj.SFC_QTY = (System.Decimal)data.Tables[0].Rows[0]["SFC_QTY"]; } if (data.Tables[0].Rows[0]["DIFF_QTY"] != System.DBNull.Value) { obj.DIFF_QTY = (System.Decimal)data.Tables[0].Rows[0]["DIFF_QTY"]; } if (data.Tables[0].Rows[0]["SFC_STATION"] != System.DBNull.Value) { obj.SFC_STATION = (System.String)data.Tables[0].Rows[0]["SFC_STATION"]; } if (data.Tables[0].Rows[0]["HAND_QTY"] != System.DBNull.Value) { obj.HAND_QTY = (System.Decimal)data.Tables[0].Rows[0]["HAND_QTY"]; } if (data.Tables[0].Rows[0]["LAST_SFC_QTY"] != System.DBNull.Value) { obj.LAST_SFC_QTY = (System.Decimal)data.Tables[0].Rows[0]["LAST_SFC_QTY"]; } if (data.Tables[0].Rows[0]["DIFF_QTY1"] != System.DBNull.Value) { obj.DIFF_QTY1 = (System.Decimal)data.Tables[0].Rows[0]["DIFF_QTY1"]; } if (data.Tables[0].Rows[0]["DIFF_QTY2"] != System.DBNull.Value) { obj.DIFF_QTY2 = (System.Decimal)data.Tables[0].Rows[0]["DIFF_QTY2"]; } if (data.Tables[0].Rows[0]["HISTORY_HAND_QTY"] != System.DBNull.Value) { obj.HISTORY_HAND_QTY = (System.Decimal)data.Tables[0].Rows[0]["HISTORY_HAND_QTY"]; } if (data.Tables[0].Rows[0]["MRB_QTY"] != System.DBNull.Value) { obj.MRB_QTY = (System.Decimal)data.Tables[0].Rows[0]["MRB_QTY"]; } if (data.Tables[0].Rows[0]["REC_TYPE"] != System.DBNull.Value) { obj.REC_TYPE = (System.String)data.Tables[0].Rows[0]["REC_TYPE"]; } obj.AcceptChange(); return(obj); }