public static bool InsertRTrSn(string woid, DataTable dt, ref string result) { try { Phicomm_WMS.tR_Tr_Sn.tR_Tr_Sn tt = new Phicomm_WMS.tR_Tr_Sn.tR_Tr_Sn(); List <Phicomm_WMS.tR_Tr_Sn.TrSnFields> listField = new List <Phicomm_WMS.tR_Tr_Sn.TrSnFields>(); foreach (DataRow dr in dt.Rows) { Phicomm_WMS.tR_Tr_Sn.TrSnFields item = new Phicomm_WMS.tR_Tr_Sn.TrSnFields(); item.PO_ID = "NA"; item.TR_SN = dr["TR_SN"].ToString(); item.KP_NO = dr["KP_NO"].ToString(); item.KP_DESC = dr["KP_DESC"].ToString(); item.VENDER_ID = dr["VENDER_ID"].ToString(); item.VENDER_NAME = dr["VENDER_NAME"].ToString(); item.DATE_CODE = dr["DATE_CODE"].ToString(); item.LOT_CODE = string.IsNullOrEmpty(dt.Rows[0]["lot_code"].ToString().Trim()) ? "NA" : dr["lot_code"].ToString(); item.QTY = int.Parse(dr["QTY"].ToString()); item.STOCK_ID = dr["STOCK_ID"].ToString(); item.LOC_ID = dr["LOC_ID"].ToString(); item.TANSFER_NO = "NA"; item.URGENT_PN = "NA"; item.STOCK_NO = woid; item.STOCK_DATE = Convert.ToDateTime(dr["INVENTORY_DATE"].ToString()); item.WOID = woid; item.STATUS = dr["STATUS"].ToString(); item.REMARK1 = "NA"; item.REMARK2 = "NA"; item.UPDATE_DATE = DateTime.Now; item.FIFO_DC = dr["FIFO_DATECODE"].ToString(); listField.Add(item); } Phicomm_WMS.tR_Tr_Sn.TrSnFields[] itemField = listField.ToArray(); result = tt.Insert_R_TrSn(itemField); if (result.ToUpper().Trim().Equals("OK")) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
//冯东接口 public static bool DelTrSn(string trsn) { try { Phicomm_WMS.tR_Tr_Sn.tR_Tr_Sn tt = new Phicomm_WMS.tR_Tr_Sn.tR_Tr_Sn(); string res = tt.Del_TR_SN(trsn); if (res.ToUpper().Trim().ToUpper().Equals("OK")) { return(true); } throw new Exception(res); } catch (Exception ex) { throw ex; } }