/// <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); }
/// <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); }