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