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