public string REback(string lotNumber) { MethodReturnResult result = new MethodReturnResult(); using (ERPClient client = new ERPClient()) { REbackdataParameter param = new REbackdataParameter(); param.PackageNo = lotNumber; param.ErrorMsg = ""; param.ReType = 2; param.IsDelete = 1; result = client.GetREbackdata(param); //if (result.Code == 1000) //{ // result.Message += string.Format(WIPResources.StringResource.REbackdata_Fail); //} } return(result.Message); }
public string GetQueryCondition(LotPackageSEModulesViewModel model) { StringBuilder where = new StringBuilder(); where.AppendFormat(" Quantity > 0"); if (model != null) { if (!string.IsNullOrEmpty(model.PackageNo) && !string.IsNullOrEmpty(model.PackageNo1)) { where.AppendFormat(" {0} Key >= '{1}' AND Key<='{2}'" , where.Length > 0 ? "AND" : string.Empty , model.PackageNo , model.PackageNo1); } else if (!string.IsNullOrEmpty(model.PackageNo)) { char [] splitChars = new char[] { ',', '$' }; string[] packageNos = model.PackageNo.TrimEnd(splitChars).Split(splitChars); #region 界面托号包含归档,则归档托号提取 if (packageNos.Length >= 1) { //若托号不存在当前库,提取归档托号数据 foreach (string item in packageNos) { Package package = null; using (PackageQueryServiceClient clientOfPackage = new PackageQueryServiceClient()) { if (clientOfPackage.Get(item.Trim().ToUpper()) != null && clientOfPackage.Get(item.Trim().ToUpper()).Data != null) { package = clientOfPackage.Get(item.Trim().ToUpper()).Data; } } if (package == null) { MethodReturnResult resultOfRePackage = new MethodReturnResult(); //若存在归档,则提取 using (PackageInChestServiceClient packageInChestServiceClient = new PackageInChestServiceClient()) { //返回已归档的(WIP_PACKAGE表)数据 REbackdataParameter pre = new REbackdataParameter(); pre.PackageNo = item; pre.ErrorMsg = ""; pre.ReType = 1; pre.IsDelete = 0; resultOfRePackage = packageInChestServiceClient.GetREbackdata(pre); if (resultOfRePackage.Code > 0) { } else { //提取其他归档表数据到当前库,并删除从归档库 pre = new REbackdataParameter(); pre.PackageNo = item; pre.ReType = 2; pre.IsDelete = 1; resultOfRePackage = packageInChestServiceClient.GetREbackdata(pre); } } } } } #endregion if (packageNos.Length <= 1) { where.AppendFormat(" {0} Key = '{1}'" , where.Length > 0 ? "AND" : string.Empty , packageNos[0]); } else { where.AppendFormat(" {0} Key IN (" , where.Length > 0 ? "AND" : string.Empty); foreach (string package in packageNos) { where.AppendFormat("'{0}',", package); } where.Remove(where.Length - 1, 1); where.Append(")"); } } if (!string.IsNullOrEmpty(model.OrderNumber)) { where.AppendFormat(" {0} OrderNumber LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.OrderNumber); } if (model.StartCreateTime != null) { where.AppendFormat(" {0} CreateTime >= '{1:yyyy-MM-dd HH:mm:ss}'" , where.Length > 0 ? "AND" : string.Empty , model.StartCreateTime); } if (model.EndCreateTime != null) { where.AppendFormat(" {0} CreateTime <= '{1:yyyy-MM-dd HH:mm:ss}'" , where.Length > 0 ? "AND" : string.Empty , model.EndCreateTime); } } return(where.ToString()); }