Пример #1
0
        private bool involvedDataDelete(DataGridViewRow dgvRow, int slipNo)
        {
            WorkReportData wrp;
            OsWkDetailData owd;
            OsPayOffData   ofd;
            OsPaymentData  omd;

            switch (Convert.ToString(dgvRow.Cells["Subject"].Value))
            {
            case "A":
            case "B":
            case "K":
                wrp = new WorkReportData();
                if (wrp.ExistenceSlipNo(slipNo))
                {
                    if (!wrp.ClearPartWorkReport(slipNo, Convert.ToInt32(dgvRow.Cells["CostReportID"].Value)))
                    {
                        deleteErrorMessage("作業内訳データ");
                        return(false);
                    }
                }
                else
                {
                    owd = new OsWkDetailData();
                    if (owd.ExistenceSlipNo(slipNo, Convert.ToInt32(dgvRow.Cells["CostReportID"].Value)))
                    {
                        if (!owd.DeleteOsWkDetail("@slip", slipNo))
                        {
                            deleteErrorMessage("外注作業内訳データ");
                            return(false);
                        }
                    }
                }
                break;

            case "F":
                ofd = new OsPayOffData();
                if (ofd.ExistenceSlipNo(slipNo))
                {
                    if (!ofd.DeletePayOff("@slip", slipNo))
                    {
                        deleteErrorMessage("外注精算データ");
                        return(false);
                    }
                }
                else
                {
                    omd = new OsPaymentData();
                    if (omd.ExistenceSlipNo(slipNo))
                    {
                        if (!omd.DeletePayment("@slip", slipNo))
                        {
                            deleteErrorMessage("外注出来高データ");
                            return(false);
                        }
                    }
                }
                break;

            default:
                owd = new OsWkDetailData();
                if (owd.ExistenceSlipNo(slipNo, Convert.ToInt32(dgvRow.Cells["CostReportID"].Value)))
                {
                    if (!owd.DeleteOsWkDetail("@slip", slipNo))
                    {
                        deleteErrorMessage("外注作業内訳データ");
                        return(false);
                    }
                }
                break;
            }
            return(true);
        }
Пример #2
0
        private bool storedData()
        {
            int lineCount = 0;

            for (int i = 0; i < wdtl.Length; i++)
            {
                if (wdtl[i].ItemCode == "" || wdtl[i].ItemCode == null)
                {
                    continue;
                }
                lineCount++;
            }

            OsWkDetailData[] nwdtl = new OsWkDetailData[lineCount];
            for (int idx = 0, i = 0; i < wdtl.Length; i++)
            {
                if (wdtl[i].ItemCode == "" || wdtl[i].ItemCode == null)
                {
                    continue;
                }

                nwdtl[idx] = ( OsWkDetailData )wdtl[i].Clone();

                nwdtl[idx].PartnerCode = wrep.PartnerCode;
                nwdtl[idx].TaskCode    = wrep.TaskCode;
                nwdtl[idx].ReportDate  = wrep.ReportDate;

                nwdtl[idx].OfficeCode  = wrep.OfficeCode;
                nwdtl[idx].Department  = wrep.Department;
                nwdtl[idx].MmeberCode  = wrep.MemberCode;
                nwdtl[idx].LeaderMCode = wrep.LeaderMCode;
                nwdtl[idx].SalesMCode  = wrep.SalesMCode;
                nwdtl[idx].CustoCode   = wrep.CustoCode;
                nwdtl[idx].CoTaskCode  = wrep.CoTaskCode;
                idx++;
            }

            // 既に、同じReportDate,TaskCode,OfficeCode,Department,SubCoCode(PartnerCode)の
            // CostReprotがあれば伝票番号を得たのちに削除する
            // 伝票番号をもとに削除したCostReportに関連する、外注作業明細を削除する
            int slipNo = crd.SelectCostSlipNo(wrep.ReportDate, wrep.TaskCode, wrep.PartnerCode, wrep.OfficeCode, wrep.Department);

            if (slipNo > 0)
            {
                if (crd.DeleteCostReport("@slip", slipNo))
                {
                    OsWkDetailData osd          = new OsWkDetailData();
                    int            osWkReportID = osd.SelectOsWkReportID(slipNo);
                    if (osWkReportID > 0)
                    {
                        OsWkReportData osr = new OsWkReportData();
                        if (!osr.DeleteOsWkReport("OsWkReportID = " + osWkReportID))
                        {
                            return(false);
                        }
                    }
                    if (!osd.DeleteOsWkDetail("@slip", slipNo))
                    {
                        return(false);
                    }
                }
            }

            if ((nwdtl = crd.InsertCostReport(nwdtl)) == null)
            {
                return(false);
            }

            //wrep.TaskCode = (wrep.RTaskCode == "")? wrep.TaskCode : wrep.RTaskCode;
            if (!wrep.StoreOsWkReportAndDetail(nwdtl))
            {
                return(false);
            }

            return(true);
        }