/// <summary> /// 036 wms Create By Xue 待商议 /// </summary> /// <param name="tranDetailsInfo"></param> private string CreateWmsTranData(TranDetailsInfo tranDetailsInfo) { string sql = string.Empty; if (tranDetailsInfo == null) { return(string.Empty); } int orderType = 0; if (tranDetailsInfo.TranNo != tranDetailsInfo.RunsheetNo) { orderType = 40; } else if (tranDetailsInfo.TranNo == tranDetailsInfo.RunsheetNo) { if (!string.IsNullOrEmpty(tranDetailsInfo.BoxParts)) { PartsBoxInfo partsBoxInfo = new PartsBoxBLL().GetInfoByPartBox(tranDetailsInfo.BoxParts); orderType = partsBoxInfo.PullMode; } else { if (string.IsNullOrEmpty(tranDetailsInfo.RunsheetNo) && string.IsNullOrEmpty(tranDetailsInfo.BoxParts)) { orderType = 50; } else { orderType = 30; } } } return(sql = string.Format(@"insert into [LES].[TI_IFM_WMS_TRAN_OUT]([FID],[SOURCE_ORDER_CODE],[SOURCE_ORDER_TYPE],[PART_NO],[DELIVERY_QTY],[PROCESS_FLAG],[PROCESS_TIME],[LOG_FID],[VALID_FLAG],[CREATE_DATE],[CREATE_USER],[SUPPLIER_NUM],[SUPPLIER_NAME]) values(newid(),'{0}',{1},'{2}',{3},10,getdate(),null,1,getdate(),'{4}','{5}','{6}');", tranDetailsInfo.TranNo, orderType, tranDetailsInfo.PartNo, tranDetailsInfo.ActualQty, loginUser, tranDetailsInfo.SupplierNum, tranDetailsInfo.SupplierName)); }
public string GetpartsBox(HttpContext context) { string inhousePartClass = context.Request["INHOUSE"]; string zoneNo = context.Request["ZONE"]; string wmNo = context.Request["WM"]; PartsBoxInfo info = new PartsBoxBLL().GetList(" [BOX_PARTS] = N'" + inhousePartClass + "' and [S_WM_NO] = N'" + wmNo + "' and [S_ZONE_NO] = N'" + zoneNo + "'", string.Empty).FirstOrDefault(); return(JsonHelper.ToJson(info)); }