private void BindingStyleContent(PackStyleOrderModel model) { ClearBindingByPackStyle(); txtCustomer.Text = model.CustId + " - " + model.CustomerName; txtPackingStyle.Text = model.StyleCode; txtTotalQty.Text = model.TotalQuantity.ToString("0.00"); txtPackingRemark.Text = model.Remarks; }
public IEnumerable<SerialsPackingModel> GetSerialForFirstDefault(PackStyleOrderModel model) { string sql = string.Format(@"SELECT mat.Possession, busi.Key1 as BussinessType, busi.Character01 as BussinessTypeName , cmdt.Key1 as CommodityCode, cmdt.Character01 as CommodityName , spec.Key1 as SpecCode, spec.Character01 as SpecName, spec.Number01 as Gravity , coat.Key1 as CoatingCode, ISNULL(coat.Character01, '') as CoatingName, ISNULL(coat.Number01, 0.00) as FrontPlate, ISNULL(coat.Number02, 0.00) as BackPlate , pkg.LineID as HeadLineID, gsn.UnitWeight , gsn.LineID as SerialLineID, gsn.SerialNo, gsn.Thick, gsn.Width, gsn.Length , 0 as LineID, {3} as PackStyleLineID, N'{2}' as PackingStyleCode, 0 as PackingDesignId, '' as SkidNumber, 0 as CompleteFlag FROM ucc_pln_SerialGenerated gsn INNER JOIN ucc_pkg_Header pkg ON(gsn.WorkOrderID = pkg.WorkOrderID) LEFT JOIN ucc_pln_Material mat ON(gsn.MaterialTransLineID = mat.TransactionLineID) LEFT JOIN ucc_pln_CuttingDesign cut ON(gsn.CuttingLineID = cut.LineID) LEFT JOIN ucc_pln_PlanHead pln ON(gsn.WorkOrderID = pln.WorkOrderID) LEFT JOIN UD25 busi ON(mat.BT = busi.Key1) LEFT JOIN UD29 cmdt ON(mat.Cmdty = cmdt.Key1) LEFT JOIN UD30 spec ON(mat.Cmdty = spec.Key2 and mat.Spec = spec.Key1) LEFT JOIN UD31 coat ON(mat.Coating = coat.Key1) LEFT JOIN OrderDtl odt ON(cast(cut.SONo as int) = odt.OrderNum AND odt.OrderLine = cut.SOLine) LEFT JOIN UD12 nor ON(cut.NORNum = nor.Key1) WHERE ProductionUsedFlag = 0 AND gsn.Status = 'F' AND pkg.LineID = {0} --{0} //HeadLineId AND odt.Character01 = N'{1}' --N'{1}' //CustId AND nor.ShortChar11 = N'{2}' --N'{2}' //StyleCode CS-0002,CU-0001", model.HeadLineID, model.CustId, model.StyleCode, model.Id); return Repository.Instance.GetMany<SerialsPackingModel>(sql); }
private void tbutSave_Click(object sender, EventArgs e) { PackingOrderModel model = new PackingOrderModel(); model.WorkOrderId = HeaderContent.WorkOrderId; model.Remark = txtRemark.Text.ToString(); model.CompleteFlag = (HeaderContent.SerialLines.Where(i => i.DesignedPack == false).ToList().Count > 0) ? 0 : 1; if (_repo.SavePackOrder(epiSession, model, out HeaderContent)) { PackStyleOrderModel styles = new PackStyleOrderModel(); styles.HeadLineID = HeaderContent.Id; styles.StyleCode = dgvPackStyle.CurrentRow.Cells["packstyle"].Value.ToString(); styles.Remarks = txtPackingRemark.Text.ToString(); if (_repo.SavePackStyles(epiSession, null, styles)) { MessageBox.Show("Save complete.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); HeaderContent.PackStyles = _repo.GetPackStyleByPackOrder(HeaderContent.WorkOrderId).ToList(); } } }
public bool SavePackStyles(SessionInfo _session, IEnumerable<PackStyleOrderModel> packStyles = null, PackStyleOrderModel model = null) { bool isSuccess = false; string sql = string.Empty; //resultRow = null; if (packStyles != null && model == null) { foreach (var item in packStyles) { sql += string.Format(@"IF NOT EXISTS ( SELECT * FROM ucc_pkg_PackStyleList (NOLOCK) WHERE HeadLineID = {1} AND StyleCode = N'{3}' ) BEGIN INSERT INTO ucc_pkg_PackStyleList (Plant ,HeadLineID ,CustID ,StyleCode ,TotalQuantity ,ThickMin ,ThickMax ,WidthMin ,WidthMax ,Remarks ,CompleteFlag ,CreationDate ,LastUpdateDate ,CreatedBy ,UpdatedBy ,CoilWeigthPackMin ,CoilWeigthPackMax ,CoilPerPackMin ,CoilPerPackMax) VALUES (N'{0}' --<Plant, nvarchar(8),> ,{1} --<HeadLineID, bigint,> ,N'{2}' --<CustID, nvarchar(25),> ,N'{3}' --<StyleCode, nvarchar(45),> ,{4} --<TotalQuantity, int,> ,{5} --<ThickMin, decimal(15,9),> ,{6} --<ThickMax, decimal(15,9),> ,{7} --<WidthMin, decimal(15,9),> ,{8} --<WidthMax, decimal(15,9),> ,N'{9}' --<Remarks, nvarchar(max),> ,{10} --<CompleteFlag, int,> ,GETDATE() --<CreationDate, datetime,> ,GETDATE() --<LastUpdateDate, datetime,> ,N'{11}' --<CreatedBy, nvarchar(45),> ,N'{11}' --<UpdatedBy, nvarchar(45),> ,{12} ,{13} ,{14} ,{15} ) END ELSE BEGIN UPDATE ucc_pkg_PackStyleList SET Remarks = N'{9}' --<Remarks, nvarchar(max),> ,CompleteFlag = {10} --<CompleteFlag, int,> ,HeadLineID = {1} --<HeadLineID, bigint,> ,CustID = N'{2}' --<CustID, nvarchar(25),> ,StyleCode = N'{3}' --<StyleCode, nvarchar(45),> ,TotalQuantity = {4} --<TotalQuantity, int,> ,ThickMin = {5} --<ThickMin, decimal(15,9),> ,ThickMax = {6} --<ThickMax, decimal(15,9),> ,WidthMin = {7} --<WidthMin, decimal(15,9),> ,WidthMax = {8} --<WidthMax, decimal(15,9),> ,LastUpdateDate = GETDATE() --<LastUpdateDate, datetime,> ,UpdatedBy = N'{11}' --<UpdatedBy, nvarchar(45),> ,CoilWeigthPackMin = {12} --<CoilWeigthPackMin, decimal(15,9),> ,CoilWeigthPackMax = {13} --<CoilWeigthPackMax, decimal(15,9),> ,CoilPerPackMin = {14} --<CoilPerPackMin, decimal(15,9),> ,CoilPerPackMax = {15} --<CoilPerPackMax, decimal(15,9),> WHERE HeadLineID = {1} AND StyleCode = N'{3}' END " + Environment.NewLine , _session.PlantID , item.HeadLineID , item.CustId , item.StyleCode , item.TotalQuantity , item.ThickMin , item.ThickMax , item.WidthMin , item.WidthMax , item.Remarks , 0 , _session.UserID , item.CoilWeigthPackMin , item.CoilWeigthPackMax , item.CoilPerPackMin , item.CoilPerPackMax); } } else if (packStyles == null && model != null) { sql = string.Format(@"UPDATE ucc_pkg_PackStyleList SET Remarks = N'{2}' --<Remarks, nvarchar(max),> ,CompleteFlag = {3} --<CompleteFlag, int,> ,LastUpdateDate = GETDATE() --<LastUpdateDate, datetime,> ,UpdatedBy = N'{4}' --<UpdatedBy, nvarchar(45),> WHERE HeadLineID = {0} AND StyleCode = N'{1}'" + Environment.NewLine , model.HeadLineID , model.StyleCode , model.Remarks , 0 , _session.UserID); } try { Repository.Instance.ExecuteWithTransaction(sql, "Update Planning"); isSuccess = true; } catch { isSuccess = false; } return isSuccess; }