public MFMPlanDetailsViewModel(UserInformation userinfo) { userInformation = userinfo; mfmplandetails = new MFMPlanDetailsModel(); bll = new MFMPlanDetailsBll(userinfo); this._windowLoadedCommand = new DelegateCommand(this.WindowLoaded); this.refreshCommand = new DelegateCommand(this.Refresh); this.editDataCommand = new DelegateCommand(this.EditData); this.printCommand = new DelegateCommand(this.Print); this.onCheckBoxClicked = new DelegateCommand <string>(this.CheckBoxClicked); this.onGroupBoxDoubleClicked = new DelegateCommand(this.GroupBoxDoubleClicked); }
public bool GetMFMPlanDetils(MFMPlanDetailsModel mfmPlanDetails) { try { string getQuery = " select CASE SUBSTRING(loc_code,1,1) WHEN 'M' THEN 'PADI' WHEN 'K' THEN 'KPM' WHEN 'Y' THEN 'PONDY' ELSE '' END as Location,module,cc_abbr ,cust_name ,part_no,part_desc,pg_category,resp,remarks from mfm_mast_view " + " where ( cancel_status = 0 or cancel_status is null ) and ( hold_me =0 or hold_me is null ) and (( part_no is null and part_desc is null )"; if (mfmPlanDetails.GroupHeader == "Awaiting") { if (mfmPlanDetails.IsDocumentation) { getQuery = " select CASE SUBSTRING(c.loc_code,1,1) WHEN 'M' THEN 'PADI' WHEN 'K' THEN 'KPM' WHEN 'Y' THEN 'PONDY' ELSE '' END as Location,f.cust_name,a.part_no,b.part_desc,b.pg_category,a.resp,a.remarks " + " from mfm_mast A,prd_mast b,ddloc_mast c,prd_ciref d ,ddci_info e,ddcust_mast f" + " where a.doc_rel_dt_actual is null and a.doc_rel_dt_plan is not null " + " and ( b.cancel_status =0 or b.cancel_status is null ) and ( b.hold_me =0 or b.hold_me is null ) and ( allot_date > convert(datetime, '31/03/1999', 103) and " + " ( b.part_no like 'M%' or b.part_no like 'S%' ) and a.part_no=b.part_no and b.bif_proj =C.loc_code and b.part_no=d.part_no AND d.CURRENT_CIREF = 1 and d.ci_ref=e.ci_reference and e.cust_code=f.cust_code and samp_submit_date is null "; //+ " ( b.part_no like 'M%' or b.part_no like 'S%' ) and a.part_no=b.part_no and b.bif_proj =C.loc_code and b.part_no=d.part_no and d.ci_ref=e.ci_reference and e.cust_code=f.cust_code and samp_submit_date is null "; } if (mfmPlanDetails.IsTools) { getQuery = getQuery + " or ( tools_ready_actual_dt is null and doc_rel_dt_actual > convert(datetime, '31/03/1999', 103) and allot_date > convert(datetime, '31/03/1999', 103) and samp_submit_date is null) "; } if (mfmPlanDetails.IsForging) { getQuery = getQuery + " or ( forging_actual_dt is null and tools_ready_actual_dt is not null and doc_rel_dt_actual > convert(datetime, '31/03/1999', 103) and allot_date > convert(datetime, '31/03/1999', 103) and samp_submit_date is null) "; } if (mfmPlanDetails.IsSecondary) { getQuery = getQuery + " or ( forging_actual_dt is not null and secondary_actual_dt is null and heat_treatment_actual is null and doc_rel_dt_actual > convert(datetime, '31/03/1999', 103) and allot_date > convert(datetime, '31/03/1999', 103) and samp_submit_date is null ) "; } if (mfmPlanDetails.IsPPAP) { getQuery = getQuery + " or ( forging_actual_dt is not null and tools_ready_actual_dt is not null and secondary_actual_dt is not null and heat_treatment_actual is not null and ppap_actual_dt is null and doc_rel_dt_actual > convert(datetime, '31/03/1999', 103) and allot_date > convert(datetime, '31/03/1999', 103) and samp_submit_date is null and ppap_actual_dt is null ) "; } if (mfmPlanDetails.IsAwaitingPSW) { getQuery = getQuery + " or ( samp_submit_date > convert(datetime, '31/03/1999', 103) and PSW_ST='NO') "; } } else { if (mfmPlanDetails.IsDocumentation) { getQuery = getQuery + " OR (DOC_REL_DT_ACTUAL IS NULL AND SUBSTRING(convert(varchar(10), DOC_REL_DT_PLAN, 112),1,6) = '" + mfmPlanDetails.Month + "')"; } if (mfmPlanDetails.IsTools) { getQuery = getQuery + " OR (TOOLS_READY_ACTUAL_DT IS NULL AND SUBSTRING(convert(varchar(10), TOOLS_READY_DT_PLAN, 112),1,6) = '" + mfmPlanDetails.Month + "')"; } if (mfmPlanDetails.IsForging) { getQuery = getQuery + " OR (FORGING_ACTUAL_DT IS NULL AND SUBSTRING(convert(varchar(10), FORGING_PLAN_DT, 112),1,6) = '" + mfmPlanDetails.Month + "')"; } if (mfmPlanDetails.IsSecondary) { getQuery = getQuery + " OR (SECONDARY_ACTUAL_DT IS NULL AND SUBSTRING(convert(varchar(10), SECONDARY_PLAN_DT, 112),1,6) = '" + mfmPlanDetails.Month + "')"; } if (mfmPlanDetails.IsPPAP) { getQuery = getQuery + " OR (PPAP_ACTUAL_DT IS NULL AND SUBSTRING(convert(varchar(10), PPAP_PLAN, 112),1,6) = '" + mfmPlanDetails.Month + "')"; } } if (mfmPlanDetails.IsApprovedPSW) { getQuery = getQuery + " OR (PSW_ST='YES' AND PSW_DATE IS NOT NULL)"; } getQuery = getQuery + ")"; DataTable getprocess = ToDataTable(DB.ExecuteQuery <MFMPlanDetailsGrid>(getQuery).ToList()); if (getprocess == null) { mfmPlanDetails.DVMFMPlanDetails = null; mfmPlanDetails.ProductCount = "0"; } else { mfmPlanDetails.DVMFMPlanDetails = getprocess.DefaultView; mfmPlanDetails.ProductCount = mfmPlanDetails.DVMFMPlanDetails.Count.ToString(); } return(true); } catch { mfmPlanDetails.DVMFMPlanDetails = null; mfmPlanDetails.ProductCount = "0"; return(false); } }