Пример #1
0
        public List <PRD_DWG_ISSUE> GetDrawingIssueDetailsByPartNumber(PRD_DWG_ISSUE paramEntity = null)
        {
            List <PRD_DWG_ISSUE> lstEntity = null;

            try
            {
                if (!DB.IsNotNullOrEmpty())
                {
                    return(lstEntity);
                }
                if (paramEntity.IsNotNullOrEmpty() && paramEntity.PART_NO.IsNotNullOrEmpty())
                {
                    lstEntity = (from row in DB.PRD_DWG_ISSUE
                                 where row.PART_NO == paramEntity.PART_NO && row.DWG_TYPE == paramEntity.DWG_TYPE
                                 orderby row.ISSUE_DATE descending, row.ISSUE_NO descending
                                 select row).ToList <PRD_DWG_ISSUE>();
                }
                else
                {
                    lstEntity = (from row in DB.PRD_DWG_ISSUE
                                 where row.DWG_TYPE == 1
                                 orderby row.ISSUE_DATE descending, row.ISSUE_NO descending
                                 select row).ToList <PRD_DWG_ISSUE>();
                }
            }
            catch (Exception ex)
            {
                ex.LogException();
            }

            return(lstEntity);
        }
Пример #2
0
        public bool DeleteIssueDetails(DrawingModel1 drwgModel)
        {
            bool _status = false;

            drwgModel.Status = "";
            try
            {
                if (drwgModel.SelectedItem["ISSUE_NO"].ToString() != "")
                {
                    int           dwg_type     = (drwgModel.DWG_TYPE_DESC == "Sequence Drawing") ? 1 : 0;
                    PRD_DWG_ISSUE prddwgIssues = (from o in DB.PRD_DWG_ISSUE
                                                  where o.ISSUE_NO == Convert.ToDecimal(drwgModel.SelectedItem["ISSUE_NO"].ToString()) && o.PART_NO == drwgModel.PART_NO && o.DWG_TYPE == dwg_type
                                                  select o).SingleOrDefault <PRD_DWG_ISSUE>();

                    if (prddwgIssues != null)
                    {
                        DB.PRD_DWG_ISSUE.DeleteOnSubmit(prddwgIssues);
                        DB.SubmitChanges();
                        _status = true;
                    }
                }
            }
            catch (System.Data.Linq.ChangeConflictException)
            {
                DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
                _status = true;
            }
            catch (Exception ex)
            {
                ex.LogException();
            }
            return(_status);
        }
Пример #3
0
        public bool InsertDrawingRevisionDetails(DrawingModel1 drawingModel, DataView dV_PROD_DWG_ISSUE)
        {
            PRD_DWG_ISSUE prdDwgIssue = new PRD_DWG_ISSUE();
            bool          insert      = false;
            bool          update      = false;
            bool          submit      = false;

            try
            {
                int dwg_type = (drawingModel.DWG_TYPE_DESC == "Sequence Drawing") ? 1 : 0;

                List <PRD_DWG_ISSUE> lstexistingDatas = new List <PRD_DWG_ISSUE>();
                lstexistingDatas = ((from o in DB.PRD_DWG_ISSUE
                                     where o.PART_NO == drawingModel.PART_NO && o.DWG_TYPE == dwg_type
                                     select o).ToList());
                if (lstexistingDatas.Count > 0)
                {
                    DB.PRD_DWG_ISSUE.DeleteAllOnSubmit(lstexistingDatas);
                    DB.SubmitChanges();
                }

                foreach (DataRow dr in dV_PROD_DWG_ISSUE.ToTable().AsEnumerable())
                {
                    if (dr["ISSUE_NO"].ToString() != "")
                    {
                        prdDwgIssue = (from o in DB.PRD_DWG_ISSUE
                                       where o.ISSUE_NO == Convert.ToDecimal(dr["issue_No"].ToString()) && o.PART_NO == drawingModel.PART_NO && o.DWG_TYPE == dwg_type
                                       select o).FirstOrDefault <PRD_DWG_ISSUE>();
                        if (prdDwgIssue == null)
                        {
                            prdDwgIssue             = new PRD_DWG_ISSUE();
                            prdDwgIssue.PART_NO     = drawingModel.PART_NO;
                            prdDwgIssue.DWG_TYPE    = dwg_type;
                            prdDwgIssue.Loc_Code    = dr["Loc_Code"].ToValueAsString();
                            prdDwgIssue.ISSUE_NO    = Convert.ToDecimal(dr["issue_No"]);
                            prdDwgIssue.ISSUE_DATE  = Convert.ToDateTime(dr["ISSUE_DATE"]);
                            prdDwgIssue.ISSUE_ALTER = dr["issue_alter"].ToString();
                            prdDwgIssue.COMPILED_BY = dr["COMPILED_BY"].ToString();
                            insert = true;
                            DB.PRD_DWG_ISSUE.InsertOnSubmit(prdDwgIssue);
                            submit = true;
                            DB.SubmitChanges();
                        }
                        else
                        {
                            prdDwgIssue.PART_NO     = drawingModel.PART_NO;
                            prdDwgIssue.DWG_TYPE    = dwg_type;
                            prdDwgIssue.Loc_Code    = dr["Loc_Code"].ToValueAsString();
                            prdDwgIssue.ISSUE_NO    = Convert.ToDecimal(dr["issue_No"]);
                            prdDwgIssue.ISSUE_DATE  = Convert.ToDateTime(dr["ISSUE_DATE"]);
                            prdDwgIssue.ISSUE_ALTER = dr["issue_alter"].ToString();
                            prdDwgIssue.COMPILED_BY = dr["COMPILED_BY"].ToString();
                            update = true;
                            submit = true;
                            DB.SubmitChanges();
                        }
                    }
                }
                //DB.Transaction.Commit();
            }
            catch (System.Data.Linq.ChangeConflictException)
            {
                DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
                drawingModel.Status = PDMsg.UpdatedSuccessfully;
                return(false);
            }
            catch (Exception ex)
            {
                if (submit == true)
                {
                    if (insert == true)
                    {
                        DB.PRD_DWG_ISSUE.DeleteOnSubmit(prdDwgIssue);
                    }
                    if (update == true)
                    {
                        DB.PRD_DWG_ISSUE.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, prdDwgIssue);
                    }
                }
                //DB.Transaction.Rollback();
                ex.LogException();
                return(false);
            }
            drawingModel.Status = PDMsg.UpdatedSuccessfully;
            return(true);
        }
Пример #4
0
        public DataView PrintCPRpt(ControlPlanRptModel cpRptModel, string seqNos)
        {
            DataView dtv = new DataView();
            string   sqlLoca, sqlCustQry, sqlOrgDateQry, sqlRevDateQry = "";
            string   supplierLoc = "";

            try
            {
                StringBuilder sbsql = new StringBuilder();
                sqlLoca = " select bif_proj from prd_mast where part_no= '" + cpRptModel.PartNo + "'";
                // sqlCustQry = "select CUST_DWG_NO from  ddci_info where  ci_reference in (select ci_ref from prd_ciref where part_no='" + cpRptModel.PartNo + "' AND CURRENT_CIREF = 1 )";
                sqlOrgDateQry = "select issue_date from pccs_issue  where (ISSUE_NO='1' or ISSUE_NO='01' or ISSUE_NO='001') AND part_no =  '" + cpRptModel.PartNo + "' and route_no in (select route_no from process_main where part_no = '" + cpRptModel.PartNo + "' and current_proc = 1)";
                //  "select min(ISSUE_DATE) as ISSUE_DATE from PCCS_ISSUE where PART_NO='" + cpRptModel.PartNo + "'";

                ///Location
                try
                {
                    supplierLoc = DB.ExecuteQuery <string>(sqlLoca.ToString()).FirstOrDefault <string>().ToValueAsString();
                    if (supplierLoc.ToUpper().Trim() == "MM" || supplierLoc.ToUpper().Trim() == "MN" || supplierLoc.ToUpper().Trim() == "MS")
                    {
                        supplierLoc = "Padi";
                    }
                    else if (supplierLoc.ToUpper().Trim() == "KK" || supplierLoc.ToUpper().Trim() == "KS")
                    {
                        supplierLoc = "Krishnapuram";
                    }
                    else
                    {
                        supplierLoc = "Pondy";
                    }
                    ///End
                    //IEnumerable<string> sqlCusts = DB.ExecuteQuery<string>(sqlCustQry).ToList();
                    //if (sqlCusts != null)
                    //{
                    //    sqlCustQry = sqlCusts.FirstOrDefault();
                    //}
                    //else
                    //{
                    //    sqlCustQry = "";
                    //}

                    //List<PCCS_ISSUE> lstOrgDate = (from row in DB.PCCS_ISSUE
                    //                               where row.PART_NO == cpRptModel.PartNo
                    //                               orderby row.ISSUE_DATE
                    //                               select row).ToList<PCCS_ISSUE>();

                    /// OrgDate -Revised Date
                    DateTime?sqlOrgDate = null;
                    DateTime?sqlRevDate = null;
                    //if (lstOrgDate.IsNotNullOrEmpty() && lstOrgDate.Count > 0)
                    //{
                    //    sqlOrgDate = lstOrgDate[0].ISSUE_DATE;
                    //    sqlRevDate = lstOrgDate[lstOrgDate.Count - 1].ISSUE_DATE;
                    //}
                    sqlOrgDate = DB.ExecuteQuery <DateTime>(sqlOrgDateQry.ToString()).FirstOrDefault <DateTime>();
                    if (sqlOrgDate != null && Convert.ToDateTime(sqlOrgDate).ToString("dd/MM/yyyy") != "01/01/0001")
                    {
                        if (sqlOrgDate.IsNotNullOrEmpty())
                        {
                            sqlOrgDateQry = Convert.ToDateTime(sqlOrgDate).ToString("dd/MM/yyyy");
                        }
                        else
                        {
                            sqlOrgDateQry = "--";
                        }
                    }
                    else
                    {
                        sqlOrgDateQry = "--";
                    }
                    //IEnumerable<Nullable<DateTime>> sqlRevDate = DB.ExecuteQuery<Nullable<DateTime>>(sqlRevDateQry);

                    sqlRevDateQry = "select max(ISSUE_DATE) as ISSUE_DATE from PCCS_ISSUE where PART_NO='" + cpRptModel.PartNo + "' and route_no='" + cpRptModel.RouteNo + "'";
                    sqlRevDate    = DB.ExecuteQuery <DateTime>(sqlRevDateQry.ToString()).FirstOrDefault <DateTime>();
                    sqlRevDateQry = "select * from pccs_issue where  part_no='" + cpRptModel.PartNo + "' and route_no='" + cpRptModel.RouteNo + "'";
                    DataTable dtrev = ToDataTableWithType(DB.ExecuteQuery <PCCS_ISSUE>(sqlRevDateQry).ToList());
                    if (sqlRevDate != null && Convert.ToDateTime(sqlRevDate).ToString("dd/MM/yyyy") != "01/01/0001")
                    {
                        if (sqlRevDate.IsNotNullOrEmpty())
                        {
                            dtrev.DefaultView.RowFilter = "issue_date='" + sqlRevDate.ToDateAsString() + "'";
                        }
                        if (dtrev.Rows.Count > 0 && dtrev.DefaultView[0]["issue_date"].IsNotNullOrEmpty())
                        {
                            if (dtrev.DefaultView[0]["issue_no"].ToValueAsString() == "1")
                            {
                                sqlRevDateQry = "--";
                            }
                            else
                            {
                                sqlRevDateQry = Convert.ToDateTime(dtrev.DefaultView[0]["issue_date"]).ToString("dd/MM/yyyy");
                            }
                        }
                        else
                        {
                            sqlRevDateQry = "--";
                        }
                        dtrev.DefaultView.RowFilter = string.Empty;
                    }
                    else
                    {
                        sqlRevDateQry = "--";
                    }
                }
                catch (Exception ex)
                {
                    ex.LogException();
                }
                /// End OrgDate -Revised Date
                ///
                RetreieveCustomerName(cpRptModel);
                string suppApprDate  = "____";
                string suppOtherDate = "____";
                if (cpRptModel.SupplierApprDate != null)
                {
                    if (cpRptModel.SupplierApprDate.IsNotNullOrEmpty())
                    {
                        suppApprDate = Convert.ToDateTime(cpRptModel.SupplierApprDate).ToString("dd/MM/yyyy");
                    }
                    else
                    {
                        suppApprDate = "____";
                    }
                }
                if (cpRptModel.OtherApprDate != null)
                {
                    if (cpRptModel.OtherApprDate.IsNotNullOrEmpty())
                    {
                        suppOtherDate = Convert.ToDateTime(cpRptModel.OtherApprDate).ToString("dd/MM/yyyy");
                    }
                    else
                    {
                        suppOtherDate = "____";
                    }
                }
                string partNum = cpRptModel.PartNo;
                try
                {
                    DataTable dt            = new DataTable();
                    decimal?  dwgIssueMaxNo = 0;
                    try
                    {
                        dwgIssueMaxNo = (from o in DB.PRD_DWG_ISSUE
                                         where o.PART_NO == cpRptModel.PartNo && o.DWG_TYPE == 0
                                         select o.ISSUE_NO).Max();
                    }
                    catch (Exception ex)
                    {
                    }

                    if (dwgIssueMaxNo.IsNotNullOrEmpty() && dwgIssueMaxNo != 0)
                    {
                        // Check DWG_TYPE as 0 to get date from product drawing (if it is 1 then it is sequence drawing)
                        PRD_DWG_ISSUE dwgIssue = (from o in DB.PRD_DWG_ISSUE
                                                  where o.PART_NO == cpRptModel.PartNo && o.ISSUE_NO == dwgIssueMaxNo && o.DWG_TYPE == 0
                                                  select o).FirstOrDefault <PRD_DWG_ISSUE>();
                        if (dwgIssue.IsNotNullOrEmpty())
                        {
                            if (dwgIssue.ISSUE_NO.IsNotNullOrEmpty())
                            {
                                partNum = partNum + "/ " + dwgIssue.ISSUE_NO;
                            }
                            if (dwgIssue.ISSUE_DATE.IsNotNullOrEmpty())
                            {
                                partNum = partNum + "/ " + Convert.ToDateTime(dwgIssue.ISSUE_DATE).ToString("dd/MM/yyyy");
                            }
                        }
                        else
                        {
                            partNum = cpRptModel.PartNo + "/ --";
                        }
                    }
                }
                catch (Exception ex)
                {
                    partNum = cpRptModel.PartNo + "/ --";
                    ex.LogException();
                }

                //new by me

                DateTime?pccsIssueMaxDate = (from o in DB.PCCS_ISSUE
                                             where o.PART_NO == cpRptModel.PartNo && o.ROUTE_NO == cpRptModel.RouteNo.ToDecimalValue()
                                             select o.ISSUE_DATE).Max();
                if (pccsIssueMaxDate.IsNotNullOrEmpty())
                {
                    PCCS_ISSUE pccsIssue = (from o in DB.PCCS_ISSUE
                                            where o.PART_NO == cpRptModel.PartNo && o.ROUTE_NO == cpRptModel.RouteNo.ToDecimalValue() && o.ISSUE_DATE == pccsIssueMaxDate.Value.Date
                                            select o).FirstOrDefault <PCCS_ISSUE>();
                    if (pccsIssue.IsNotNullOrEmpty())
                    {
                        if (cpRptModel.ControlPlanType == "PRE LAUNCH")
                        {
                            cpRptModel.ControlPlanNo = "CP-PL/" + cpRptModel.PartNo + "/ " + String.Format("{0,2:00}", pccsIssue.ISSUE_NO.ToIntValue());
                        }
                        else if (cpRptModel.ControlPlanType == "PRODUCTION")
                        {
                            cpRptModel.ControlPlanNo = "CP-PN/" + cpRptModel.PartNo + "/ " + String.Format("{0,2:00}", pccsIssue.ISSUE_NO.ToIntValue());
                        }
                        else if (cpRptModel.ControlPlanType == "PROTOTYPE")
                        {
                            cpRptModel.ControlPlanNo = "CP-PT/" + cpRptModel.PartNo + "/ " + String.Format("{0,2:00}", pccsIssue.ISSUE_NO.ToIntValue());
                        }
                    }
                }

                //end new

                sbsql.Append("select '" + cpRptModel.PartNo + "' as PartNo,  '" + cpRptModel.RouteNo + "' as ProcessNo,  '" + cpRptModel.ControlPlanType + "' as ControlPlanType, '" + cpRptModel.ControlPlanNo + "' as ControlPlanNo, '" + cpRptModel.Fax + "' as Fax, '" + cpRptModel.Phone + "' as Phone,  '" + cpRptModel.Ctm1 + "' as Ctm1,  '" + cpRptModel.Ctm2 + "' as Ctm2,");
                sbsql.Append(" '" + cpRptModel.Ctm3 + "' as Ctm3, '" + cpRptModel.Ctm4 + "' as Ctm4, '" + cpRptModel.Ctm5 + "' as Ctm5, '" + cpRptModel.Ctm6 + "' as Ctm6,  '" + cpRptModel.Ctm7 + "' as Ctm7, '" + partNum + "' as SupplierPartNo, '" + custdwgNo + "' as CustomerPartNo, d.part_desc as PartNameDesc,d.bif_proj as locCode,'" + supplierLoc + "' as SupplierLocation,'" + supplierCode + "' as SupplierCode, '' as PreparedBy, '' as ApprovedBy, '" + sqlOrgDateQry + "' as DateOrg, '" + sqlRevDateQry + "' as DateRev,'" + suppApprDate + "' as SupplierApprDate,'" + suppOtherDate + "' as OtherApprDate, '" + cpRptModel.KeyContactPerson + "' as ContactPerson, ' ___ ' as CustomerEnggApprov,");
                sbsql.Append(" ' ____ ' as CustomerQualityApprov, ' ____ ' as OtherApprovalcustomer,cast(b.seq_no as varchar) as PartProcessNo,b.opn_desc as ProcessNameOperationDesc, (SELECT Stuff((SELECT N'/ ' + cc_code FROM process_cc where part_no=a.part_no and route_no=C.route_no and seq_no= CAST(b.seq_no AS VARCHAR) FOR XML PATH(''),TYPE) .value('text()[1]','nvarchar(max)'),1,2,N'')  ) AS MachineDevice,cast(a.ISR_NO as varchar)  as IsrNo,a.feature as Product,cast(a.PROCESS_FEATURE as varchar)  as Process,ISNULL(a.SPEC_CHAR,'') as SplChar,(ISNULL(a.CTRL_SPEC_MIN,'')+ (CASE WHEN SUBSTRING(a.CTRL_SPEC_MIN, 1, LEN(a.CTRL_SPEC_MIN)) Like '%[0-9]%' AND SUBSTRING(a.CTRL_SPEC_MAX, 1, LEN(a.CTRL_SPEC_MAX)) Like '%[0-9]%' THEN  '/' ELSE  ' ' END) +ISNULL(a.CTRL_SPEC_MAX,'')) as ProcessSpec,");
                sbsql.Append("a.gauges_used as Gauges_Used,cast(a.sample_size as varchar) as SampleSize,a.freq_of_insp as SampleFreq,a.control_method as ControlMethod,a.reaction_plan as ReactionPlan,(select max(issue_date) from pccs_issue p where p.part_no =b.part_no and p.route_no=b.route_no) as issue_date ");
                if (seqNos == "")
                {
                    sbsql.Append("from pccs a,process_sheet b,process_cc c ,prd_mast  d where A.part_no = d.part_no and A.part_no = B.part_no and a.route_no = b.route_no and a.seq_no = b.seq_no and B.part_no = C.part_no and  b.route_no = c.route_no and b.seq_no = c.seq_no and C.part_no = '" + cpRptModel.PartNo + "'  and C.route_no ='" + cpRptModel.RouteNo + "' and cc_sno='1' ORDER BY A.seq_no,A.SNO");
                }
                else
                {
                    sbsql.Append("from pccs a,process_sheet b,process_cc c ,prd_mast  d where A.part_no = d.part_no and A.part_no = B.part_no and a.route_no = b.route_no and a.seq_no = b.seq_no and B.part_no = C.part_no and  b.route_no = c.route_no and b.seq_no = c.seq_no and C.part_no = '" + cpRptModel.PartNo + "'  and C.route_no ='" + cpRptModel.RouteNo + "' and c.seq_no in('" + seqNos + "') and cc_sno='1' ORDER BY A.seq_no,A.SNO");
                }

                dtv = ToDataTable(DB.ExecuteQuery <RptControlPlanModel>(sbsql.ToString()).ToList()).DefaultView;
                return(dtv);
            }
            catch (Exception ex)
            {
                ex.LogException();
                return(dtv);
            }
        }