Пример #1
0
        private void createSearchKeyArray()
        {
            CostReportData crdp = new CostReportData();

            if (textBoxTaskCode.Text == null)
            {
                textBoxTaskCode.Text = "";
            }
            sNoArray          = crdp.SelectCostSlipNo(dateTimePickerEntryDate.Value, textBoxTaskCode.Text, Convert.ToString(comboBoxOffice.SelectedValue));
            labelMessage.Text = (sNoArray[0] == -1) ? "指定された条件では対象となる伝票がありませんでした。"
                                                    : Convert.ToString(sNoArray.Length) + "件のデータがあります。";
            sNoIndex   = 0;
            holdSlipNo = curSlipNo;
        }
Пример #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);
        }