Beispiel #1
0
        /// <summary>
        /// 仕入入力検索情報を取得する
        /// </summary>
        /// <param name="companyCode">自社コード</param>
        /// <param name="slipNumber">伝票番号</param>
        /// <returns></returns>
        public DataSet GetData(string companyCode, string slipNumber, int userId)
        {
            DataSet t03ds = new DataSet();

            M73 taxService = new M73();

            List <T03.T03_SRHD_Extension>  hdList  = getM03_SRHD_Extension(companyCode, slipNumber);
            List <T03.T03_SRDTL_Extension> dtlList = getT03_SRDTL_Extension(slipNumber);
            List <M73_ZEI> taxList = taxService.GetDataList();
            List <DLY03010.S11_KAKUTEI_INFO> fixList = getS11_KAKUTEI_Extension(hdList);

            if (hdList.Count == 0)
            {
                if (string.IsNullOrEmpty(slipNumber))
                {
                    // 伝票番号未入力の場合は新規伝票扱いとする
                    M88 svc  = new M88();
                    int code = int.Parse(companyCode);

                    T03.T03_SRHD_Extension hd = new T03.T03_SRHD_Extension();
                    hd.伝票番号   = svc.getNextNumber(CommonConstants.明細番号ID.ID01_売上_仕入_移動, userId);
                    hd.会社名コード = code.ToString();
                    hd.仕入日    = com.GetDbDateTime();

                    hdList.Add(hd);
                }
                else
                {
                    // 指定伝票が見つからない場合
                    return(null);
                }
            }

            int rowCnt = 1;

            foreach (T03_SRDTL row in dtlList)
            {
                row.行番号 = rowCnt++;
            }

            // Datatable変換
            DataTable dthd  = KESSVCEntry.ConvertListToDataTable(hdList);
            DataTable dtdtl = KESSVCEntry.ConvertListToDataTable(dtlList);
            DataTable dttax = KESSVCEntry.ConvertListToDataTable(taxList);
            DataTable dtfix = KESSVCEntry.ConvertListToDataTable(fixList);

            dthd.TableName = T03_HEADER_TABLE_NAME;
            t03ds.Tables.Add(dthd);

            dtdtl.TableName = T03_DETAIL_TABLE_NAME;
            t03ds.Tables.Add(dtdtl);

            dttax.TableName = M73_TABLE_NAME;
            t03ds.Tables.Add(dttax);

            dtfix.TableName = S11_TABLE_NAME;
            t03ds.Tables.Add(dtfix);

            return(t03ds);
        }
Beispiel #2
0
        /// <summary>
        /// 仕入検索情報を取得する
        /// </summary>
        /// <param name="companyCode">自社コード</param>
        /// <param name="slipNumber">伝票番号</param>
        /// <returns></returns>
        public DataSet ReturnsSearch(string companyCode, string slipNumber, int userId)
        {
            DataSet t03ds = new DataSet();

            List <T03.T03_SRHD_RT_Extension>  hdList  = getM03_SRHD_RT_Extension(companyCode, slipNumber, userId);
            List <T03.T03_SRDTL_RT_Extension> dtlList = getT03_SRDTL_RT_Extension(slipNumber);
            M73            taxService = new M73();
            List <M73_ZEI> taxList    = taxService.GetDataList();

            if (hdList.Count == 0)
            {
                return(t03ds);
            }

            // Datatable変換
            DataTable dthd  = KESSVCEntry.ConvertListToDataTable(hdList);
            DataTable dtdtl = KESSVCEntry.ConvertListToDataTable(dtlList);
            DataTable dttax = KESSVCEntry.ConvertListToDataTable(taxList);

            dthd.TableName = T03_HEADER_TABLE_NAME;
            t03ds.Tables.Add(dthd);

            dtdtl.TableName = T03_DETAIL_TABLE_NAME;
            t03ds.Tables.Add(dtdtl);

            dttax.TableName = M73_TABLE_NAME;
            t03ds.Tables.Add(dttax);

            return(t03ds);
        }