public static bool Insert(SewingMasterModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine);
var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota);
var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate);
var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate);
var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance);
var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota);
var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", model.CutAActualStartDate);
var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", model.CutAActualFinishDate);
var @CutABalance = new SqlParameter("@CutABalance", model.CutABalance);
var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance);
var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance);
var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance);
var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance);
var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMaster @ProductNo,@Sequence,@SewingLine,@SewingQuota,@SewingActualStartDate,@SewingActualFinishDate,@SewingBalance,@CutAQuota,@CutAActualStartDate,@CutAActualFinishDate,@CutABalance,@PrintingBalance,@H_FBalance,@EmbroideryBalance,@CutBBalance,@AutoCut", @ProductNo, @Sequence, @SewingLine, @SewingQuota, @SewingActualStartDate, @SewingActualFinishDate, @SewingBalance, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBBalance, @AutoCut) > 0)
{
return(true);
}
return(false);
}
private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
materialTypeList = MaterialTypeController.Select().Where(w => w.MaterialGroup.Contains("UPPER")).ToList();
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.SelectByProductNo();
DataTable dt = new DelayDataSet().Tables["DelayTable"];
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList();
// get assemblyline from productNo
//AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault();
// get sewingLing from productNo
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault();
//materialTypeIdList.Remove(6);
//materialTypeIdList.Remove(11);
//materialTypeIdList.Remove(12);
//materialTypeIdList.Remove(13);
//materialTypeIdList.Remove(14);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date < DateTime.Now.Date &&
rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1))
{
DataRow dr = dt.NewRow();
// binding data to reportviewer
dr["SewingLine"] = sewingMaster.SewingLine;
dr["ProductNo"] = productNo;
if (order != null)
{
dr["ArticleNo"] = order.ArticleNo;
dr["ShoeName"] = order.ShoeName;
dr["Quantity"] = order.Quantity;
dr["ETD"] = order.ETD;
}
dr["SupplierETD"] = rawMaterial.ETD;
dr["Remarks"] = rawMaterial.Remarks;
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
dr["Supplier"] = materialType.Name;
}
dt.Rows.Add(dr);
}
}
}
e.Result = dt;
}
public static bool InsertSequence(SewingMasterModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate);
var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMasterSequence @ProductNo,@Sequence,@SewingStartDate,@SewingFinishDate", @ProductNo, @Sequence, @SewingStartDate, @SewingFinishDate) > 0)
{
return(true);
}
return(false);
}
private void bwLoad_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
DataTable dt = new AssemblyScheduleDelayDataSet().Tables["AssemblyScheduleDelayTable"];
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
assemblyMasterList = assemblyMasterList.OrderBy(s => s.Sequence).ToList();
foreach (AssemblyMasterModel assemblyMaster in assemblyMasterList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
int qtyBalance = 0;
if (order != null && assemblyMaster.AssemblyFinishDate > order.ETD &&
(String.IsNullOrEmpty(assemblyMaster.AssemblyBalance) == true || int.TryParse(assemblyMaster.AssemblyBalance, out qtyBalance) == true))
{
DataRow dr = dt.NewRow();
dr["ProductNo"] = order.ProductNo;
dr["Country"] = order.Country;
dr["ShoeName"] = order.ShoeName;
dr["ArticleNo"] = order.ArticleNo;
dr["ETD"] = order.ETD;
dr["Quantity"] = order.Quantity;
dr["AssemblyLine"] = assemblyMaster.AssemblyLine;
dr["AssemblyBalance"] = assemblyMaster.AssemblyBalance;
SewingMasterModel sewingMaster = sewingMasterList.Where(s => s.ProductNo == order.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
dr["SewingFinishDate"] = sewingMaster.SewingFinishDate;
}
dr["AssemblyFinishDate"] = assemblyMaster.AssemblyFinishDate;
dt.Rows.Add(dr);
}
}
ReportDataSource rds = new ReportDataSource();
rds.Name = "AssemblyScheduleDelay";
rds.Value = dt;
//reportViewer.LocalReport.ReportPath = @"C:\Users\IT02\Documents\Visual Studio 2010\Projects\Saoviet Master Schedule Solution\MasterSchedule\Reports\AssemblyScheduleDelayReport.rdlc";
reportViewer.LocalReport.ReportPath = @"Reports\AssemblyScheduleDelayReport.rdlc";
reportViewer.LocalReport.DataSources.Add(rds);
reportViewer.RefreshReport();
this.Cursor = null;
}
// Not Use
public static bool InsertSewing(SewingMasterModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine);
var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate);
var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate);
var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota);
var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate);
var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate);
var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMasterSewing @ProductNo,@SewingLine,@SewingStartDate,@SewingFinishDate,@SewingQuota,@SewingActualStartDate,@SewingActualFinishDate,@SewingBalance", @ProductNo, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingActualStartDate, @SewingActualFinishDate, @SewingBalance) > 0)
{
return(true);
}
return(false);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sockliningMasterList = SockliningMasterController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
assemblyMasterList = AssemblyMasterController.Select();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
sockliningMasterList = sockliningMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
int[] materialIdAssemblyArray = { 8 };
int[] materialIdSockliningArray = { 9 };
foreach (SockliningMasterModel sockliningMaster in sockliningMasterList)
{
SockliningMasterExportViewModel sockliningMasterExportView = new SockliningMasterExportViewModel();
sockliningMasterExportView.Sequence = sockliningMaster.Sequence;
sockliningMasterExportView.ProductNo = sockliningMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (order != null)
{
sockliningMasterExportView.Country = order.Country;
sockliningMasterExportView.ShoeName = order.ShoeName;
sockliningMasterExportView.ArticleNo = order.ArticleNo;
sockliningMasterExportView.PatternNo = order.PatternNo;
sockliningMasterExportView.Quantity = order.Quantity;
sockliningMasterExportView.ETD = order.ETD;
}
MaterialArrivalViewModel materialArrivalSocklining = MaterialArrival(order.ProductNo, materialIdSockliningArray);
sockliningMasterExportView.IsSockliningMatsArrivalOk = false;
if (materialArrivalSocklining != null)
{
sockliningMasterExportView.SockliningMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalSocklining.Date);
sockliningMasterExportView.IsSockliningMatsArrivalOk = materialArrivalSocklining.IsMaterialArrivalOk;
}
sockliningMasterExportView.SockliningLine = sockliningMaster.SockliningLine;
sockliningMasterExportView.SockliningQuota = sockliningMaster.SockliningQuota;
sockliningMasterExportView.SockliningStartDate = sockliningMaster.SockliningStartDate;
sockliningMasterExportView.SockliningFinishDate = sockliningMaster.SockliningFinishDate;
sockliningMasterExportView.InsoleBalance = sockliningMaster.InsoleBalance;
sockliningMasterExportView.InsockBalance = sockliningMaster.InsockBalance;
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
sockliningMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
sockliningMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
sockliningMasterExportView.SewingStartDate = dtDefault;
sockliningMasterExportView.SewingBalance = "";
}
OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (outsoleMaster != null)
{
sockliningMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate;
sockliningMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
}
else
{
sockliningMasterExportView.OutsoleStartDate = dtDefault;
sockliningMasterExportView.OutsoleBalance = "";
}
AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (assemblyMaster != null)
{
sockliningMasterExportView.AssemblyStartDate = assemblyMaster.AssemblyStartDate;
}
else
{
sockliningMasterExportView.AssemblyStartDate = dtDefault;
}
sockliningMasterExportViewList.Add(sockliningMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
sockliningMasterList = SockliningMasterController.Select();
assemblyMasterList = AssemblyMasterController.Select();
productionMemoList = ProductionMemoController.Select();
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
rawMaterialViewModelNewList = RawMaterialController.Select_1();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
assemblyMasterList = assemblyMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
int[] materialIdAssemblyArray = { 8, 9 };
int[] materialIdCartonArray = { 11 };
foreach (AssemblyMasterModel assemblyMaster in assemblyMasterList)
{
AssemblyMasterExportViewModel assemblyMasterExportView = new AssemblyMasterExportViewModel();
assemblyMasterExportView.Sequence = assemblyMaster.Sequence;
assemblyMasterExportView.ProductNo = assemblyMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
string memoId = "";
if (order != null)
{
assemblyMasterExportView.Country = order.Country;
assemblyMasterExportView.ShoeName = order.ShoeName;
assemblyMasterExportView.ArticleNo = order.ArticleNo;
assemblyMasterExportView.LastCode = order.LastCode;
assemblyMasterExportView.Quantity = order.Quantity;
assemblyMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
assemblyMasterExportView.MemoId = memoId;
}
//MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray);
//assemblyMasterExportView.IsOutsoleMatsArrivalOk = false;
//if (materialArrivalOutsole != null)
//{
// assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date);
// assemblyMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk;
//}
//// follow OutsoleRawMaterial
//var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList();
//var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList();
//assemblyMasterExportView.IsOutsoleMatsArrivalOk = false;
//if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false)
//{
// assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max());
// assemblyMasterExportView.IsOutsoleMatsArrivalOk = true;
//}
//else
//{
// var etdDateList = osRawMaterial.Select(s => s.ETD).ToList();
// if (etdDateList.Count() > 0)
// {
// assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max());
// }
//}
assemblyMasterExportView.IsOutsoleMatsArrivalOk = false;
var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo);
if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) &&
!String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate))
{
assemblyMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate;
assemblyMasterExportView.IsOutsoleMatsArrivalOk = true;
}
else
{
assemblyMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD;
}
MaterialArrivalViewModel materialArrivalAssembly = MaterialArrival(order.ProductNo, materialIdAssemblyArray);
assemblyMasterExportView.IsAssemblyMatsArrivalOk = false;
if (materialArrivalAssembly != null)
{
assemblyMasterExportView.AssemblyMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalAssembly.Date);
assemblyMasterExportView.IsAssemblyMatsArrivalOk = materialArrivalAssembly.IsMaterialArrivalOk;
}
MaterialArrivalViewModel materialArrivalCarton = MaterialArrival(order.ProductNo, materialIdCartonArray);
if (materialArrivalCarton != null)
{
assemblyMasterExportView.CartonMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalCarton.Date);
}
assemblyMasterExportView.AssemblyLine = assemblyMaster.AssemblyLine;
assemblyMasterExportView.AssemblyStartDate = assemblyMaster.AssemblyStartDate;
assemblyMasterExportView.AssemblyFinishDate = assemblyMaster.AssemblyFinishDate;
assemblyMasterExportView.AssemblyQuota = assemblyMaster.AssemblyQuota;
assemblyMasterExportView.AssemblyBalance = assemblyMaster.AssemblyBalance;
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
assemblyMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
assemblyMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate;
assemblyMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
assemblyMasterExportView.SewingStartDate = dtDefault;
assemblyMasterExportView.SewingFinishDate = dtDefault;
assemblyMasterExportView.SewingBalance = "";
}
OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
if (outsoleMaster != null)
{
assemblyMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
}
else
{
assemblyMasterExportView.OutsoleBalance = "";
}
SockliningMasterModel sockliningMaster = sockliningMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
if (sockliningMaster != null)
{
assemblyMasterExportView.InsoleBalance = sockliningMaster.InsoleBalance;
assemblyMasterExportView.InsockBalance = sockliningMaster.InsockBalance;
}
else
{
assemblyMasterExportView.InsoleBalance = "";
assemblyMasterExportView.InsockBalance = "";
}
assemblyMasterExportViewList.Add(assemblyMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
outsoleReleaseMaterialList = OutsoleReleaseMaterialController.SelectByOutsoleMaster();
productionMemoList = ProductionMemoController.Select();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
outsoleMasterList = outsoleMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
foreach (OutsoleMasterModel outsoleMaster in outsoleMasterList)
{
OutsoleMasterExportViewModel outsoleMasterExportView = new OutsoleMasterExportViewModel();
outsoleMasterExportView.Sequence = outsoleMaster.Sequence;
outsoleMasterExportView.ProductNo = outsoleMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == outsoleMaster.ProductNo).FirstOrDefault();
string memoId = "";
if (order != null)
{
outsoleMasterExportView.Country = order.Country;
outsoleMasterExportView.ShoeName = order.ShoeName;
outsoleMasterExportView.ArticleNo = order.ArticleNo;
outsoleMasterExportView.OutsoleCode = order.OutsoleCode;
outsoleMasterExportView.Quantity = order.Quantity;
outsoleMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
outsoleMasterExportView.MemoId = memoId;
}
MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray);
outsoleMasterExportView.IsOutsoleMatsArrivalOk = false;
if (materialArrivalOutsole != null)
{
outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date);
outsoleMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk;
}
outsoleMasterExportView.OutsoleLine = outsoleMaster.OutsoleLine;
outsoleMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate;
outsoleMasterExportView.OutsoleFinishDate = outsoleMaster.OutsoleFinishDate;
outsoleMasterExportView.OutsoleQuota = outsoleMaster.OutsoleQuota;
outsoleMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
RawMaterialModel outsoleRawMaterial = rawMaterialList.Where(r => r.ProductNo == outsoleMaster.ProductNo && materialIdOutsoleArray.Contains(r.MaterialTypeId)).FirstOrDefault();
if (outsoleRawMaterial != null)
{
outsoleMasterExportView.OutsoleWHBalance = outsoleRawMaterial.Remarks;
}
else
{
outsoleMasterExportView.OutsoleWHBalance = "";
}
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == outsoleMaster.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
outsoleMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
outsoleMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate;
outsoleMasterExportView.SewingQuota = sewingMaster.SewingQuota;
outsoleMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
outsoleMasterExportView.SewingStartDate = dtDefault;
outsoleMasterExportView.SewingFinishDate = dtDefault;
outsoleMasterExportView.SewingQuota = 0;
outsoleMasterExportView.SewingBalance = "";
}
List <OutsoleReleaseMaterialModel> outsoleReleaseMaterialList_D1 = outsoleReleaseMaterialList.Where(o => o.ProductNo == outsoleMaster.ProductNo).ToList();
int qtyReleased = outsoleReleaseMaterialList_D1.Sum(o => o.Quantity);
outsoleMasterExportView.ReleasedQuantity = qtyReleased.ToString();
if (qtyReleased <= 0)
{
outsoleMasterExportView.ReleasedQuantity = "";
}
if (qtyReleased >= outsoleMasterExportView.Quantity && outsoleReleaseMaterialList_D1.Count > 0)
{
DateTime releasedDate = outsoleReleaseMaterialList_D1.FirstOrDefault().ModifiedTime;
outsoleMasterExportView.ReleasedQuantity = string.Format("{0:M/d}", releasedDate);
}
outsoleMasterExportViewList.Add(outsoleMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
outsoleReleaseMaterialList = OutsoleReleaseMaterialController.SelectByOutsoleMaster();
productionMemoList = ProductionMemoController.Select();
outsoleMaterialList = OutsoleMaterialController.Select();
rawMaterialViewModelNewList = RawMaterialController.Select_1();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
outsoleMasterList = outsoleMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
foreach (OutsoleMasterModel outsoleMaster in outsoleMasterList)
{
OutsoleMasterExportViewModel outsoleMasterExportView = new OutsoleMasterExportViewModel();
outsoleMasterExportView.Sequence = outsoleMaster.Sequence;
outsoleMasterExportView.ProductNo = outsoleMaster.ProductNo;
OrdersModel order = orderList.FirstOrDefault(f => f.ProductNo == outsoleMaster.ProductNo);
string memoId = "";
if (order != null)
{
outsoleMasterExportView.Country = order.Country;
outsoleMasterExportView.ShoeName = order.ShoeName;
outsoleMasterExportView.ArticleNo = order.ArticleNo;
outsoleMasterExportView.OutsoleCode = order.OutsoleCode;
outsoleMasterExportView.PatternNo = order.PatternNo;
outsoleMasterExportView.Quantity = order.Quantity;
outsoleMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
outsoleMasterExportView.MemoId = memoId;
}
//MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray);
//outsoleMasterExportView.IsOutsoleMatsArrivalOk = false;
//if (materialArrivalOutsole != null)
//{
// outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date);
// outsoleMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk;
//}
// Update follow OutsoleRawMaterial
//var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList();
//var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList();
//outsoleMasterExportView.IsOutsoleMatsArrivalOk = false;
//if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false)
//{
// outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max());
// outsoleMasterExportView.IsOutsoleMatsArrivalOk = true;
//}
//else
//{
// var etdDateList = osRawMaterial.Select(s => s.ETD).ToList();
// if (etdDateList.Count() > 0)
// {
// outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max());
// }
//}
outsoleMasterExportView.IsOutsoleMatsArrivalOk = false;
var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo);
if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) &&
!String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate))
{
outsoleMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate;
outsoleMasterExportView.IsOutsoleMatsArrivalOk = true;
}
else
{
outsoleMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD;
}
outsoleMasterExportView.OutsoleLine = outsoleMaster.OutsoleLine;
outsoleMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate;
outsoleMasterExportView.OutsoleFinishDate = outsoleMaster.OutsoleFinishDate;
outsoleMasterExportView.OutsoleQuota = outsoleMaster.OutsoleQuota;
outsoleMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
//RawMaterialModel outsoleRawMaterial = rawMaterialList.FirstOrDefault(f => f.ProductNo == outsoleMaster.ProductNo && materialIdOutsoleArray.Contains(f.MaterialTypeId));
//if (outsoleRawMaterial != null)
//{
// outsoleMasterExportView.OutsoleWHBalance = outsoleRawMaterial.Remarks;
//}
//else
//{
// outsoleMasterExportView.OutsoleWHBalance = "";
//}
// Load Outsole_Remarks from OutsoleMaterial
var outsoleMaterial_PO = outsoleMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList();
var osMaterialSumBySupplier = outsoleMaterial_PO.GroupBy(
g => g.OutsoleSupplierId)
.Select(s => new
{
PO = order.ProductNo,
Supplier = s.Key,
ActualDelivery = outsoleMaterial_PO.Where(w => w.OutsoleSupplierId == s.Key)
.Sum(su => su.Quantity - su.QuantityReject)
}).ToList();
// if pot no one delivery. not show the balance quantity.
if (osMaterialSumBySupplier.Count > 0 && order.Quantity - osMaterialSumBySupplier.Min(m => m.ActualDelivery) > 0)
{
// show the balance
outsoleMasterExportView.OutsoleWHBalance = (order.Quantity - osMaterialSumBySupplier.Min(m => m.ActualDelivery)).ToString();
// if no one delivery, show blank
if (outsoleMaterial_PO.Sum(s => s.Quantity) == 0)
{
outsoleMasterExportView.OutsoleWHBalance = "";
}
}
SewingMasterModel sewingMaster = sewingMasterList.FirstOrDefault(f => f.ProductNo == outsoleMaster.ProductNo);
if (sewingMaster != null)
{
outsoleMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
outsoleMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate;
outsoleMasterExportView.SewingQuota = sewingMaster.SewingQuota;
outsoleMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
outsoleMasterExportView.SewingStartDate = dtDefault;
outsoleMasterExportView.SewingFinishDate = dtDefault;
outsoleMasterExportView.SewingQuota = 0;
outsoleMasterExportView.SewingBalance = "";
}
List <OutsoleReleaseMaterialModel> outsoleReleaseMaterialList_D1 = outsoleReleaseMaterialList.Where(o => o.ProductNo == outsoleMaster.ProductNo).ToList();
int qtyReleased = outsoleReleaseMaterialList_D1.Sum(o => o.Quantity);
outsoleMasterExportView.ReleasedQuantity = qtyReleased.ToString();
if (qtyReleased <= 0)
{
outsoleMasterExportView.ReleasedQuantity = "";
}
if (qtyReleased >= outsoleMasterExportView.Quantity && outsoleReleaseMaterialList_D1.Count > 0)
{
DateTime releasedDate = outsoleReleaseMaterialList_D1.FirstOrDefault().ModifiedTime;
outsoleMasterExportView.ReleasedQuantity = string.Format("{0:M/d}", releasedDate);
}
outsoleMasterExportViewList.Add(outsoleMasterExportView);
}
}
public static bool Insert_2(SewingMasterModel model)
{
DateTime dtDefault = new DateTime(2000, 01, 01);
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine);
var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate);
var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate);
var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota);
var @SewingPrep = new SqlParameter("@SewingPrep", model.SewingPrep);
var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate);
var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate);
DateTime sewingActualStartDateAutoDt = TimeHelper.Convert(model.SewingActualStartDateAuto);
DateTime sewingActualFinishDateAutoDt = TimeHelper.Convert(model.SewingActualFinishDateAuto);
string sewingActualStartDateAutoString = "";
if (sewingActualStartDateAutoDt != dtDefault)
{
sewingActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualStartDateAutoDt);
}
string sewingActualFinishDateAutoString = "";
if (sewingActualFinishDateAutoDt != dtDefault)
{
sewingActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualFinishDateAutoDt);
}
var @SewingActualStartDateAuto = new SqlParameter("@SewingActualStartDateAuto", sewingActualStartDateAutoString);
var @SewingActualFinishDateAuto = new SqlParameter("@SewingActualFinishDateAuto", sewingActualFinishDateAutoString);
var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance);
var @CutAStartDate = new SqlParameter("@CutAStartDate", model.CutAStartDate);
var @CutAFinishDate = new SqlParameter("@CutAFinishDate", model.CutAFinishDate);
var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota);
DateTime cutAActualStartDateDt = TimeHelper.Convert(model.CutAActualStartDate);
DateTime cutAActualFinishDateDt = TimeHelper.Convert(model.CutAActualFinishDate);
string cutAActualStartDateString = "";
if (cutAActualStartDateDt != dtDefault)
{
cutAActualStartDateString = String.Format("{0:MM/dd/yyyy}", cutAActualStartDateDt);
}
string cutAActualFinishDateString = "";
if (cutAActualFinishDateDt != dtDefault)
{
cutAActualFinishDateString = String.Format("{0:MM/dd/yyyy}", cutAActualFinishDateDt);
}
var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", cutAActualStartDateString);
var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", cutAActualFinishDateString);
var @CutABalance = new SqlParameter("@CutABalance", model.CutABalance);
var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance);
var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance);
var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance);
DateTime cutBActualStartDateDt = TimeHelper.Convert(model.CutBActualStartDate);
string cutBActualStartDateString = "";
if (cutBActualStartDateDt != dtDefault)
{
cutBActualStartDateString = String.Format("{0:MM/dd/yyyy}", cutBActualStartDateDt);
}
var @CutBActualStartDate = new SqlParameter("@CutBActualStartDate", cutBActualStartDateString);
var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance);
var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut);
var @LaserCut = new SqlParameter("@LaserCut", model.LaserCut);
var @HuasenCut = new SqlParameter("@HuasenCut", model.HuasenCut);
var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate);
var @IsSewingLineUpdate = new SqlParameter("@IsSewingLineUpdate", model.IsSewingLineUpdate);
var @IsSewingStartDateUpdate = new SqlParameter("@IsSewingStartDateUpdate", model.IsSewingStartDateUpdate);
var @IsSewingFinishDateUpdate = new SqlParameter("@IsSewingFinishDateUpdate", model.IsSewingFinishDateUpdate);
var @IsSewingQuotaUpdate = new SqlParameter("@IsSewingQuotaUpdate", model.IsSewingQuotaUpdate);
var @IsSewingPrepUpdate = new SqlParameter("@IsSewingPrepUpdate", model.IsSewingPrepUpdate);
var @IsSewingActualStartDateUpdate = new SqlParameter("@IsSewingActualStartDateUpdate", model.IsSewingActualStartDateUpdate);
var @IsSewingActualFinishDateUpdate = new SqlParameter("@IsSewingActualFinishDateUpdate", model.IsSewingActualFinishDateUpdate);
var @IsSewingActualStartDateAutoUpdate = new SqlParameter("@IsSewingActualStartDateAutoUpdate", model.IsSewingActualStartDateAutoUpdate);
var @IsSewingActualFinishDateAutoUpdate = new SqlParameter("@IsSewingActualFinishDateAutoUpdate", model.IsSewingActualFinishDateAutoUpdate);
var @IsSewingBalanceUpdate = new SqlParameter("@IsSewingBalanceUpdate", model.IsSewingBalanceUpdate);
var @IsCutAStartDateUpdate = new SqlParameter("@IsCutAStartDateUpdate", model.IsCutAStartDateUpdate);
var @IsCutAFinishDateUpdate = new SqlParameter("@IsCutAFinishDateUpdate", model.IsCutAFinishDateUpdate);
var @IsCutAQuotaUpdate = new SqlParameter("@IsCutAQuotaUpdate", model.IsCutAQuotaUpdate);
var @IsCutAActualStartDateUpdate = new SqlParameter("@IsCutAActualStartDateUpdate", model.IsCutAActualStartDateUpdate);
var @IsCutAActualFinishDateUpdate = new SqlParameter("@IsCutAActualFinishDateUpdate", model.IsCutAActualFinishDateUpdate);
var @IsCutABalanceUpdate = new SqlParameter("@IsCutABalanceUpdate", model.IsCutABalanceUpdate);
var @IsPrintingBalanceUpdate = new SqlParameter("@IsPrintingBalanceUpdate", model.IsPrintingBalanceUpdate);
var @IsH_FBalanceUpdate = new SqlParameter("@IsH_FBalanceUpdate", model.IsH_FBalanceUpdate);
var @IsEmbroideryBalanceUpdate = new SqlParameter("@IsEmbroideryBalanceUpdate", model.IsEmbroideryBalanceUpdate);
var @IsCutBActualStartDateUpdate = new SqlParameter("@IsCutBActualStartDateUpdate", model.IsCutBActualStartDateUpdate);
var @IsCutBBalanceUpdate = new SqlParameter("@IsCutBBalanceUpdate", model.IsCutBBalanceUpdate);
var @IsAutoCutUpdate = new SqlParameter("@IsAutoCutUpdate", model.IsAutoCutUpdate);
var @IsLaserCutUpdate = new SqlParameter("@IsLaserCutUpdate", model.IsLaserCutUpdate);
var @IsHuasenCutUpdate = new SqlParameter("@IsHuasenCutUpdate", model.IsHuasenCutUpdate);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMaster_5 @ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate",
@ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate) > 0)
{
return(true);
}
return(false);
}
public static bool Insert_2(SewingMasterModel model, AccountModel account)
{
DateTime dtDefault = new DateTime(2000, 01, 01);
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine);
var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate);
var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate);
var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota);
var @SewingPrep = new SqlParameter("@SewingPrep", model.SewingPrep);
var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate);
var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate);
DateTime sewingActualStartDateAutoDt = TimeHelper.Convert(model.SewingActualStartDateAuto);
DateTime sewingActualFinishDateAutoDt = TimeHelper.Convert(model.SewingActualFinishDateAuto);
string sewingActualStartDateAutoString = "";
if (sewingActualStartDateAutoDt != dtDefault)
{
sewingActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualStartDateAutoDt);
}
string sewingActualFinishDateAutoString = "";
if (sewingActualFinishDateAutoDt != dtDefault)
{
sewingActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualFinishDateAutoDt);
}
var @SewingActualStartDateAuto = new SqlParameter("@SewingActualStartDateAuto", sewingActualStartDateAutoString);
var @SewingActualFinishDateAuto = new SqlParameter("@SewingActualFinishDateAuto", sewingActualFinishDateAutoString);
//var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance);
var sewingBalanceInsert = model.SewingBalance;
if (model.SewingBalance_Date != dtDefault)
{
sewingBalanceInsert = model.SewingBalance_Date.ToShortDateString();
}
var @SewingBalance = new SqlParameter("@SewingBalance", sewingBalanceInsert);
var @CutAStartDate = new SqlParameter("@CutAStartDate", model.CutAStartDate);
var @CutAFinishDate = new SqlParameter("@CutAFinishDate", model.CutAFinishDate);
var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota);
var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", model.CutAActualStartDate);
var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", model.CutAActualFinishDate);
var cutABalanceInsert = model.CutABalance;
if (model.CutABalance_Date != dtDefault)
{
cutABalanceInsert = model.CutABalance_Date.ToShortDateString();
}
var @CutABalance = new SqlParameter("@CutABalance", cutABalanceInsert);
var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance);
var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance);
var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance);
var @CutBActualStartDate = new SqlParameter("@CutBActualStartDate", model.CutBActualStartDate);
var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance);
var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut);
var @LaserCut = new SqlParameter("@LaserCut", model.LaserCut);
var @HuasenCut = new SqlParameter("@HuasenCut", model.HuasenCut);
var @CutBStartDate = new SqlParameter("@CutBStartDate", model.CutBStartDate);
var @AtomCutA = new SqlParameter("@AtomCutA", model.AtomCutA);
var @AtomCutB = new SqlParameter("@AtomCutB", model.AtomCutB);
var @LaserCutA = new SqlParameter("@LaserCutA", model.LaserCutA);
var @LaserCutB = new SqlParameter("@LaserCutB", model.LaserCutB);
var @HuasenCutA = new SqlParameter("@HuasenCutA", model.HuasenCutA);
var @HuasenCutB = new SqlParameter("@HuasenCutB", model.HuasenCutB);
var @ComelzCutA = new SqlParameter("@ComelzCutA", model.ComelzCutA);
var @ComelzCutB = new SqlParameter("@ComelzCutB", model.ComelzCutB);
var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate);
var @IsSewingLineUpdate = new SqlParameter("@IsSewingLineUpdate", model.IsSewingLineUpdate);
var @IsSewingStartDateUpdate = new SqlParameter("@IsSewingStartDateUpdate", model.IsSewingStartDateUpdate);
var @IsSewingFinishDateUpdate = new SqlParameter("@IsSewingFinishDateUpdate", model.IsSewingFinishDateUpdate);
var @IsSewingQuotaUpdate = new SqlParameter("@IsSewingQuotaUpdate", model.IsSewingQuotaUpdate);
var @IsSewingPrepUpdate = new SqlParameter("@IsSewingPrepUpdate", model.IsSewingPrepUpdate);
var @IsSewingActualStartDateUpdate = new SqlParameter("@IsSewingActualStartDateUpdate", model.IsSewingActualStartDateUpdate);
var @IsSewingActualFinishDateUpdate = new SqlParameter("@IsSewingActualFinishDateUpdate", model.IsSewingActualFinishDateUpdate);
var @IsSewingActualStartDateAutoUpdate = new SqlParameter("@IsSewingActualStartDateAutoUpdate", model.IsSewingActualStartDateAutoUpdate);
var @IsSewingActualFinishDateAutoUpdate = new SqlParameter("@IsSewingActualFinishDateAutoUpdate", model.IsSewingActualFinishDateAutoUpdate);
var @IsSewingBalanceUpdate = new SqlParameter("@IsSewingBalanceUpdate", model.IsSewingBalanceUpdate);
var @IsCutAStartDateUpdate = new SqlParameter("@IsCutAStartDateUpdate", model.IsCutAStartDateUpdate);
var @IsCutAFinishDateUpdate = new SqlParameter("@IsCutAFinishDateUpdate", model.IsCutAFinishDateUpdate);
var @IsCutAQuotaUpdate = new SqlParameter("@IsCutAQuotaUpdate", model.IsCutAQuotaUpdate);
var @IsCutAActualStartDateUpdate = new SqlParameter("@IsCutAActualStartDateUpdate", model.IsCutAActualStartDateUpdate);
var @IsCutAActualFinishDateUpdate = new SqlParameter("@IsCutAActualFinishDateUpdate", model.IsCutAActualFinishDateUpdate);
var @IsCutABalanceUpdate = new SqlParameter("@IsCutABalanceUpdate", model.IsCutABalanceUpdate);
var @IsPrintingBalanceUpdate = new SqlParameter("@IsPrintingBalanceUpdate", model.IsPrintingBalanceUpdate);
var @IsH_FBalanceUpdate = new SqlParameter("@IsH_FBalanceUpdate", model.IsH_FBalanceUpdate);
var @IsEmbroideryBalanceUpdate = new SqlParameter("@IsEmbroideryBalanceUpdate", model.IsEmbroideryBalanceUpdate);
var @IsCutBActualStartDateUpdate = new SqlParameter("@IsCutBActualStartDateUpdate", model.IsCutBActualStartDateUpdate);
var @IsCutBBalanceUpdate = new SqlParameter("@IsCutBBalanceUpdate", model.IsCutBBalanceUpdate);
var @IsAutoCutUpdate = new SqlParameter("@IsAutoCutUpdate", model.IsAutoCutUpdate);
var @IsLaserCutUpdate = new SqlParameter("@IsLaserCutUpdate", model.IsLaserCutUpdate);
var @IsHuasenCutUpdate = new SqlParameter("@IsHuasenCutUpdate", model.IsHuasenCutUpdate);
var @IsCutBStartDateUpdate = new SqlParameter("@IsCutBStartDateUpdate", model.IsUpdateCutBStartDate);
var @IsAtomCutAUpdate = new SqlParameter("@IsAtomCutAUpdate", model.IsUpdateAtomCutA);
var @IsAtomCutBUpdate = new SqlParameter("@IsAtomCutBUpdate", model.IsUpdateAtomCutB);
var @IsLaserCutAUpdate = new SqlParameter("@IsLaserCutAUpdate", model.IsUpdateLaserCutA);
var @IsLaserCutBUpdate = new SqlParameter("@IsLaserCutBUpdate", model.IsUpdateLaserCutB);
var @IsHuasenCutAUpdate = new SqlParameter("@IsHuasenCutAUpdate", model.IsUpdateHuasenCutA);
var @IsHuasenCutBUpdate = new SqlParameter("@IsHuasenCutBUpdate", model.IsUpdateHuasenCutB);
var @IsComelzCutAUpdate = new SqlParameter("@IsComelzCutAUpdate", model.IsUpdateComelzCutA);
var @IsComelzCutBUpdate = new SqlParameter("@IsComelzCutBUpdate", model.IsUpdateComelzCutB);
var @Reviser = new SqlParameter("@Reviser", account.FullName);
var @SewingActualStartDate_Date = new SqlParameter("@SewingActualStartDate_Date", model.SewingActualStartDate_Date);
var @SewingActualFinishDate_Date = new SqlParameter("@SewingActualFinishDate_Date", model.SewingActualFinishDate_Date);
var @CutAActualStartDate_Date = new SqlParameter("@CutAActualStartDate_Date", model.CutAActualStartDate_Date);
var @CutAActualFinishDate_Date = new SqlParameter("@CutAActualFinishDate_Date", model.CutAActualFinishDate_Date);
using (var db = new SaovietMasterScheduleEntities())
{
db.CommandTimeout = 120;
if (db.ExecuteStoreCommand(@"EXEC spm_InsertSewingMaster_10 @ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @CutBStartDate, @AtomCutA, @AtomCutB, @LaserCutA, @LaserCutB, @HuasenCutA, @HuasenCutB, @ComelzCutA, @ComelzCutB, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate, @IsCutBStartDateUpdate, @IsAtomCutAUpdate, @IsAtomCutBUpdate, @IsLaserCutAUpdate, @IsLaserCutBUpdate, @IsHuasenCutAUpdate, @IsHuasenCutBUpdate, @IsComelzCutAUpdate, @IsComelzCutBUpdate, @Reviser, @SewingActualStartDate_Date, @SewingActualFinishDate_Date, @CutAActualStartDate_Date, @CutAActualFinishDate_Date",
@ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @CutBStartDate, @AtomCutA, @AtomCutB, @LaserCutA, @LaserCutB, @HuasenCutA, @HuasenCutB, @ComelzCutA, @ComelzCutB, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate, @IsCutBStartDateUpdate, @IsAtomCutAUpdate, @IsAtomCutBUpdate, @IsLaserCutAUpdate, @IsLaserCutBUpdate, @IsHuasenCutAUpdate, @IsHuasenCutBUpdate, @IsComelzCutAUpdate, @IsComelzCutBUpdate, @Reviser, @SewingActualStartDate_Date, @SewingActualFinishDate_Date, @CutAActualStartDate_Date, @CutAActualFinishDate_Date) > 0)
{
return(true);
}
return(false);
}
}
