public List<SinglePackage> TraySPDetail(string trayId)
{
using (IUnitOfWork unit = MSSqlHelper.DataContext())
{
try
{
ITraysRep tr = new TraysRep(unit);
Trays t = tr.GetSingleById(trayId);
if (t == null)
return null;
ITrayItemRep tir = new TrayItemRep(unit);
return tir.GetSPByTrayId(trayId);
}
catch
{
return null;
}
}
}
public ProcessMsg CompleteStore(List<string> packageIds, string whouse, string posi)
{
using (TransactionScope trans = new TransactionScope())
{
using (IUnitOfWork unit = MSSqlHelper.DataContext())
{
ProcessMsg msg = new ProcessMsg();
try
{
string trayId = "T" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
ITraysRep tr = new TraysRep(unit);
ITrayItemRep tir = new TrayItemRep(unit);
ISinglePackageRep spr = new SinglePackageRep(unit);
Trays ts = new Trays()
{
trayId = trayId,
createTime = DateTime.Now,
warehouse = whouse,
position = posi,
status = (int)TrayStatus.Stored,
rowguid = Guid.NewGuid()
};
List<TrayItem> tis = new List<TrayItem>();
foreach (string pid in packageIds)
{
tis.Add(new TrayItem()
{
itemId = Guid.NewGuid(),
trayId = ts.trayId,
packageId = pid,
rowguid = Guid.NewGuid()
});
}
bool synced = false;
// sync container data
try
{
List<SinglePackage> singlePackages = spr.GetListByIds(packageIds);
synced = new ApiService().SyncStoreContainer(GenContainers(ts, singlePackages, GetWhouse()));
}
catch (ApiException ae)
{
msg.AddMessage(ReturnCode.Warning, ae.Message);
synced = false;
}
catch {
synced = false;
}
ts.sync = synced;
tr.AddSingle(ts);
tir.AddMuti(tis);
unit.Submit();
trans.Complete();
msg.result = true;
if (synced)
{
msg.AddMessage(ReturnCode.OK, ts.trayId);
}
else
{
msg.AddMessage(ReturnCode.OK, ts.trayId);
msg.AddMessage(ReturnCode.Warning, "托盘生成成功，但WMS同步失败，请检查网络，稍候重新同步！");
}
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Error, "错误：" + e.Message + "\n请联系程序管理员！");
}
finally
{
trans.Dispose();
}
return msg;
}
}
}
public ProcessMsg SyncStore()
{
using (TransactionScope trans = new TransactionScope())
{
using (IUnitOfWork unit = MSSqlHelper.DataContext())
{
ProcessMsg msg = new ProcessMsg() { result = true };
try
{
ITraysRep tr = new TraysRep(unit);
List<Trays> tis = tr.GetUnsync();
ITrayItemRep tir = new TrayItemRep(unit);
bool all_synced = true;
bool error_loged = false;
string error_log = DateTime.Now.ToString("yyyyMMddHHmmsss") + ".txt";
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ErrorLog", error_log);
using (FileStream fs = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite))
{
using (StreamWriter sw = new StreamWriter(fs))
{
foreach (Trays ts in tis)
{
bool synced = false;
try
{
if (ts.status == (int)TrayStatus.Cancled)
{
synced = new ApiService().SyncUnStoreContainer(ts.trayId, GetWhouse());
}
else
{
List<SinglePackage> singlePackages = tir.GetSPByTrayId(ts.trayId);
synced = new ApiService().SyncStoreContainer(GenContainers(ts, singlePackages, GetWhouse()));
}
}
catch (ApiException ae)
{
sw.WriteLine(ae.Message);
error_loged = true;
synced = false;
}
catch
{
synced = false;
}
ts.sync = synced;
if (synced == false) { all_synced = false; }
}
}
}
unit.Submit();
trans.Complete();
msg.result = all_synced;
if (all_synced)
{
msg.AddMessage(ReturnCode.OK, "WMS同步成功！");
}
else
{
if (error_loged)
{
msg.AddMessage(ReturnCode.Warning, "WMS同步失败，查看错误日志:" + error_log + "请稍候重新同步！\n或联系程序管理员！");
}
else
{
msg.AddMessage(ReturnCode.Warning, "WMS同步失败，请检查网络，稍候重新同步！\n或联系程序管理员！");
}
}
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Error, "错误：" + e.Message + "\n请联系程序管理员！");
}
finally
{
trans.Dispose();
}
return msg;
}
}
}