public bool GetDropDownSource(CostSheetModel costSheet) { try { DataTable dt = new DataTable(); dt = ToDataTable((from o in DB.DDRM_MAST where ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) orderby o.RM_CODE select new { o.RM_CODE, o.RM_DESC }).ToList()); if (dt != null) { costSheet.DVRMBasic = dt.Copy().DefaultView; } else { costSheet.DVRMBasic = null; } return(true); } catch (Exception ex) { throw ex.LogException(); } }
public bool GetProcessMain(CostSheetModel costSheet, int currentproc = 0) { try { DataTable dt = new DataTable(); dt = ToDataTable((from o in DB.PROCESS_MAIN where o.PART_NO == costSheet.PART_NO && o.CURRENT_PROC == ((currentproc > 0) ? currentproc : o.CURRENT_PROC) && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) orderby o.ROUTE_NO select new { o.ROUTE_NO }).ToList()); if (dt != null) { costSheet.DVProcessMain = dt.DefaultView; } else { costSheet.DVProcessMain = null; } return(true); } catch (Exception ex) { throw ex.LogException(); } }
public CostSheetViewModel(UserInformation userinfo, string partNo, int routeNo) { _costSheet = new CostSheetModel(); userInformation = userinfo; bll = new CostSheetBll(userinfo); this._closeCommand = new DelegateCommand(this.Close); this._onPartNoSelectionChanged = new DelegateCommand(this.PartNoSelectionChanged); this._onProcessNoSelectionChanged = new DelegateCommand(this.ProcessNoSelectionChanged); this._onRMSelectionChanged = new DelegateCommand(this.RMSelectionChanged); this._printCommand = new DelegateCommand(this.Print); this._onCheckedChanged = new DelegateCommand(this.CheckedChanged); bll.GetProductMaster(CostSheet); bll.GetDropDownSource(CostSheet); CostSheet.PART_NO = partNo; PartNoSelectionChanged(); CostSheet.ROUTE_NO = routeNo; ProcessNoSelectionChanged(); DropdownHeaders = new ObservableCollection <DropdownColumns> { new DropdownColumns { ColumnName = "PART_NO", ColumnDesc = "Part Number", ColumnWidth = "1*" }, new DropdownColumns { ColumnName = "PART_DESC", ColumnDesc = "Part Description", ColumnWidth = "1*" } }; RouteNoDropdownHeaders = new ObservableCollection <DropdownColumns> { new DropdownColumns { ColumnName = "ROUTE_NO", ColumnDesc = "Process Number", ColumnWidth = "1*" } }; RMDropdownHeaders = new ObservableCollection <DropdownColumns> { new DropdownColumns { ColumnName = "RM_CODE", ColumnDesc = "RM Code", ColumnWidth = 120 }, new DropdownColumns { ColumnName = "RM_DESC", ColumnDesc = "RM Description", ColumnWidth = "1*" } }; }
public bool GetProductMaster(CostSheetModel costSheet) { try { DataTable dt = new DataTable(); dt = ToDataTable((from o in DB.PRD_MAST where ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select new { o.PART_NO, o.PART_DESC }).ToList()); if (dt != null) { costSheet.DVProductMaster = dt.DefaultView; } else { costSheet.DVProductMaster = null; } return(true); } catch (Exception ex) { throw ex.LogException(); } }
public bool GetCostSheetDetails(CostSheetModel costSheet) { try { DataTable dt = new DataTable(); PROCESS_MAIN pm = (from o in DB.PROCESS_MAIN where o.PART_NO == costSheet.PART_NO && o.ROUTE_NO == costSheet.ROUTE_NO && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select o).FirstOrDefault <PROCESS_MAIN>(); if (pm != null) { costSheet.WIRE_ROD_CD = pm.WIRE_ROD_CD; } else { costSheet.WIRE_ROD_CD = ""; costSheet.RMCOST = null; } pm = null; var q = (from a in DB.PRD_MAST join b in DB.PROCESS_MAIN on a.PART_NO equals b.PART_NO join c in DB.PRD_CIREF on a.PART_NO equals c.PART_NO join d in DB.DDCI_INFO on c.CI_REF equals d.CI_REFERENCE join e in DB.DDCUST_MAST on d.CUST_CODE equals e.CUST_CODE join f in DB.DDFINISH_MAST on d.FINISH_CODE equals f.FINISH_CODE where a.PART_NO == costSheet.PART_NO && b.ROUTE_NO == costSheet.ROUTE_NO && b.CURRENT_PROC == 1 && c.CURRENT_CIREF == true select new { a.PART_DESC, a.FINISH_WT, a.BIF_PROJ, CUSTOMER = (d.CUST_CODE + "-" + e.CUST_NAME), CUST = e.CUST_CODE.ToString().Substring(0, 1), b.CHEESE_WT, FINISH_DESC = (d.FINISH_CODE + '-' + f.FINISH_DESC) }).FirstOrDefault(); if (q != null) { costSheet.FINISH_WT = q.FINISH_WT; costSheet.LOCATION = (q.BIF_PROJ.IsNotNullOrEmpty()) ? q.BIF_PROJ : "0"; costSheet.CUSTOMER = q.CUSTOMER; costSheet.CUSTCODE = q.CUST; costSheet.CHEESE_WT = q.CHEESE_WT; costSheet.FINISH_DESC = q.FINISH_DESC; } else { costSheet.FINISH_WT = null; costSheet.LOCATION = "0"; costSheet.CUSTOMER = ""; costSheet.CUSTCODE = ""; costSheet.CHEESE_WT = null; costSheet.FINISH_DESC = ""; } if (!costSheet.ExportIsClicked) { if (costSheet.CUSTCODE.IsNotNullOrEmpty() && costSheet.CUSTCODE == "8") { costSheet.EXPORT = true; } else { costSheet.EXPORT = false; } } costSheet.DVCostSheet = ToDataTableWithType((from a in DB.PROCESS_SHEET join b in DB.PROCESS_CC on new { a.PART_NO, a.ROUTE_NO, a.SEQ_NO } equals new { b.PART_NO, b.ROUTE_NO, b.SEQ_NO } join c in DB.PROCESS_MAIN on a.PART_NO equals c.PART_NO where a.PART_NO == costSheet.PART_NO && b.ROUTE_NO == costSheet.ROUTE_NO && c.CURRENT_PROC == 1 && b.CC_SNO == 1 select new { a.SEQ_NO, a.OPN_CD, a.OPN_DESC, b.CC_CODE, b.OUTPUT, VAR_COST = 0.0, FIX_COST = 0.0, SPL_COST = 0.0, OPN_COST = 0.0 }).ToList()).DefaultView; if (costSheet.DVCostSheet != null) { foreach (DataRowView cs in costSheet.DVCostSheet) { cs.BeginEdit(); switch (cs["OPN_CD"].ToString().ToIntValue()) { case 1000: var innerQuery = (from o in DB.DDRM_PROCESS where o.LOC_CODE == costSheet.LOCATION && o.RM_CODE == costSheet.WIRE_ROD_CD select o.COST_CENT_CODE).Distinct(); DDCC_OPER cco = (from o in DB.DDCC_OPER where innerQuery.Contains(o.COST_CENT_CODE) && o.OPN_CODE == 1000 select o).FirstOrDefault <DDCC_OPER>(); CostSheetGridUpdate(cs, cco, costSheet.CHEESE_WT.ToValueAsString().ToDoubleValue(), costSheet.FINISH_WT.ToValueAsString().ToDoubleValue()); break; case 2600: DDCC_OPER cco1 = new DDCC_OPER(); switch (costSheet.LOCATION) { case "MM": if (costSheet.EXPORT) { cco1 = (from o in DB.DDCC_OPER where o.OPN_CODE == 2600 && o.COST_CENT_CODE == "EXP PKG" select o).FirstOrDefault <DDCC_OPER>(); } else { cco1 = (from o in DB.DDCC_OPER where o.OPN_CODE == 2600 && o.COST_CENT_CODE == "OE PKG" select o).FirstOrDefault <DDCC_OPER>(); } break; case "KK": if (costSheet.EXPORT) { cco1 = (from o in DB.DDCC_OPER where o.OPN_CODE == 2600 && o.COST_CENT_CODE == "EXP PKG - K" select o).FirstOrDefault <DDCC_OPER>(); } else { cco1 = (from o in DB.DDCC_OPER where o.OPN_CODE == 2600 && o.COST_CENT_CODE == "OE PKG - K" select o).FirstOrDefault <DDCC_OPER>(); } break; } CostSheetGridUpdate(cs, cco1, costSheet.CHEESE_WT.ToValueAsString().ToDoubleValue(), costSheet.FINISH_WT.ToValueAsString().ToDoubleValue()); break; default: DDCC_OPER cco2 = (from o in DB.DDCC_OPER where o.OPN_CODE == cs["OPN_CD"].ToString().ToDecimalValue() && o.COST_CENT_CODE == cs["CC_CODE"].ToString() select o).FirstOrDefault <DDCC_OPER>(); CostSheetGridUpdate(cs, cco2, costSheet.CHEESE_WT.ToValueAsString().ToDoubleValue(), costSheet.FINISH_WT.ToValueAsString().ToDoubleValue()); break; } cs.EndEdit(); } costSheet.COST = costSheet.DVCostSheet.Table.Compute("SUM(OPN_COST)", "").ToString().ToDecimalValue(); } else { costSheet.DVCostSheet = null; costSheet.COST = 0; } return(true); } catch (Exception ex) { throw ex.LogException(); } }