public ProcessMsg GenPosition(string positionFormat)
{
using (TransactionScope trans = new TransactionScope())
{
using (IUnitOfWork unit = MSSqlHelper.DataContext())
{
ProcessMsg msg = new ProcessMsg();
try
{
ITraysRep tr = new TraysRep(unit);
string position = string.Empty;
int count = tr.GetTrayCountByDay();
string[] positionFormats = positionFormat.Split(',');
position = string.Format("{0} {1}", string.Format(positionFormats[0], DateTime.Now.Day), string.Format(positionFormats[1], count + 1));
msg.result = true;
msg.AddMessage(ReturnCode.OK, position);
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Error, "错误：" + e.Message + "\n请联系程序管理员！");
}
finally {
trans.Dispose();
}
return(msg);
}
}
}
public ProcessMsg CancleStored(List <string> trayIds)
{
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.GetByIds(trayIds);
bool all_synced = true;
foreach (Trays ts in tis)
{
bool synced = false;
try
{
synced = new ApiService().SyncUnStoreContainer(ts.trayId, config.Get("WAREHOUSE"));
}
catch
{
all_synced = false;
}
if (synced == false)
{
all_synced = false;
}
ts.sync = synced;
ts.status = (int)TrayStatus.Cancled;
}
unit.Submit();
trans.Complete();
if (all_synced)
{
msg.AddMessage(ReturnCode.OK, "入库取消成功！");
}
else
{
msg.AddMessage(ReturnCode.OK, "入库取消成功！");
msg.AddMessage(ReturnCode.Warning, "入库取消成功，但WMS同步失败，请稍候重新同步！");
}
msg.result = true;
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Error, "错误：" + e.Message + "\n请联系程序管理员！");
}
finally
{
trans.Dispose();
}
return(msg);
}
}
}
public ProcessMsg CancleStored(List<string> trayIds)
{
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.GetByIds(trayIds);
bool all_synced = true;
foreach (Trays ts in tis)
{
bool synced = false;
try
{
synced = new ApiService().SyncUnStoreContainer(ts.trayId, config.Get("WAREHOUSE"));
}
catch
{
all_synced = false;
}
if (synced == false) { all_synced = false; }
ts.sync = synced;
ts.status = (int)TrayStatus.Cancled;
}
unit.Submit();
trans.Complete();
if (all_synced)
{
msg.AddMessage(ReturnCode.OK, "入库取消成功！");
}
else
{
msg.AddMessage(ReturnCode.OK, "入库取消成功！");
msg.AddMessage(ReturnCode.Warning, "入库取消成功，但WMS同步失败，请稍候重新同步！");
}
msg.result = true;
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Error, "错误：" + e.Message + "\n请联系程序管理员！");
}
finally
{
trans.Dispose();
}
return msg;
}
}
}
public ProcessMsg ExportTraySumPartCSV(List <string> trayIds, string filename, List <string> fieldNames)
{
ProcessMsg msg = new ProcessMsg()
{
result = false
};
try
{
List <TrayPackView> tpv = TrayPackViewHelper.GetTPVByTrayIdsGropSumPartNr(trayIds);
// List<TrayPackView> ts = tpv.ToList();
List <string> updateTrayIds = new List <string>();
CSVDataSet ds = new CSVDataSet();
foreach (TrayPackView v in tpv)
{
CSVDataRecord r = new CSVDataRecord();
List <string> values = ClassUtil.GetModelValues(fieldNames, v);
if (values != null)
{
foreach (string value in values)
{
r.Add(value);
}
}
//r.Add(v.partNr);
//r.Add(v.capa.ToString());
if (TrayPackStatusHelper.CanAddPrefix(v.tstatus))
{
r.Add(v.TsStatusCN);
}
ds.Add(r);
if (TrayPackStatusHelper.CanUpdateToExported(v.tstatus))
{
updateTrayIds.Add(v.trayId);
}
}
CSVUtil.GenCSVFile(ds, filename);
if (updateTrayIds.Count > 0)
{
TraysHelper.UpdateTraysStatus(updateTrayIds, TrayStatus.Exported);
}
msg.result = true;
msg.AddMessage(ReturnCode.OK, "成功导出CSV文件");
}
catch (Exception e)
{
msg.AddMessage(ReturnCode.Error, e.Message);
}
return(msg);
}
public ProcessMsg Print(Hashtable printConfig, PrintDataMessage pmsg)
{
ProcessMsg msg = new ProcessMsg();
try
{
IReportGen gen = new TecITGener();
foreach (PrintTask task in pmsg.PrintTask)
{
task.Config.Printer = printConfig["PrinterName"].ToString();
task.Config.NumberOfCopies = int.Parse(printConfig["Copy"].ToString());
task.Config.Template = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, printConfig["Template"].ToString());
gen.Print(task.DataSet, task.Config);
}
msg.result = true;
msg.AddMessage(ReturnCode.OK, "打印成功！");
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Fail, "打印错误：" + e.Message);
}
return msg;
}
public ProcessMsg ExportTraySumPartCSV(List<string> trayIds, string filename, List<string> fieldNames)
{
ProcessMsg msg = new ProcessMsg() { result = false };
try
{
List<TrayPackView> tpv = TrayPackViewHelper.GetTPVByTrayIdsGropSumPartNr(trayIds);
// List<TrayPackView> ts = tpv.ToList();
List<string> updateTrayIds = new List<string>();
CSVDataSet ds = new CSVDataSet();
foreach (TrayPackView v in tpv)
{
CSVDataRecord r = new CSVDataRecord();
List<string> values = ClassUtil.GetModelValues(fieldNames, v);
if (values != null)
foreach (string value in values)
r.Add(value);
//r.Add(v.partNr);
//r.Add(v.capa.ToString());
if (TrayPackStatusHelper.CanAddPrefix(v.tstatus))
r.Add(v.TsStatusCN);
ds.Add(r);
if (TrayPackStatusHelper.CanUpdateToExported(v.tstatus))
updateTrayIds.Add(v.trayId);
}
CSVUtil.GenCSVFile(ds, filename);
if (updateTrayIds.Count > 0)
TraysHelper.UpdateTraysStatus(updateTrayIds, TrayStatus.Exported);
msg.result = true;
msg.AddMessage(ReturnCode.OK, "成功导出CSV文件");
}
catch (Exception e)
{
msg.AddMessage(ReturnCode.Error, e.Message);
}
return msg;
}
public ProcessMsg Print(Hashtable printConfig, PrintDataMessage pmsg)
{
ProcessMsg msg = new ProcessMsg();
try
{
IReportGen gen = new TecITGener();
foreach (PrintTask task in pmsg.PrintTask)
{
task.Config.Printer = printConfig["PrinterName"].ToString();
task.Config.NumberOfCopies = int.Parse(printConfig["Copy"].ToString());
task.Config.Template = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, printConfig["Template"].ToString());
gen.Print(task.DataSet, task.Config);
}
msg.result = true;
msg.AddMessage(ReturnCode.OK, "打印成功！");
}
catch (Exception e)
{
msg.result = false;
msg.AddMessage(ReturnCode.Fail, "打印错误：" + e.Message);
}
return(msg);
}
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;
}
}
}
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);
}
}
}
