private void StartdateEdit_EditValueChanged(object sender, EventArgs e) { string ttime = string.Empty; if (XtraReportSetting.Day.ToString().Length == 2) { ttime = Convert.ToDateTime(StartdateEdit.EditValue).ToString("yyyy/MM/") + $"{XtraReportSetting.Day} 00:00:00"; } else { ttime = Convert.ToDateTime(StartdateEdit.EditValue).ToString("yyyy/MM/") + $"0{XtraReportSetting.Day} 00:00:00"; } DateTime dateTime = Convert.ToDateTime(ttime); var TaiwanDate = new System.Globalization.TaiwanCalendar();//民國轉換 if (XtraReportSetting.Day.ToString().Length == 2) { TimelabelControl.Text = $"{TaiwanDate.GetYear(dateTime.AddMonths(-1))}年{dateTime.AddMonths(-1).ToString("MM")}月{ XtraReportSetting.Day}日 "; } else { TimelabelControl.Text = $"{TaiwanDate.GetYear(dateTime.AddMonths(-1))}年{dateTime.AddMonths(-1).ToString("MM")}月0{ XtraReportSetting.Day}日 "; } TimelabelControl.Text += $"- {TaiwanDate.GetYear(dateTime.AddDays(-1))}年{dateTime.AddDays(-1).ToString("MM月dd日")}"; }
protected override void OnCreate(Bundle bundle) { // If these are not used the ToString for DateTime throws an exception in some cultures // For more information: https://forums.xamarin.com/discussion/42899/datetime-tostring-throws-argumentoutofrangeexception-in-thai-locale var c1 = new System.Globalization.ChineseLunisolarCalendar(); var c2 = new System.Globalization.GregorianCalendar(); var c3 = new System.Globalization.HebrewCalendar(); var c4 = new System.Globalization.HijriCalendar(); var c5 = new System.Globalization.JapaneseCalendar(); var c6 = new System.Globalization.JapaneseLunisolarCalendar(); var c7 = new System.Globalization.JulianCalendar(); var c8 = new System.Globalization.KoreanCalendar(); var c9 = new System.Globalization.KoreanLunisolarCalendar(); var c10 = new System.Globalization.PersianCalendar(); var c11 = new System.Globalization.TaiwanCalendar(); var c12 = new System.Globalization.TaiwanLunisolarCalendar(); var c13 = new System.Globalization.ThaiBuddhistCalendar(); var c14 = new System.Globalization.UmAlQuraCalendar(); StrictMode.VmPolicy.Builder builder = new StrictMode.VmPolicy.Builder(); StrictMode.SetVmPolicy(builder.Build()); base.OnCreate(bundle); CrossCurrentActivity.Current.Init(this, bundle); PermissionsHelper.Activity = this; this.SetTheme(Resource.Style.Theme_Design_Light); //CachedImageRenderer.Init(false); FFImageLoading.Forms.Platform.CachedImageRenderer.Init(false); global::Xamarin.Forms.Forms.Init(this, bundle); LoadApplication(new App()); }
public static void Main(string[] args) { string baseFolderPath = ConfigurationManager.AppSettings["BaseFolderPath"]; var now = DateTime.Now; var taiwanCalander = new System.Globalization.TaiwanCalendar(); string taiwanTime = string.Format("{0}{1}{2}", taiwanCalander.GetYear(now).ToString(), now.Month.ToString().PadLeft(2, '0'), now.Day.ToString()); string taiwanTimePath = Path.Combine(baseFolderPath, taiwanTime); if (Directory.Exists(taiwanTimePath) == true) { Console.WriteLine($"taiwanTimePath already exist [{taiwanTimePath}]"); Console.WriteLine($"按任意鍵結束!"); return; } Directory.CreateDirectory(taiwanTimePath); for (int i = 1; i <= 20; i++) { string taiwanTimeSubPath = Path.Combine(baseFolderPath, taiwanTimePath, taiwanTime + i.ToString().PadLeft(2, '0')); Directory.CreateDirectory(taiwanTimeSubPath); } #if DEBUG Console.WriteLine($"完成!!按任意鍵結束!"); Console.Read(); #endif }
// // This method is invoked when the application has loaded and is ready to run. In this // method you should instantiate the window, load the UI into it and then make the window // visible. // // You have 17 seconds to return from this method, or iOS will terminate your application. // public override bool FinishedLaunching(UIApplication app, NSDictionary options) { // If these are not used the ToString for DateTime throws an exception in some cultures // For more information: https://forums.xamarin.com/discussion/42899/datetime-tostring-throws-argumentoutofrangeexception-in-thai-locale var c1 = new System.Globalization.ChineseLunisolarCalendar(); var c2 = new System.Globalization.GregorianCalendar(); var c3 = new System.Globalization.HebrewCalendar(); var c4 = new System.Globalization.HijriCalendar(); var c5 = new System.Globalization.JapaneseCalendar(); var c6 = new System.Globalization.JapaneseLunisolarCalendar(); var c7 = new System.Globalization.JulianCalendar(); var c8 = new System.Globalization.KoreanCalendar(); var c9 = new System.Globalization.KoreanLunisolarCalendar(); var c10 = new System.Globalization.PersianCalendar(); var c11 = new System.Globalization.TaiwanCalendar(); var c12 = new System.Globalization.TaiwanLunisolarCalendar(); var c13 = new System.Globalization.ThaiBuddhistCalendar(); var c14 = new System.Globalization.UmAlQuraCalendar(); AnalyticsHelper.Initialize(Xamarin.Forms.Device.iOS); global::Xamarin.Forms.Forms.Init(); CachedImageRenderer.Init(); LoadApplication(new App()); UITextField.Appearance.TintColor = Xamarin.Forms.Color.FromHex("#2548D8").ToUIColor(); #if __TESTS__ Xamarin.Calabash.Start(); #endif return(base.FinishedLaunching(app, options)); }
/// <summary> /// 西元轉民國年 /// </summary> /// <param name="dateTime"></param> /// <returns></returns> public static string ParseToTaiwanDate(DateTime datetime, TaiwanFormat twFormat) { System.Globalization.TaiwanCalendar taiwanCa = new System.Globalization.TaiwanCalendar(); string result = string.Empty; string year = taiwanCa.GetYear(datetime).ToString(); string month = datetime.Month.ToString("00"); string day = datetime.Day.ToString("00"); switch (twFormat) { case TaiwanFormat.YearMonthDay: result = $"{year}/{month}/{day}"; break; case TaiwanFormat.YearMonth: result = $"{year}/{month}"; break; case TaiwanFormat.OnlyYear: result = $"{year}"; break; } return(result); }
public static string ParseToTaiwanYearMonth(DateTime datetime) { System.Globalization.TaiwanCalendar tc = new System.Globalization.TaiwanCalendar(); return(string.Format("{0}/{1}", tc.GetYear(datetime), datetime.Month.ToString("00"))); }
// GET: OPCase public ActionResult Index(FormCollection form) { Int32 begin_date = 0; Int32 end_date = 0; DateTime begin_date_search = DateTime.Today; DateTime end_date_search = DateTime.Today; if (form["begin_date"] == null) { DateTime Date_Today = DateTime.Today; DateTime Start_Date = Date_Today.AddDays(1 - Convert.ToInt32(Date_Today.DayOfWeek.ToString("d")) - 7); DateTime End_Date = Start_Date.AddDays(6); var taiwanCalendar = new System.Globalization.TaiwanCalendar(); var Start_Date_Taiwan = string.Format("{0:D3}{1:D2}{2:D2}", taiwanCalendar.GetYear(Start_Date), Start_Date.Month, Start_Date.Day); var End_Date_Taiwan = string.Format("{0:D3}{1:D2}{2:D2}", taiwanCalendar.GetYear(End_Date), End_Date.Month, End_Date.Day); begin_date = Convert.ToInt32(Start_Date_Taiwan); end_date = Convert.ToInt32(End_Date_Taiwan); begin_date_search = Start_Date; end_date_search = End_Date; } else { DateTime Start_Date = Convert.ToDateTime(form["begin_date"]); DateTime End_Date = Convert.ToDateTime(form["end_date"]); var taiwanCalendar = new System.Globalization.TaiwanCalendar(); var Start_Date_Taiwan = string.Format("{0:D3}{1:D2}{2:D2}", taiwanCalendar.GetYear(Start_Date), Start_Date.Month, Start_Date.Day); var End_Date_Taiwan = string.Format("{0:D3}{1:D2}{2:D2}", taiwanCalendar.GetYear(End_Date), End_Date.Month, End_Date.Day); begin_date = Convert.ToInt32(Start_Date_Taiwan); end_date = Convert.ToInt32(End_Date_Taiwan); begin_date_search = Start_Date; end_date_search = End_Date; } ViewBag.begin_date = begin_date_search; ViewBag.end_date = end_date_search; var result = db.OPRTODRFs .AsQueryable() .Where(c => c.ODR_DEPT.Trim() == "17") .AsEnumerable() .Where(c => Convert.ToInt32(c.ODR_TXDT) >= begin_date && Convert.ToInt32(c.ODR_TXDT) <= end_date) .OrderBy(c => c.ODR_PSRC) .ThenByDescending(c => c.ODR_TXDT) .ToList(); foreach (var resultItem in result) { try { resultItem.ODR_M_DR = GSdb.members.Where(c => c.brief_id == resultItem.ODR_M_DR).First().brief; } catch (Exception ex) { resultItem.ODR_M_DR = ""; } } return(View(result)); }
public string GetGUILegal(DateTime dateTime) { var tWCalendar = new System.Globalization.TaiwanCalendar(); int year = tWCalendar.GetYear(dateTime); string month = DateTime.Parse(dateTime.ToString()).ToString("MM"); return(string.Format("{0}{1}", year, month)); }
public static string GetTWNDate(DateTime dateTime) { var tWCalendar = new System.Globalization.TaiwanCalendar(); int year = tWCalendar.GetYear(dateTime); string month = DateTime.Parse(dateTime.ToString()).ToString("MM"); string day = DateTime.Parse(dateTime.ToString()).ToString("dd"); return(string.Format("{0}{1}{2}", year, month, day)); }
public void create_XtraReport(MysqlMethod mysql, string TTime, ReportTitleSetting reportTitle) { MysqlMethod = mysql; ContractNoLabel.Text = reportTitle.ContractNo; //契約編號 ElectNoLabel.Text = reportTitle.ElectNo; //電號 var TaiwanDate = new System.Globalization.TaiwanCalendar(); //民國轉換 XtraReportSetting = InitialMethod.InitialXtraReportLoad(); DateTime dateTime = Convert.ToDateTime(TTime); DateTime nowtime = DateTime.Now; ReportConfigs = MysqlMethod.Search_ReportConfig();//報表資訊 GatewayConfigs = MysqlMethod.Search_GatewayConfig(); foreach (var item in GatewayConfigs) { var configs = MysqlMethod.Search_ElectricConfig(item.GatewayIndex); ElectricConfigs.AddRange(configs); } string startime = startime = dateTime.AddMonths(-1).ToString("yyyyMMdd"); string endtime = dateTime.AddDays(-1).ToString("yyyyMMdd"); foreach (var item in ElectricConfigs) { var data = MysqlMethod.Search_ElectricSumTotal(startime, endtime, item.GatewayIndex, item.DeviceIndex); TotalkWh.Add(data); } var SumTotalkWh = TotalkWh[0] + TotalkWh[1]; StartDatexrLabel1.Text = $"{TaiwanDate.GetYear(dateTime.AddMonths(-1))}"; StartDatexrLabel2.Text = $"{dateTime.AddMonths(-1).ToString("MM")}"; if (XtraReportSetting.Day.ToString().Length == 2) { StartDatexrLabel3.Text = $"{XtraReportSetting.Day}"; //StartDatexrLabel1.Text = $"{TaiwanDate.GetYear(dateTime.AddMonths(-1))}年{dateTime.AddMonths(-1).ToString("MM")}月{ XtraReportSetting.Day}日"; } else { StartDatexrLabel3.Text = $"0{XtraReportSetting.Day}"; //StartDatexrLabel1.Text = $"{TaiwanDate.GetYear(dateTime.AddMonths(-1))}年{dateTime.AddMonths(-1).ToString("MM")}月0{ XtraReportSetting.Day}日"; } EndDatexrLabel1.Text = $"{TaiwanDate.GetYear(dateTime.AddDays(-1))}"; EndDatexrLabel2.Text = $"{dateTime.AddDays(-1).ToString("MM")}"; EndDatexrLabel3.Text = $"{dateTime.AddDays(-1).ToString("dd")}"; //EndDatexrLabel1.Text = $"{TaiwanDate.GetYear(dateTime.AddDays(-1))}年{dateTime.AddDays(-1).ToString("MM月dd日")}"; CurrentMeterReadingDayxrLabel1.Text = $"{TaiwanDate.GetYear(nowtime)}"; CurrentMeterReadingDayxrLabel2.Text = $"{nowtime.ToString("MM")}"; CurrentMeterReadingDayxrLabel3.Text = $"{nowtime.ToString("dd")}"; //CurrentMeterReadingDayxrLabel1.Text = $"{TaiwanDate.GetYear(nowtime)}年{nowtime.ToString("MM")}月{nowtime.ToString("dd")}日";//本期抄表日 DateOfReportingxrLabel1.Text = $"{TaiwanDate.GetYear(nowtime)}"; DateOfReportingxrLabel2.Text = $"{nowtime.ToString("MM")}"; DateOfReportingxrLabel3.Text = $"{nowtime.ToString("dd")}"; //DateOfReportingxrLabel1.Text = $"{TaiwanDate.GetYear(nowtime)}年{nowtime.ToString("MM")}月{nowtime.ToString("dd")}日";//填報日期 if (ReportConfigs.Count > 0) { #region 第一顆電表 xrTableCell7.Text = ReportConfigs[0].ElectricNo; xrTableCell12.Text = ReportConfigs[0].ElectricitySalePeriod.ToString(); //售電期限 xrTableCell17.Text = $"{TaiwanDate.GetYear(ReportConfigs[0].StartingDate)}.{ReportConfigs[0].StartingDate.Month}.{ReportConfigs[0].StartingDate.Day}"; //計價起始日 xrTableCell22.Text = $"{TaiwanDate.GetYear(ReportConfigs[0].OfficialPricingStartDate)}.{ReportConfigs[0].OfficialPricingStartDate.Month}.{ReportConfigs[0].OfficialPricingStartDate.Day}"; //正是購售電能日 xrTableCell52.Text = $"{TaiwanDate.GetYear(ReportConfigs[0].PricStartTime)}.{ReportConfigs[0].PricStartTime.Month}.{ReportConfigs[0].PricStartTime.Day}-{TaiwanDate.GetYear(ReportConfigs[0].PricEndTime)}.{ReportConfigs[0].PricEndTime.Month}.{ReportConfigs[0].PricEndTime.Day}"; //計價起迄期間 xrTableCell27.Text = ReportConfigs[0].ElectricityPurchaseRate.ToString("0.####"); //購電費率 xrTableCell32.Text = ReportConfigs[0].DeviceCapacity.ToString("0.###"); //裝置容量 xrTableCell37.Text = ReportConfigs[0].PurchaseAndSaleCapacity.ToString("0.###"); //購售電容量 xrTableCell42.Text = TotalkWh[0].ToString("0.##"); //生產電度量 if (TotalkWh[0] != 0) { xrTableCell47.Text = $"{Convert.ToInt32((TotalkWh[0] / SumTotalkWh) * 100)}%"; } #endregion #region 第二顆電表 xrTableCell8.Text = ReportConfigs[1].ElectricNo; xrTableCell13.Text = ReportConfigs[1].ElectricitySalePeriod.ToString(); //售電期限 xrTableCell18.Text = $"{TaiwanDate.GetYear(ReportConfigs[1].StartingDate)}.{ReportConfigs[1].StartingDate.Month}.{ReportConfigs[1].StartingDate.Day}"; //計價起始日 xrTableCell23.Text = $"{TaiwanDate.GetYear(ReportConfigs[1].OfficialPricingStartDate)}.{ReportConfigs[1].OfficialPricingStartDate.Month}.{ReportConfigs[1].OfficialPricingStartDate.Day}"; //正是購售電能日 xrTableCell53.Text = $"{TaiwanDate.GetYear(ReportConfigs[1].PricStartTime)}.{ReportConfigs[1].PricStartTime.Month}.{ReportConfigs[1].PricStartTime.Day}-{TaiwanDate.GetYear(ReportConfigs[1].PricEndTime)}.{ReportConfigs[1].PricEndTime.Month}.{ReportConfigs[1].PricEndTime.Day}"; //計價起迄期間 xrTableCell28.Text = ReportConfigs[1].ElectricityPurchaseRate.ToString("#.####"); //購電費率 xrTableCell33.Text = ReportConfigs[1].DeviceCapacity.ToString("#.###"); //裝置容量 xrTableCell38.Text = ReportConfigs[1].PurchaseAndSaleCapacity.ToString("#.###"); //購售電容量 xrTableCell43.Text = TotalkWh[1].ToString("#.##"); //生產電度量 if (TotalkWh[1] != 0) { xrTableCell48.Text = $"{Convert.ToInt32((TotalkWh[1] / SumTotalkWh) * 100)}%"; } #endregion #region 合計 xrTableCell35.Text = $"{(ReportConfigs[0].DeviceCapacity + ReportConfigs[1].DeviceCapacity).ToString("#.###")}"; //裝置容量 xrTableCell40.Text = $"{ (ReportConfigs[0].PurchaseAndSaleCapacity + ReportConfigs[1].PurchaseAndSaleCapacity).ToString("#.###")}"; //購售電容量 xrTableCell45.Text = $"{SumTotalkWh.ToString("#.##")}"; #endregion } }
/// <summary> /// 頁籤=計算機發票 /// </summary> /// <param name="ParameterList"></param> /// <returns></returns> public DataTable CAA24_5(ArrayList ParameterList) { #region 宣告變數 BCO.CAACommon CAAComm = new BCO.CAACommon(); ArrayList arl_ReportService = new ArrayList(); #endregion #region 傳入參數 #region 規則 /* * 當頁籤=發票對帳單時 * 抓取[單店開立]的資料 * 當頁籤=單店未開發票對帳單 * 抓取[單店開立]&[總部彙開]的資料 * 當頁籤=計算機發票 * 抓取[單店開立]&[總部彙開]的資料 */ #endregion arl_ReportService.Clear(); arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[結帳年月](0) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//[店群]起(1) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[店群]迄(2) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[路線]起(3) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "string", false));//[路線]迄(4) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "string", false));//[結帳統編](5) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[店號](6) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[商品群分類](7) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "int", false));//[路線](8) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//[發票對帳單送達](9) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "int", false));//[列印註記](0=未列印,1=已列印)(10) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[11].ToString(), "int", false));//[判斷抓取資料範圍](0=單店開立,1=總部彙開+單店開立)(11) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[12].ToString(), "string", false));//登入人員(12) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[13].ToString(), "string", false));//那一個頁籤(13) arl_ReportService.Add(CAAComm.GetValueSetParameter("0", "string", false));//發票未作廢(14) #endregion #region 連結資料庫 DataTable dt_Return = new DataTable(); BCO.CheckSheetPrint bco = new BCO.CheckSheetPrint(ConntionDB); dt_Return = bco.GetInvData(null, arl_ReportService); #endregion #region 檢查回傳資料,如果有資料,則依照[帳務人員][店號][稅別][發票號碼]排序資料 #region 規則 /* 20100318秀玲與USER確認更改需求 * 頁籤=計算機發票,排序依照[帳務人員][店號][稅別][發票號碼]排序資料 */ #endregion if (dt_Return.Rows.Count == 0) { throw new Exception("查無資料"); } else { dt_Return = new DataView(dt_Return, string.Empty, "AC_UID_RANK,STORE_ID_RANK,TAX_TYPE,INV_NO", DataViewRowState.CurrentRows).ToTable(); } #endregion #region 整理列印資料 #region 設定 dt_Temp_Result 的框架 #region 設定變數 int i_Main_Row_Right = 25;//設定右邊主檔資料區有幾個欄位(一個發票的欄位) DataTable dt_Temp_Result = new DataTable(); #endregion #region 右邊主檔資料區(印發票的地方) for (int c = 0; c < i_Main_Row_Right; c++) { dt_Temp_Result.Columns.Add("MAIN_RIGHT_" + c.ToString(), typeof(string)); } #endregion #endregion foreach (DataRow dr_Row in dt_Return.Rows) { #region 設定變數 DateTime d_INV_DATE = DateTime.Parse(dr_Row["INV_DATE"].ToString()); System.Globalization.TaiwanCalendar g_TaiwanCalendar = new System.Globalization.TaiwanCalendar(); string s_Year = g_TaiwanCalendar.GetYear(d_INV_DATE).ToString(); //發票日期(年) string s_Month = g_TaiwanCalendar.GetMonth(d_INV_DATE).ToString(); //發票日期(月) string s_Date = g_TaiwanCalendar.GetDayOfMonth(d_INV_DATE).ToString(); //發票日期(日) string s_INV_AMT = Conversion_Number(dr_Row["INV_AMT"].ToString(), 9); string s_VOUCH_RFNO = string.Empty;//統一編號 DataRow dr_Temp_Result = dt_Temp_Result.NewRow(); #endregion #region 將資料寫入TempTable for (int i = 0; i < i_Main_Row_Right; i++) { #region 設定統一編號 s_VOUCH_RFNO = Get_VOUCH_RFNO(dr_Row["VOUCH_RFNO"].ToString()); #endregion decimal decINV_UAMT = decimal.Parse(dr_Row["INV_UAMT"].ToString()); decimal decINV_TAX = decimal.Parse(dr_Row["INV_TAX"].ToString()); if (dr_Row["INV_FORM"].ToString().Trim() == "32") { decINV_UAMT = decINV_UAMT + decINV_TAX; decINV_TAX = 0; } dr_Temp_Result["MAIN_RIGHT_0"] = s_Year;//年 dr_Temp_Result["MAIN_RIGHT_1"] = s_Month;//月 dr_Temp_Result["MAIN_RIGHT_2"] = s_Date;//日 dr_Temp_Result["MAIN_RIGHT_3"] = dr_Row["INV_CHKNO"].ToString();//檢查號碼 dr_Temp_Result["MAIN_RIGHT_4"] = dr_Row["INV_NO"].ToString();//發票號碼 dr_Temp_Result["MAIN_RIGHT_5"] = dr_Row["TITLE"].ToString();//買受人 dr_Temp_Result["MAIN_RIGHT_6"] = s_VOUCH_RFNO;//統一編號 dr_Temp_Result["MAIN_RIGHT_7"] = dr_Row["ITEM_NAME"].ToString();//品名 dr_Temp_Result["MAIN_RIGHT_8"] = string.Format("{0:N}", decINV_UAMT).Replace(".00", string.Empty);//金額(20100329秀玲修改需求,改抓未稅金額) dr_Temp_Result["MAIN_RIGHT_9"] = (dr_Row["TAX_TYPE"].ToString() == "0") ? "V" : string.Empty;//應稅 dr_Temp_Result["MAIN_RIGHT_10"] = (dr_Row["TAX_TYPE"].ToString() == "2") ? "V" : string.Empty;//零稅 dr_Temp_Result["MAIN_RIGHT_11"] = (dr_Row["TAX_TYPE"].ToString() == "1") ? "V" : string.Empty;//免稅 dr_Temp_Result["MAIN_RIGHT_12"] = string.Format("{0:N}", decINV_UAMT).Replace(".00", string.Empty);//銷售額合計 dr_Temp_Result["MAIN_RIGHT_13"] = string.Format("{0:N}", decINV_TAX).Replace(".00", string.Empty);//營業稅 dr_Temp_Result["MAIN_RIGHT_14"] = string.Format("{0:N}", int.Parse(dr_Row["INV_AMT"].ToString())).Replace(".00", string.Empty);//總計 dr_Temp_Result["MAIN_RIGHT_24"] = s_INV_AMT.Substring(0, 1);//億 dr_Temp_Result["MAIN_RIGHT_15"] = s_INV_AMT.Substring(1, 1);//千萬 dr_Temp_Result["MAIN_RIGHT_16"] = s_INV_AMT.Substring(2, 1);//百萬 dr_Temp_Result["MAIN_RIGHT_17"] = s_INV_AMT.Substring(3, 1);//十萬 dr_Temp_Result["MAIN_RIGHT_18"] = s_INV_AMT.Substring(4, 1);//萬 dr_Temp_Result["MAIN_RIGHT_19"] = s_INV_AMT.Substring(5, 1);//千 dr_Temp_Result["MAIN_RIGHT_20"] = s_INV_AMT.Substring(6, 1);//百 dr_Temp_Result["MAIN_RIGHT_21"] = s_INV_AMT.Substring(7, 1);//拾 dr_Temp_Result["MAIN_RIGHT_22"] = s_INV_AMT.Substring(8, 1);//元 //20100503新增該欄位(小張計算機發票備註欄位下面加上店號) //發票對帳單的備註欄位下方的店號是抓VDS_CAM_ACCT_CHECK_OUT的店號,但計算機發票是抓VDS_CAA_INV_MAIN的店號 //但發票對帳單只列印單店分別開的發票,這一些發票在發票主檔中的欄位[店號]也是放單店 //而總部彙開的發票在發票主檔的欄位[店號]是放總部店號 //所以小張計算機發票的欄位[店號]直接抓VDS_CAA_INV_MAIN的店號即可 dr_Temp_Result["MAIN_RIGHT_23"] = dr_Row["STORE_ID_RANK"].ToString();//店號 } dt_Temp_Result.Rows.Add(dr_Temp_Result); #endregion } #endregion #region 檢查列印資料 if (dt_Temp_Result.Rows.Count == 0) { throw new Exception("查無資料!!"); } #endregion #region 更新發票主檔的列印註記 #region 規則 /* * 當頁籤 = 發票對帳單 & 計算機發票 * 查詢完成後必須更新發票主檔的列印註記 * 當頁籤 = 單店未開發票對帳單 * 查詢完成後不必更新發票主檔的列印註記 */ #endregion DateTime d_Now = DateTime.Now; string s_LogUser = arl_ReportService[12].ToString(); bco.CAA241_UPDATE_INV_MAIN(null, dt_Return, d_Now, s_LogUser); #endregion return dt_Temp_Result; }
/// <summary> /// 設定折讓對帳單列印資料 /// </summary> /// <param name="dt_Temp_Result">折讓對帳單列印資料 Temp Table</param> /// <param name="d_Now">列印日期時間</param> /// <param name="dr_Temp_Main1">折讓對帳單左邊主檔資料區</param> /// <param name="dr_Temp_Main2">折讓對帳單右邊發票資料區</param> /// <param name="dr_Temp_Detl_Purchase">折讓對帳單進貨明細資料區</param> /// <param name="dr_Temp_Detl_Return">折讓對帳單退貨明細資料區</param> /// <param name="dr_Temp_Store">折讓對帳單店號相關資料</param> /// <param name="s_TAB_Index">2=折讓對帳單,4=單店未開發票對帳單</param> /// <returns></returns> private DataTable Collate_Information_Disc(DataTable dt_Temp_Result, DateTime d_Now, DataRow[] dr_Temp_Main1, DataRow[] dr_Temp_Main2, DataRow[] dr_Temp_Detl_Purchase, DataRow[] dr_Temp_Detl_Return, DataRow[] dr_Temp_Store, string s_TAB_Index, string strPROMTE) { #region 錯誤資料 //沒有明細資料 OR 沒有店號的資料皆屬於錯誤資料 if ((dr_Temp_Detl_Purchase == null && dr_Temp_Detl_Return == null) || (dr_Temp_Store == null)) { DataRow dr_Temp_Result = dt_Temp_Result.NewRow(); string s_Err_Disc_No = string.Empty; foreach (DataRow dr_Main1 in dr_Temp_Main1) { if (s_Err_Disc_No == string.Empty) { s_Err_Disc_No += dr_Main1["DISC_NO"].ToString(); } else { s_Err_Disc_No += "," + dr_Main1["DISC_NO"].ToString(); } } dr_Temp_Result["MAIN_LEFT_14"] = "資料異常,無法正確列印對帳單,折讓單號碼:" + s_Err_Disc_No; dt_Temp_Result.Rows.Add(dr_Temp_Result); } #endregion #region 正確資料 else { #region 設定變數 #region 列印日期 and 時間 string s_Print_Date = d_Now.ToString("yyyy/MM/dd");//列印日期 string s_Print_Time = d_Now.ToString("HH:mm:ss");//列印時間 #endregion #region 設定行數 int i_Detl_Count = 50;//設定Detl明細資料總共有幾行(包含[頁首][內容]頁尾[小計][單店小計][總計]) int i_Detl_Title = 4;//設定Detl頁首有幾行 int i_Detl_Total = 10;//設定Detl頁尾[小計][單店小計]&[總計]共有幾行 int i_Detl_Content = i_Detl_Count - i_Detl_Title;//設定Detl內容行數 bool b_IsFinally = false;//設定明細資料是否為最後一筆 int i_Actual_Total = 0;//設定Detl頁尾單店小計&總計執行到第幾筆 #endregion #region 設定折讓單號碼 string s_DISC_NO_Able = string.Empty;//應稅發票號碼 string s_DISC_NO_Free = string.Empty;//免稅發票號碼 string s_DISC_NO_Zero = string.Empty;//零稅率發票號碼 #endregion #region 計算[小計]金額 decimal dec_Subtotal_TOT_AMT_Purchase = 0;//[小計]-進貨未稅金額 decimal dec_Subtotal_TOT_AMT_AND_TAX_Purchase = 0;//[小計]-進貨含稅金額 decimal dec_Subtotal_TOT_AMT_Return = 0;//[小計]-退貨未稅金額 decimal dec_Subtotal_TOT_AMT_AND_TAX_Return = 0;//[小計]-退貨含稅金額 #endregion #region 計算[單店小計]金額 decimal dec_Single_Amount_Able = 0;//單店小計-[應稅]的[合計] decimal dec_Single_Amount_Free = 0;//單店小計-[免稅]的[合計] decimal dec_Single_Amount_Zero = 0;//單店小計-[零稅]的[合計] decimal dec_Single_Tax_Able = 0;//單店小計-[應稅]的[稅額] decimal dec_Single_Tax_Zero = 0;//單店小計-[零稅]的[稅額] #endregion #region 計算[總計]金額 int i_Total_Amount_Able = 0;//總計-[應稅]的[未稅金額] int i_Total_Amount_Free = 0;//總計-[免稅]的[未稅金額] int i_Total_Amount_Zero = 0;//總計-[零稅]的[未稅金額] int i_Total_Tax_Able = 0;//總計-[應稅]的[稅額] int i_Total_Tax_Zero = 0;//總計-[零稅]的[稅額] int i_Total_Disc_Able = 0;//總計-[應稅]的[折讓總額] int i_Total_Disc_Free = 0;//總計-[免稅]的[折讓總額] int i_Total_Disc_Zero = 0;//總計-[零稅]的[折讓總額] #endregion #endregion #region 計算需要幾頁來印這一筆資料 #region 設定變數 int i_dt_Temp_Result_Count_Inv = 0;//計算右邊主檔發票資料需要幾頁來列印 int i_dt_Temp_Result_Count_Purchase = 0;//計算進貨的DETL資料需要幾頁來列印 int i_dt_Temp_Result_Count_Return = 0;//計算退貨的DETL資料需要幾頁來列印 int i_dt_Temp_Result_Count = 0;//最後需要幾頁來列印 ArrayList arl_Inv_Statistics = new ArrayList(); ArrayList arl_Disc_Statistics = new ArrayList(); #endregion #region 計算右邊主檔發票資料需要幾頁來列印 if (s_TAB_Index == "2")//折讓對帳單 { DataTable dt_Temp_Right = new DataTable(); for (int i_Main1 = 0; i_Main1 < dr_Temp_Main1.Length; i_Main1++) { #region 設定變數 int i_Main2_Statistics = 0;//計算該張折讓單對應到的發票張數 #endregion #region 計算每一張折讓單需要幾頁來列印 //算出該張折讓單對應到幾筆發票資料 for (int i_Main2 = 0; i_Main2 < dr_Temp_Main2.Length; i_Main2++) { if (dr_Temp_Main1[i_Main1]["DISC_NO"].ToString() == dr_Temp_Main2[i_Main2]["DISC_NO"].ToString()) { i_Main2_Statistics += 1; //將資料存入ArrayList中 //文字陣列有2個參數 //(1)折讓單號在dr_Temp_Main1陣列中是第幾筆資料 //(2)發票號碼在dr_Temp_Main2陣列中是第幾筆資料 arl_Inv_Statistics.Add(new string[] { i_Main1.ToString(), i_Main2.ToString() }); } } //計算該張折讓單需要幾頁列印 if (i_Main2_Statistics % 5 > 0) { i_Main2_Statistics = (i_Main2_Statistics / 5) + 1; } else { i_Main2_Statistics = i_Main2_Statistics / 5; } //將資料存入ArrayList中 //文字陣列有2個參數 //(1)折讓單號 //(2)該張折讓單需要幾頁來顯示 //(3)該張折讓單已經顯示幾頁 arl_Disc_Statistics.Add(new string[] { dr_Temp_Main1[i_Main1]["DISC_NO"].ToString(), i_Main2_Statistics.ToString(), "0" }); #endregion #region 不滿五筆資料中間補空白 for (int q = 0; q < arl_Inv_Statistics.Count % 5; q++) { arl_Inv_Statistics.Add("空白"); } #endregion i_dt_Temp_Result_Count_Inv += i_Main2_Statistics; } } #endregion #region 計算進貨的DETL資料需要幾頁來列印 i_dt_Temp_Result_Count_Purchase = (dr_Temp_Detl_Purchase.Length + i_Detl_Total) / i_Detl_Content; if ((dr_Temp_Detl_Purchase.Length + i_Detl_Total) % i_Detl_Content > 0) { i_dt_Temp_Result_Count_Purchase += 1; } #endregion #region 計算退貨的DETL資料需要幾頁來列印 i_dt_Temp_Result_Count_Return = (dr_Temp_Detl_Return.Length + i_Detl_Total) / i_Detl_Content; if ((dr_Temp_Detl_Return.Length + i_Detl_Total) % i_Detl_Content > 0) { i_dt_Temp_Result_Count_Return += 1; } #endregion //取最大值 i_dt_Temp_Result_Count = Math.Max(i_dt_Temp_Result_Count_Inv, Math.Max(i_dt_Temp_Result_Count_Purchase, i_dt_Temp_Result_Count_Return)); #region 把紀錄發票的變數的筆數補滿最大的頁數 //折讓對帳單,有可能左邊明細資料需要5頁來印,但右邊發票只要1頁來印就可以 //這時紀錄發票的變數(arl_Inv_Statistics)只有紀錄第一頁的五筆資料,2,3,4,5頁都沒紀錄, //所以要在這邊補滿"空白"這個字串,不然後面程式判斷會有誤 if (i_dt_Temp_Result_Count * 5 > arl_Inv_Statistics.Count) { int i_fill = i_dt_Temp_Result_Count * 5 - arl_Inv_Statistics.Count; for (int i_fill_variable = 0; i_fill_variable < i_fill; i_fill_variable++) { arl_Inv_Statistics.Add("空白"); } } #endregion #endregion #region 計算總計金額 & 紀錄折讓單號 foreach (DataRow dr_Main1 in dr_Temp_Main1) { #region 應稅 if (dr_Main1["TAX_TYPE"].ToString() == "0") { i_Total_Amount_Able += int.Parse(dr_Main1["DISC_UAMT"].ToString());//總計-[應稅]的[未稅金額] i_Total_Tax_Able += int.Parse(dr_Main1["DISC_TAX"].ToString());//總計-[應稅]的[稅額] i_Total_Disc_Able += int.Parse(dr_Main1["DISC_AMT"].ToString());//總計-[應稅]的[折讓總額] s_DISC_NO_Able += (s_DISC_NO_Able == string.Empty) ? dr_Main1["DISC_NO"].ToString() : "," + dr_Main1["DISC_NO"].ToString(); } #endregion #region 免稅 else if (dr_Main1["TAX_TYPE"].ToString() == "1") { i_Total_Amount_Free += int.Parse(dr_Main1["DISC_UAMT"].ToString());//總計-[免稅]的[未稅金額] i_Total_Disc_Free += int.Parse(dr_Main1["DISC_AMT"].ToString());//總計-[免稅]的[折讓總額] s_DISC_NO_Free += (s_DISC_NO_Free == string.Empty) ? dr_Main1["DISC_NO"].ToString() : "," + dr_Main1["DISC_NO"].ToString(); } #endregion #region 零稅 else if (dr_Main1["TAX_TYPE"].ToString() == "2") { i_Total_Amount_Zero += int.Parse(dr_Main1["DISC_UAMT"].ToString());//總計-[零稅]的[未稅金額] i_Total_Tax_Zero += int.Parse(dr_Main1["DISC_TAX"].ToString());//總計-[零稅]的[稅額] i_Total_Disc_Zero += int.Parse(dr_Main1["DISC_AMT"].ToString());//總計-[零稅]的[折讓總額] s_DISC_NO_Zero += (s_DISC_NO_Zero == string.Empty) ? dr_Main1["DISC_NO"].ToString() : "," + dr_Main1["DISC_NO"].ToString(); } #endregion } #endregion #region 將資料寫入TempTable for (int a = 0; a < i_dt_Temp_Result_Count; a++) { DataRow dr_Temp_Result = dt_Temp_Result.NewRow(); #region 左邊主檔資料區 dr_Temp_Result["MAIN_LEFT_0"] = "列印日期:" + s_Print_Date;//列印日期 dr_Temp_Result["MAIN_LEFT_1"] = "列印時間:" + s_Print_Time;//列印時間 dr_Temp_Result["MAIN_LEFT_2"] = Convert.ToString(a + 1) + "/" + i_dt_Temp_Result_Count.ToString();//頁次 dr_Temp_Result["MAIN_LEFT_3"] = dr_Temp_Store[0]["Z_O"].ToString();//營業所 dr_Temp_Result["MAIN_LEFT_4"] = dr_Temp_Store[0]["ROUTE"].ToString();//路線 dr_Temp_Result["MAIN_LEFT_5"] = dr_Temp_Store[0]["STEP"].ToString();//路順 dr_Temp_Result["MAIN_LEFT_6"] = dr_Temp_Store[0]["D_SIR_NAME"].ToString();//物流士 dr_Temp_Result["MAIN_LEFT_7"] = dr_Temp_Store[0]["CLOSE_MONTH"].ToString();//結帳年月 dr_Temp_Result["MAIN_LEFT_8"] = dr_Temp_Store[0]["GROUP_NO"].ToString();//店群 dr_Temp_Result["MAIN_LEFT_9"] = dr_Temp_Store[0]["STORE"].ToString();//店號 dr_Temp_Result["MAIN_LEFT_10"] = dr_Temp_Store[0]["STORE_NAME"].ToString();//店名 dr_Temp_Result["MAIN_LEFT_11"] = dr_Temp_Store[0]["STORE_TEL"].ToString();//電話 dr_Temp_Result["MAIN_LEFT_12"] = dr_Temp_Store[0]["AC_UID"].ToString();//帳務人員 dr_Temp_Result["MAIN_LEFT_13"] = dr_Temp_Store[0]["INV_ADDR"].ToString();//地址 dr_Temp_Result["MAIN_LEFT_15"] = dr_Temp_Store[0]["SAL_ID"].ToString();//帳務人員 #endregion #region 訊息告知欄位區 dr_Temp_Result["MAIN_LEFT_14"] = strPROMTE;//檔期編號 20110427 rika insert #endregion #region 右邊主檔資料區(印發票的地方) //頁籤=[折讓對帳單]時,才有右邊主檔資料區 if (s_TAB_Index == "2")//折讓對帳單 { #region 設定變數 #region 規則 /* * 折讓對帳單右邊列印發票部份為一式四份,每一式可列印五張發票 * 折讓單必須分別列印 * EX: * 假設STORE1在同一天有A,B兩張折讓單 * A折讓單對應6張發票,B折讓單對應3張發票 * 則該份折讓對帳單應該列印出三張 * 第一張:A折讓單 & 對應的前5張發票 * 第二張:A折讓單 & 對應的最後一張發票 * 第三張:B折讓單 & 對應的三張發票 */ #endregion #region 將折讓日期由西元年轉為民國年 DateTime d_DISC_DATE = DateTime.Parse(dr_Temp_Main1[0]["DISC_DATE"].ToString()); System.Globalization.TaiwanCalendar g_TaiwanCalendar = new System.Globalization.TaiwanCalendar(); string s_DISC_Year = g_TaiwanCalendar.GetYear(d_DISC_DATE).ToString(); //折讓日期(年) string s_DISC_Month = g_TaiwanCalendar.GetMonth(d_DISC_DATE).ToString(); //折讓日期(月) string s_DISC_Date = g_TaiwanCalendar.GetDayOfMonth(d_DISC_DATE).ToString(); //折讓日期(日) #endregion string s_VOUCH_RFNO = string.Empty; bool b_Is_Bearing_Page = false;//折讓單[合計]是否顯示"續下頁" string s_Disc_Total_String = string.Empty; #endregion //一張折讓對帳單是[一式四份] for (int b = 0; b < 4; b++) { #region 將發票資料寫入TempTable //一式包含[五張發票] for (int c = 0; c < 5; c++) { if (arl_Inv_Statistics.Count > 0 && arl_Inv_Statistics[a * 5 + c].ToString() != "空白") { int i_dr_Temp_Main2_Count = int.Parse(((string[])(arl_Inv_Statistics[a * 5 + c]))[1].ToString()); #region 將發票日期由西元年轉換成民國年 DateTime d_INV_DATE = DateTime.Parse(dr_Temp_Main2[i_dr_Temp_Main2_Count]["INV_DATE"].ToString()); string s_INV_Year = g_TaiwanCalendar.GetYear(d_INV_DATE).ToString(); //發票日期(年) string s_INV_Month = g_TaiwanCalendar.GetMonth(d_INV_DATE).ToString(); //發票日期(月) string s_INV_Date = g_TaiwanCalendar.GetDayOfMonth(d_INV_DATE).ToString(); //發票日期(日) #endregion #region 設定[字軌號碼][品名][數量] BCO.CAACommon CAAComm = new BCO.CAACommon(); string s_Item_Name = string.Empty; int i_Item_Name_Length = 0; s_Item_Name = dr_Temp_Main2[i_dr_Temp_Main2_Count]["ITEM_NAME"].ToString().Trim(); i_Item_Name_Length = CAAComm.Get_Byte_Length(s_Item_Name); //如果[品名]的byte長度超過16,則一次減掉一個字 //減到[品名]的byte長度小於或等於16,則跳出迴圈 if (i_Item_Name_Length > 16) { for (int i_Length = 0; i_Length < s_Item_Name.Length; i_Length++) { if (CAAComm.Get_Byte_Length(s_Item_Name.Substring(0, s_Item_Name.Length - i_Length)) <= 16) { s_Item_Name = s_Item_Name.Substring(0, s_Item_Name.Length - i_Length) + string.Empty.PadRight(16 - CAAComm.Get_Byte_Length(s_Item_Name.Substring(0, s_Item_Name.Length - i_Length)), ' '); break; } } } else { s_Item_Name = s_Item_Name + string.Empty.PadRight(16 - CAAComm.Get_Byte_Length(s_Item_Name), ' '); } #endregion #region 將資料寫入Temp Table dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_0"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["INV_FORM"].ToString();//聯式 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_1"] = s_INV_Year;//年 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_2"] = s_INV_Month;//月 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_3"] = s_INV_Date;//日 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_4"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["INV_NO"].ToString().Trim();//字軌號碼 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_4"] += string.Empty.PadLeft(1, ' ');//字軌號碼與品名之間的空白(全形空白) dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_4"] += s_Item_Name;//品名 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_4"] += string.Empty.PadLeft(1, ' ');//品名與數量之間的空白(全形空白) dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_4"] += "1";//數量 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_5"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["DISC_UAMT"].ToString();//末稅金額 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_6"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["DISC_TAX"].ToString();//稅額 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_7"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["TAX_TYPE"].ToString() == "0" ? "V" : string.Empty;//應稅 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_8"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["TAX_TYPE"].ToString() == "2" ? "V" : string.Empty;//零稅 dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_" + c.ToString() + "_9"] = dr_Temp_Main2[i_dr_Temp_Main2_Count]["TAX_TYPE"].ToString() == "1" ? "V" : string.Empty;//免稅 #endregion } } #endregion #region 如果發票明細有資料,才將折讓單資訊寫入表頭 if (dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_0_0"].ToString() != string.Empty) { if (arl_Inv_Statistics.Count > 0 && arl_Inv_Statistics[a * 5 + 0].ToString() != "空白") { /* * 右邊發票資料是一式四份 * 每一式上方和下方是折讓單資料,中間是發票資料 * 每一張折讓對帳單中的發票資料會對應到同一張折讓單,不會對應到多筆折讓單 * 所以折讓單資料就抓每一式的第一張發票所對應的折讓單 */ int i_dr_Temp_Main1_Count = int.Parse(((string[])(arl_Inv_Statistics[a * 5 + 0]))[0].ToString()); #region 設定欄位[統一編號] s_VOUCH_RFNO = Get_VOUCH_RFNO(dr_Temp_Main1[i_dr_Temp_Main1_Count]["RFNO"].ToString()); #endregion #region 設定欄位[合計]的顯示方式 if (b == 0) { for (int i_Show_All = 0; i_Show_All < arl_Disc_Statistics.Count; i_Show_All++) { string[] s_Disc_Array = (string[])arl_Disc_Statistics[i_Show_All]; if (s_Disc_Array[0].ToString() == dr_Temp_Main1[i_dr_Temp_Main1_Count]["DISC_NO"].ToString()) { s_Disc_Array[2] = Convert.ToString(Convert.ToInt32(s_Disc_Array[2]) + 1); if (s_Disc_Array[1] != s_Disc_Array[2]) { b_Is_Bearing_Page = true; } s_Disc_Total_String = s_Disc_Array[2] + "/" + s_Disc_Array[1]; } } } #endregion #region 將折讓資料寫入TempTable dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_0"] = s_DISC_Year;//年 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_1"] = s_DISC_Month;//月 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_2"] = s_DISC_Date;//日 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_3"] = dr_Temp_Main1[i_dr_Temp_Main1_Count]["DISC_NO"].ToString();//折讓單號 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_4"] = dr_Temp_Main1[i_dr_Temp_Main1_Count]["Z_O"].ToString();//營業所 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_5"] = dr_Temp_Main1[i_dr_Temp_Main1_Count]["AC_UID"].ToString();//帳務人員 decimal decDISC_UAMT = decimal.Parse(dr_Temp_Main1[i_dr_Temp_Main1_Count]["DISC_UAMT"].ToString()); decimal decDISC_TAX = decimal.Parse(dr_Temp_Main1[i_dr_Temp_Main1_Count]["DISC_TAX"].ToString()); //if (dr_Temp_Main1[i_dr_Temp_Main1_Count]["DISC_FORM"].ToString().Trim() == "34") //{ // decDISC_UAMT = decDISC_UAMT + decDISC_TAX; // decDISC_TAX = 0; //} dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_6"] = (b_Is_Bearing_Page == true) ? "續下頁" : decDISC_UAMT.ToString();//金額(不含稅之進貨額) dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_7"] = (b_Is_Bearing_Page == true) ? string.Empty : decDISC_TAX.ToString();//營業稅額 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_8"] = (b_Is_Bearing_Page == true) ? string.Empty : ((dr_Temp_Main1[i_dr_Temp_Main1_Count]["TAX_TYPE"].ToString() == "0") ? "V" : string.Empty);//應稅 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_9"] = (b_Is_Bearing_Page == true) ? string.Empty : ((dr_Temp_Main1[i_dr_Temp_Main1_Count]["TAX_TYPE"].ToString() == "2") ? "V" : string.Empty);//零稅率 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_10"] = (b_Is_Bearing_Page == true) ? string.Empty : ((dr_Temp_Main1[i_dr_Temp_Main1_Count]["TAX_TYPE"].ToString() == "1") ? "V" : string.Empty);//免稅 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_11"] = dr_Temp_Main1[i_dr_Temp_Main1_Count]["STORE_ID"].ToString() + " " + dr_Temp_Main1[i_dr_Temp_Main1_Count]["TITLE"].ToString();//原進貨營業人(或原買受人)名稱 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_12"] = s_VOUCH_RFNO;//營業事業統一編號 dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_13"] = s_Disc_Total_String;//幾分之幾(1/3,2/3...) dr_Temp_Result["MAIN_RIGHT_Main_" + b.ToString() + "_14"] = dr_Temp_Main1[i_dr_Temp_Main1_Count]["PROFIT_NO"].ToString();//利潤中心 #endregion } } else { dr_Temp_Result["MAIN_RIGHT_Detl_" + b.ToString() + "_0_6"] = "空白"; }//品名 #endregion } } #endregion #region 明細資料區 #region 設定Detl頁首 if (b_IsFinally == false) { #region [群分類][書展] dr_Temp_Result["DETL_0_0"] += dr_Temp_Main1[0]["ROOT_NO"].ToString().PadRight(10, ' ');//群分類 dr_Temp_Result["DETL_0_0"] += dr_Temp_Main1[0]["IS_SCHEDULE"].ToString().PadRight(10, ' ');//書展 dr_Temp_Result["DETL_0_0"] += "可扣款日:"; dr_Temp_Result["DETL_0_0"] += (dr_Temp_Main1[0]["DUE_DATE"].ToString() == string.Empty) ? " " : DateTime.Parse(dr_Temp_Main1[0]["DUE_DATE"].ToString()).ToString("yyyy/MM/dd"); dr_Temp_Result["DETL_0_0"] += " "; dr_Temp_Result["DETL_0_0"] += "可扣款總額:"; dr_Temp_Result["DETL_0_0"] += string.Format("{0:#,0}", i_Total_Disc_Able + i_Total_Disc_Free + i_Total_Disc_Zero).PadLeft(10);//總計-[應稅]的[折讓總額] #endregion #region 頁首上面[橫線] dr_Temp_Result["DETL_1_0"] = "-----------"; dr_Temp_Result["DETL_1_1"] = "----------------------"; dr_Temp_Result["DETL_1_2"] = "----------------------"; dr_Temp_Result["DETL_1_3"] = "----------------------"; dr_Temp_Result["DETL_1_4"] = "----------------------"; dr_Temp_Result["DETL_1_5"] = "----------------------"; dr_Temp_Result["DETL_1_6"] = "----------------------"; dr_Temp_Result["DETL_1_7"] = "-----|-----"; dr_Temp_Result["DETL_1_8"] = "--------------"; dr_Temp_Result["DETL_1_9"] = "----------------------"; dr_Temp_Result["DETL_1_10"] = "----------------------"; dr_Temp_Result["DETL_1_11"] = "----------------------"; dr_Temp_Result["DETL_1_12"] = "----------------------"; dr_Temp_Result["DETL_1_13"] = "----------------------"; dr_Temp_Result["DETL_1_14"] = "----------------------"; #endregion #region 頁首[標題] dr_Temp_Result["DETL_2_0"] = "日期"; dr_Temp_Result["DETL_2_1"] = "屬性"; dr_Temp_Result["DETL_2_2"] = "稅別"; dr_Temp_Result["DETL_2_3"] = "高見單號"; dr_Temp_Result["DETL_2_4"] = "通路單號"; dr_Temp_Result["DETL_2_5"] = "未稅金額"; dr_Temp_Result["DETL_2_6"] = "含稅金額"; dr_Temp_Result["DETL_2_7"] = "|"; dr_Temp_Result["DETL_2_8"] = "日期"; dr_Temp_Result["DETL_2_9"] = "屬性"; dr_Temp_Result["DETL_2_10"] = "稅別"; dr_Temp_Result["DETL_2_11"] = "高見單號"; dr_Temp_Result["DETL_2_12"] = "通路單號"; dr_Temp_Result["DETL_2_13"] = "未稅金額"; dr_Temp_Result["DETL_2_14"] = "含稅金額"; #endregion #region 頁首下面[橫線] dr_Temp_Result["DETL_3_0"] = "-----------"; dr_Temp_Result["DETL_3_1"] = "----------------------"; dr_Temp_Result["DETL_3_2"] = "----------------------"; dr_Temp_Result["DETL_3_3"] = "----------------------"; dr_Temp_Result["DETL_3_4"] = "----------------------"; dr_Temp_Result["DETL_3_5"] = "----------------------"; dr_Temp_Result["DETL_3_6"] = "----------------------"; dr_Temp_Result["DETL_3_7"] = "-----|-----"; dr_Temp_Result["DETL_3_8"] = "--------------"; dr_Temp_Result["DETL_3_9"] = "----------------------"; dr_Temp_Result["DETL_3_10"] = "----------------------"; dr_Temp_Result["DETL_3_11"] = "----------------------"; dr_Temp_Result["DETL_3_12"] = "----------------------"; dr_Temp_Result["DETL_3_13"] = "----------------------"; dr_Temp_Result["DETL_3_14"] = "----------------------"; #endregion } #endregion #region 設定Detl內容 int i_Actual_Purchase = 0;//進貨實際寫入筆數 int i_Actual_Return = 0;//退貨實際寫入筆數 decimal dec_TOT_AMT_AND_TAX = 0;//計算含稅金額 //i_Detl_Content = Detl內容行數 for (int d = 0; d < i_Detl_Content; d++) { int i_dr_Temp_Detl_Count = a * i_Detl_Content + d; #region 進貨部分 if (dr_Temp_Detl_Purchase.Length > i_dr_Temp_Detl_Count) { #region 計算含稅金額 #region 規則 /* * 原本的規則: * 如果稅別 = 應稅&零稅,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX * 如果稅別 = 免稅,含稅金額直接放0 * 20091005 秀玲修改規則 * 不管它的稅別,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX */ #endregion dec_TOT_AMT_AND_TAX = decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()) + decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); #endregion #region 寫入資料 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_0"] = DateTime.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["ACCT_DATE"].ToString()).ToString("yyyy/MM/dd");//日期 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_1"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["ACCT_KD"];//屬性 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_2"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"];//稅別 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_3"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["EA_NO"];//高見單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_4"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["CHAN_SOURCE_NO"];//通路單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_5"] = (Math.Abs(decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString())) > 1000000) ? "******" : string.Format("{0:N}", dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"]);//未稅金額 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_6"] = (Math.Abs(dec_TOT_AMT_AND_TAX) > 1000000) ? "******" : string.Format("{0:N}", dec_TOT_AMT_AND_TAX);//含稅金額 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_7"] = "|"; #endregion #region 計算[進貨]的明細最後是寫到哪一行 i_Actual_Purchase = i_Detl_Title + d; #endregion #region 計算[小計]金額 dec_Subtotal_TOT_AMT_Purchase += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//[小計]-進貨未稅金額 dec_Subtotal_TOT_AMT_AND_TAX_Purchase += dec_TOT_AMT_AND_TAX;//[小計]-進貨含稅金額 #endregion #region 計算[單店小計]金額 if (dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "應稅") { dec_Single_Amount_Able += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[應稅]的[合計] dec_Single_Tax_Able += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString());//單店小計-[應稅]的[稅額] } else if (dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "免稅") { dec_Single_Amount_Free += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()); }//單店小計-[免稅]的[合計] else if (dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "零稅") { dec_Single_Amount_Zero += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[零稅]的[合計] dec_Single_Tax_Zero += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); //單店小計-[零稅]的[稅額] } #endregion } #endregion #region 退貨部分 if (dr_Temp_Detl_Return.Length > i_dr_Temp_Detl_Count) { #region 計算含稅金額 #region 規則 /* * 原本的規則: * 如果稅別 = 應稅&零稅,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX * 如果稅別 = 免稅,含稅金額直接放0 * 20091005 秀玲修改規則 * 不管它的稅別,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX */ #endregion dec_TOT_AMT_AND_TAX = decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()) + decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); #endregion #region 寫入資料 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_7"] = "|"; dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_8"] = DateTime.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["ACCT_DATE"].ToString()).ToString("yyyy/MM/dd");//日期 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_9"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["ACCT_KD"];//屬性 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_10"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"];//稅別 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_11"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["EA_NO"];//高見單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_12"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["CHAN_SOURCE_NO"];//通路單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_13"] = (Math.Abs(decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString())) > 1000000) ? "******" : string.Format("{0:N}", dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"]);//未稅金額 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_14"] = (Math.Abs(dec_TOT_AMT_AND_TAX) > 1000000) ? "******" : string.Format("{0:N}", dec_TOT_AMT_AND_TAX);//含稅金額 #endregion #region 計算[退貨]的明細最後是寫到哪一行 i_Actual_Return = i_Detl_Title + d; #endregion #region 計算[小計]金額 dec_Subtotal_TOT_AMT_Return += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//[小計]-退貨未稅金額 dec_Subtotal_TOT_AMT_AND_TAX_Return += dec_TOT_AMT_AND_TAX;//[小計]-退貨含稅金額 #endregion #region 計算[單店小計]金額 if (dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "應稅") { dec_Single_Amount_Able += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[應稅]的[合計] dec_Single_Tax_Able += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString());//單店小計-[應稅]的[稅額] } else if (dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "免稅") { dec_Single_Amount_Free += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()); }//單店小計-[免稅]的[合計] else if (dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "零稅") { dec_Single_Amount_Zero += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[零稅]的[合計] dec_Single_Tax_Zero += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); //單店小計-[零稅]的[稅額] } #endregion } #endregion } #endregion #region 設定Detl頁尾[小計]&[單店小計]&[總計] //取得Detl頁尾小計從哪一行開始 int i_Detl_Subtotal_Begin = ((i_Actual_Purchase > i_Actual_Return) ? i_Actual_Purchase : i_Actual_Return) + 1; //判斷是否為最後一筆 if ((i_Detl_Content * a + i_Detl_Subtotal_Begin - i_Detl_Title == ((dr_Temp_Detl_Purchase.Length > dr_Temp_Detl_Return.Length) ? dr_Temp_Detl_Purchase.Length : dr_Temp_Detl_Return.Length)) || (b_IsFinally == true)) { //i_Detl_Count = Detl明細資料總共有幾行(包含[頁首][內容][頁尾小計][頁尾總計]) //i_Detl_Subtotal = Detl頁尾小計有幾行 int i_Detl_Total_Begin = 0;//紀錄Detl頁尾單店小計&總計從哪一行開始 int i_Actual_Detl_Total_Begin = 0;//設定小計總計是要在哪一行 int i_Original_i_Actual_Total = 0;//若是這一頁是只印小計總計部分,這個變數紀錄上一頁是印到第幾筆 if (b_IsFinally == true) { i_Original_i_Actual_Total = i_Actual_Total; } else { i_Detl_Total_Begin = i_Detl_Subtotal_Begin; } #region 小計 #region [小計]上方那一條線 if ((i_Detl_Total_Begin + 0 < i_Detl_Count) && (i_Actual_Total < 1)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 0; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_1"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_2"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_3"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_4"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_5"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_6"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_7"] = "-----|-----"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_8"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_9"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_10"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_11"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_12"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_13"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_14"] = "----------------------"; i_Actual_Total = 1; } #endregion #region [小計]資料 if ((i_Detl_Total_Begin + 1 < i_Detl_Count) && (i_Actual_Total < 2)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 1; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = "小計"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_5"] = (Math.Abs(dec_Subtotal_TOT_AMT_Purchase) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_Purchase);//進貨[未稅金額]小計 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_6"] = (Math.Abs(dec_Subtotal_TOT_AMT_AND_TAX_Purchase) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_AND_TAX_Purchase);//進貨[含稅金額]小計 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_7"] = "|"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_13"] = (Math.Abs(dec_Subtotal_TOT_AMT_Return) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_Return);//退貨[未稅金額]小計 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_14"] = (Math.Abs(dec_Subtotal_TOT_AMT_AND_TAX_Return) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_AND_TAX_Return);//退貨[含稅金額]小計 i_Actual_Total = 2; } #endregion #region [小計]下方那一條線 if ((i_Detl_Total_Begin + 2 < i_Detl_Count) && (i_Actual_Total < 3)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 2; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_1"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_2"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_3"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_4"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_5"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_6"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_7"] = "-----|-----"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_8"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_9"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_10"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_11"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_12"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_13"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_14"] = "----------------------"; i_Actual_Total = 3; } #endregion #endregion #region 單店小計 if ((i_Detl_Total_Begin + 3 < i_Detl_Count) && (i_Actual_Total < 4)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 3; } //注意:[應稅 合計:$]中間的空白,是[全型]的空白 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "單店小計".PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(45); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "應稅 :未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Able, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Tax_Able, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); if (dec_Single_Amount_Able < 0) { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } else { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Able, MidpointRounding.AwayFromZero) + System.Math.Round(dec_Single_Tax_Able, MidpointRounding.AwayFromZero)).PadLeft(10); i_Actual_Total = 4; } if ((i_Detl_Total_Begin + 4 < i_Detl_Count) && (i_Actual_Total < 5)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 4; } //注意:[免稅 合計:$]中間的空白,是[全型]的空白 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(45); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "免稅 :未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Free, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(8); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); if (dec_Single_Amount_Free < 0) { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } else { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Free, MidpointRounding.AwayFromZero)).PadLeft(10); i_Actual_Total = 5; } if ((i_Detl_Total_Begin + 5 < i_Detl_Count) && (i_Actual_Total < 6)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 5; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(45); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "零稅率:未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Zero, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Tax_Zero, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); if (dec_Single_Amount_Zero < 0) { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } else { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Zero, MidpointRounding.AwayFromZero) + System.Math.Round(dec_Single_Tax_Zero, MidpointRounding.AwayFromZero)).PadLeft(10); i_Actual_Total = 6; } #endregion #region 中間空一行 if ((i_Detl_Total_Begin + 6 < i_Detl_Count) && (i_Actual_Total < 7)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 6; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = string.Empty; i_Actual_Total = 7; } #endregion #region 總計 if ((i_Detl_Total_Begin + 7 < i_Detl_Count) && (i_Actual_Total < 8)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 7; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總計".PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "應稅折讓號碼 :"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += (s_DISC_NO_Able.Length > 28) ? s_DISC_NO_Able.Substring(0, 27) : s_DISC_NO_Able.PadRight(27); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(2); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "應稅 :未稅金額"; i_Total_Amount_Able = i_Total_Amount_Able * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Amount_Able).PadLeft(10);//總計-[應稅]的[未稅金額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; i_Total_Tax_Able = i_Total_Tax_Able * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Tax_Able).PadLeft(10);//總計-[應稅]的[稅額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "折讓總額:$";//折讓總額 i_Total_Disc_Able = i_Total_Disc_Able * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Disc_Able).PadLeft(10);//總計-[應稅]的[折讓總額] i_Actual_Total = 8; } if ((i_Detl_Total_Begin + 8 < i_Detl_Count) && (i_Actual_Total < 9)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 8; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "免稅折讓號碼 :"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += (s_DISC_NO_Free.Length > 28) ? s_DISC_NO_Free.Substring(0, 27) : s_DISC_NO_Free.PadRight(27); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(2); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "免稅 :未稅金額"; i_Total_Amount_Free = i_Total_Amount_Free * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Amount_Free).PadLeft(10);//總計-[免稅]的[未稅金額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(8); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "折讓總額:$";//折讓總額 i_Total_Disc_Free = i_Total_Disc_Free * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Disc_Free).PadLeft(10);//總計-[免稅]的[折讓總額] i_Actual_Total = 9; } if ((i_Detl_Total_Begin + 9 < i_Detl_Count) && (i_Actual_Total < 10)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 9; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "零稅率折讓號碼:"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += (s_DISC_NO_Zero.Length > 28) ? s_DISC_NO_Zero.Substring(0, 27) : s_DISC_NO_Zero.PadRight(27); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(2); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "零稅率:未稅金額"; i_Total_Amount_Zero = i_Total_Amount_Zero * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Amount_Zero).PadLeft(10);//總計-[零稅]的[未稅金額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; i_Total_Tax_Zero = i_Total_Tax_Zero * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Tax_Zero).PadLeft(10);//總計-[零稅]的[稅額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "折讓總額:$"; i_Total_Disc_Zero = i_Total_Disc_Zero * -1; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Disc_Zero).PadLeft(10);//總計-[零稅]的[折讓總額] i_Actual_Total = 10; } #endregion //設定明細資料是否為最後一筆 b_IsFinally = true; } #endregion #endregion dt_Temp_Result.Rows.Add(dr_Temp_Result); } #endregion } #endregion return dt_Temp_Result; }
/// <summary> /// 設定發票對帳單列印資料 /// </summary> /// <param name="dt_Temp_Result">發票對帳單列印資料 Temp Table</param> /// <param name="d_Now">列印日期時間</param> /// <param name="dr_Temp_Main">發票對帳單左邊主檔資料區</param> /// <param name="dr_Temp_Detl_Purchase">折讓對帳單進貨明細資料區</param> /// <param name="dr_Temp_Detl_Return">折讓對帳單退貨明細資料區</param> /// <param name="dr_Temp_Detl_Return">發票對帳單店號相關資料</param> /// <param name="s_TAB_Index">1=發票對帳單,3=單店對帳單</param> /// strPROMTE /// <returns></returns> private DataTable Collate_Information_Inv(DataTable dt_Temp_Result, DateTime d_Now, DataRow[] dr_Temp_Main, DataRow[] dr_Temp_Detl_Purchase, DataRow[] dr_Temp_Detl_Return, DataRow[] dr_Temp_Store, string s_TAB_Index, string strPROMTE) { #region 錯誤資料 if ((dr_Temp_Detl_Purchase == null && dr_Temp_Detl_Return == null) || (dr_Temp_Store == null)) { DataRow dr_Temp_Result = dt_Temp_Result.NewRow(); string s_Err_Inv_No = string.Empty; foreach (DataRow dr_Main in dr_Temp_Main) { if (s_Err_Inv_No == string.Empty) { s_Err_Inv_No += dr_Main["INV_NO"].ToString(); } else { s_Err_Inv_No += "," + dr_Main["INV_NO"].ToString(); } } dr_Temp_Result["MAIN_LEFT_14"] = "資料異常,無法正確列印對帳單,發票號碼:" + s_Err_Inv_No; dt_Temp_Result.Rows.Add(dr_Temp_Result); } #endregion #region 正確資料 else { #region 設定變數 #region 列印日期 and 時間 string s_Print_Date = d_Now.ToString("yyyy/MM/dd");//列印日期 string s_Print_Time = d_Now.ToString("HH:mm:ss");//列印時間 #endregion #region 設定行數 int i_Detl_Count = 50;//設定Detl明細資料總共有幾行(包含[頁首][內容]頁尾[小計][單店小計][總計]) int i_Detl_Title = 4;//設定Detl頁首有幾行 int i_Detl_Total = 10;//設定Detl頁尾[小計][單店小計]&[總計]共有幾行 int i_Detl_Content = i_Detl_Count - i_Detl_Title;//設定Detl內容行數 bool b_IsFinally = false;//設定明細資料是否為最後一筆 int i_Actual_Total = 0;//設定Detl頁尾單店小計&總計執行到第幾筆 #endregion #region 設定發票號碼 string s_INV_NO_Able = string.Empty;//應稅發票號碼 string s_INV_NO_Free = string.Empty;//免稅發票號碼 string s_INV_NO_Zero = string.Empty;//零稅率發票號碼 #endregion #region 計算[小計]金額 decimal dec_Subtotal_TOT_AMT_Purchase = 0;//[小計]-進貨未稅金額 decimal dec_Subtotal_TOT_AMT_AND_TAX_Purchase = 0;//[小計]-進貨含稅金額 decimal dec_Subtotal_TOT_AMT_Return = 0;//[小計]-退貨未稅金額 decimal dec_Subtotal_TOT_AMT_AND_TAX_Return = 0;//[小計]-退貨含稅金額 #endregion #region 計算[單店小計]金額 decimal dec_Single_Amount_Able = 0;//單店小計-[應稅]的[合計] decimal dec_Single_Amount_Free = 0;//單店小計-[免稅]的[合計] decimal dec_Single_Amount_Zero = 0;//單店小計-[零稅]的[合計] decimal dec_Single_Tax_Able = 0;//單店小計-[應稅]的[稅額] decimal dec_Single_Tax_Zero = 0;//單店小計-[零稅]的[稅額] #endregion #region 計算[總計]金額 int i_Total_Amount_Able = 0;//總計-[應稅]的[未稅金額] int i_Total_Amount_Free = 0;//總計-[免稅]的[未稅金額] int i_Total_Amount_Zero = 0;//總計-[零稅]的[未稅金額] int i_Total_Tax_Able = 0;//總計-[應稅]的[稅額] int i_Total_Tax_Zero = 0;//總計-[零稅]的[稅額] int i_Total_Inv_Able = 0;//總計-[應稅]的[發票總額] int i_Total_Inv_Free = 0;//總計-[免稅]的[發票總額] int i_Total_Inv_Zero = 0;//總計-[零稅]的[發票總額] #endregion #endregion #region 計算需要幾頁來印這一筆資料 int i_dt_Temp_Result_Count_Inv = 0;//計算右邊主檔發票資料需要幾頁來列印 int i_dt_Temp_Result_Count_Purchase = 0;//計算進貨的DETL資料需要幾頁來列印 int i_dt_Temp_Result_Count_Return = 0;//計算退貨的DETL資料需要幾頁來列印 int i_dt_Temp_Result_Count = 0;//最後需要幾頁來列印 #region 計算右邊主檔發票資料需要幾頁來列印 if (s_TAB_Index == "1")//發票對帳單 { if (dr_Temp_Main.Length % 2 > 0) { i_dt_Temp_Result_Count_Inv = (dr_Temp_Main.Length / 2) + 1; } else { i_dt_Temp_Result_Count_Inv = dr_Temp_Main.Length / 2; } } #endregion #region 計算進貨的DETL資料需要幾頁來列印 if (dr_Temp_Detl_Purchase != null) { i_dt_Temp_Result_Count_Purchase = (dr_Temp_Detl_Purchase.Length + i_Detl_Total) / i_Detl_Content; if ((dr_Temp_Detl_Purchase.Length + i_Detl_Total) % i_Detl_Content > 0) { i_dt_Temp_Result_Count_Purchase += 1; } } #endregion #region 計算退貨的DETL資料需要幾頁來列印 if (dr_Temp_Detl_Return != null) { i_dt_Temp_Result_Count_Return = (dr_Temp_Detl_Return.Length + i_Detl_Total) / i_Detl_Content; if ((dr_Temp_Detl_Return.Length + i_Detl_Total) % i_Detl_Content > 0) { i_dt_Temp_Result_Count_Return += 1; } } #endregion //取最大值 i_dt_Temp_Result_Count = Math.Max(i_dt_Temp_Result_Count_Inv, Math.Max(i_dt_Temp_Result_Count_Purchase, i_dt_Temp_Result_Count_Return)); #endregion #region 計算總計金額 & 紀錄發票號碼 foreach (DataRow dr_Main in dr_Temp_Main) { //[TAX_TYPE] 0=應稅,1=免稅,2=零稅 #region 應稅 if (dr_Main["TAX_TYPE"].ToString() == "0") { i_Total_Amount_Able += int.Parse(dr_Main["INV_UAMT"].ToString());//總計-[應稅]的[未稅金額] i_Total_Tax_Able += int.Parse(dr_Main["INV_TAX"].ToString());//總計-[應稅]的[稅額] i_Total_Inv_Able += int.Parse(dr_Main["INV_AMT"].ToString());//總計-[應稅]的[發票總額] s_INV_NO_Able += (s_INV_NO_Able == string.Empty) ? dr_Main["INV_NO"].ToString() : "," + dr_Main["INV_NO"].ToString(); } #endregion #region 免稅 else if (dr_Main["TAX_TYPE"].ToString() == "1") { i_Total_Amount_Free += int.Parse(dr_Main["INV_UAMT"].ToString());//總計-[免稅]的[未稅金額] i_Total_Inv_Free += int.Parse(dr_Main["INV_AMT"].ToString());//總計-[免稅]的[發票總額] s_INV_NO_Free += (s_INV_NO_Free == string.Empty) ? dr_Main["INV_NO"].ToString() : "," + dr_Main["INV_NO"].ToString(); } #endregion #region 零稅 else if (dr_Main["TAX_TYPE"].ToString() == "2") { i_Total_Amount_Zero += int.Parse(dr_Main["INV_UAMT"].ToString());//總計-[零稅]的[未稅金額] i_Total_Tax_Zero += int.Parse(dr_Main["INV_TAX"].ToString());//總計-[零稅]的[稅額] i_Total_Inv_Zero += int.Parse(dr_Main["INV_AMT"].ToString());//總計-[零稅]的[發票總額] s_INV_NO_Zero += (s_INV_NO_Zero == string.Empty) ? dr_Main["INV_NO"].ToString() : "," + dr_Main["INV_NO"].ToString(); } #endregion } #endregion #region 將資料寫入TempTable for (int a = 0; a < i_dt_Temp_Result_Count; a++) { DataRow dr_Temp_Result = dt_Temp_Result.NewRow(); #region 左邊主檔資料區 //取第一筆發票的資料 dr_Temp_Result["MAIN_LEFT_0"] = "列印日期:" + s_Print_Date;//列印日期 dr_Temp_Result["MAIN_LEFT_1"] = "列印時間:" + s_Print_Time;//列印時間 dr_Temp_Result["MAIN_LEFT_2"] = Convert.ToString(a + 1) + "/" + i_dt_Temp_Result_Count.ToString();//頁次 dr_Temp_Result["MAIN_LEFT_3"] = dr_Temp_Store[0]["ROUTE"].ToString();//路線 dr_Temp_Result["MAIN_LEFT_4"] = dr_Temp_Store[0]["STEP"].ToString();//路順 dr_Temp_Result["MAIN_LEFT_5"] = dr_Temp_Store[0]["D_SIR_NAME"].ToString();//物流士 dr_Temp_Result["MAIN_LEFT_6"] = dr_Temp_Store[0]["CLOSE_MONTH"].ToString();//結帳年月 dr_Temp_Result["MAIN_LEFT_7"] = dr_Temp_Store[0]["INV_ADDR"].ToString();//地址 dr_Temp_Result["MAIN_LEFT_8"] = dr_Temp_Store[0]["GROUP_NO"].ToString();//店群 dr_Temp_Result["MAIN_LEFT_9"] = dr_Temp_Store[0]["STORE"].ToString();//店號 dr_Temp_Result["MAIN_LEFT_10"] = dr_Temp_Store[0]["STORE_NAME"].ToString();//店名 dr_Temp_Result["MAIN_LEFT_11"] = dr_Temp_Store[0]["STORE_TEL"].ToString();//電話 dr_Temp_Result["MAIN_LEFT_12"] = dr_Temp_Store[0]["AC_UID"].ToString();//帳務人員 dr_Temp_Result["MAIN_LEFT_13"] = dr_Temp_Store[0]["PAY_ACCOUNT"].ToString();//匯款帳號 dr_Temp_Result["MAIN_LEFT_15"] = dr_Temp_Store[0]["SAL_ID"].ToString();//帳務人員 #endregion #region 訊息告知欄位區 dr_Temp_Result["MAIN_LEFT_14"] = strPROMTE;//檔期編號 20110427 rika insert #endregion #region 右邊主檔資料區(印發票的地方) if (s_TAB_Index == "1")//發票對帳單 { #region 規則 /* * 只有頁籤為[發票對帳單]右邊才需要印發票 * 一張發票對帳單右邊有四格印發票的位置 * 每一張發票要印兩小格 * 所以一張發票對帳單只能印兩張發票 */ #endregion #region 設定變數 int i_Temp_Main_Count = 0;//計算第幾筆發票 int i_Right_B = 0; int i_Right_E = 0; string s_VOUCH_RFNO = string.Empty;//統一編號 #endregion #region 將發票資料寫入TempTable for (int b = 0; b < 2; b++) { #region 設定該讀取第幾筆資料 i_Temp_Main_Count = (a * 2) + b; //第一筆資料 if (b == 0) { i_Right_B = 0; i_Right_E = 1; } //第二筆資料 else { i_Right_B = 2; i_Right_E = 3; } #endregion #region 有資料,則顯示資料 if (dr_Temp_Main.Length > i_Temp_Main_Count) { DateTime d_INV_DATE = DateTime.Parse(dr_Temp_Main[i_Temp_Main_Count]["INV_DATE"].ToString()); System.Globalization.TaiwanCalendar g_TaiwanCalendar = new System.Globalization.TaiwanCalendar(); string s_INV_Year = g_TaiwanCalendar.GetYear(d_INV_DATE).ToString(); //發票日期(年) string s_INV_Month = g_TaiwanCalendar.GetMonth(d_INV_DATE).ToString(); //發票日期(月) string s_INV_Date = g_TaiwanCalendar.GetDayOfMonth(d_INV_DATE).ToString(); //發票日期(日) string s_INV_AMT = Conversion_Number(dr_Temp_Main[i_Temp_Main_Count]["INV_AMT"].ToString(), 9); #region 設定統一編號 s_VOUCH_RFNO = Get_VOUCH_RFNO(dr_Temp_Main[i_Temp_Main_Count]["VOUCH_RFNO"].ToString()); #endregion for (int c = i_Right_B; c <= i_Right_E; c++) { decimal decINV_UAMT = decimal.Parse(dr_Temp_Main[i_Temp_Main_Count]["INV_UAMT"].ToString()); decimal decINV_TAX = decimal.Parse(dr_Temp_Main[i_Temp_Main_Count]["INV_TAX"].ToString()); if (dr_Temp_Main[i_Temp_Main_Count]["INV_FORM"].ToString().Trim() == "32") { decINV_UAMT = decINV_UAMT + decINV_TAX; decINV_TAX = 0; } dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_0"] = s_INV_Year;//年 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_1"] = s_INV_Month;//月 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_2"] = s_INV_Date;//日 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_3"] = dr_Temp_Main[i_Temp_Main_Count]["INV_CHKNO"].ToString();//檢查號碼 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_4"] = dr_Temp_Main[i_Temp_Main_Count]["INV_NO"].ToString();//發票號碼 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_5"] = dr_Temp_Main[i_Temp_Main_Count]["TITLE"].ToString();//買受人 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_6"] = s_VOUCH_RFNO;//統一編號 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_7"] = dr_Temp_Main[i_Temp_Main_Count]["ITEM_NAME"].ToString();//品名 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_8"] = decINV_UAMT; dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_9"] = (dr_Temp_Main[i_Temp_Main_Count]["TAX_TYPE"].ToString() == "0") ? "V" : string.Empty;//應稅 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_10"] = (dr_Temp_Main[i_Temp_Main_Count]["TAX_TYPE"].ToString() == "2") ? "V" : string.Empty;//零稅 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_11"] = (dr_Temp_Main[i_Temp_Main_Count]["TAX_TYPE"].ToString() == "1") ? "V" : string.Empty;//免稅 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_12"] = decINV_UAMT.ToString();//銷售額合計 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_13"] = decINV_TAX.ToString();//營業稅 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_14"] = dr_Temp_Main[i_Temp_Main_Count]["INV_AMT"].ToString();//總計 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_23"] = s_INV_AMT.Substring(0, 1);//億 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_15"] = s_INV_AMT.Substring(1, 1);//千萬 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_16"] = s_INV_AMT.Substring(2, 1);//百萬 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_17"] = s_INV_AMT.Substring(3, 1);//十萬 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_18"] = s_INV_AMT.Substring(4, 1);//萬 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_19"] = s_INV_AMT.Substring(5, 1);//千 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_20"] = s_INV_AMT.Substring(6, 1);//百 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_21"] = s_INV_AMT.Substring(7, 1);//拾 dr_Temp_Result["MAIN_RIGHT_" + c.ToString() + "_22"] = s_INV_AMT.Substring(8, 1);//元 } } #endregion #region 沒有資料,則顯示空白 else { dr_Temp_Result["MAIN_RIGHT_" + i_Right_B + "_7"] = "空白";//品名 dr_Temp_Result["MAIN_RIGHT_" + i_Right_E + "_7"] = "空白";//品名 } #endregion } #endregion } #endregion #region 明細資料區 //如果發票主檔中的發票號碼與VDS_CAM_ACCT_CHECK_OUT無相對應資料 //但必須秀出發票的資料,明細部分空白(與秀玲確認無誤) if (dr_Temp_Detl_Purchase != null && dr_Temp_Detl_Return != null) { #region 設定Detl頁首 if (b_IsFinally == false) { #region [群分類][書展][應付款日] dr_Temp_Result["DETL_0_0"] += dr_Temp_Main[0]["ROOT_NO"].ToString().PadRight(10, ' ');//群分類 dr_Temp_Result["DETL_0_0"] += dr_Temp_Main[0]["IS_SCHEDULE"].ToString().PadRight(10, ' ');//書展 dr_Temp_Result["DETL_0_0"] += "應付款日:";//應付款日 TITLE dr_Temp_Result["DETL_0_0"] += (dr_Temp_Main[0]["DUE_DATE"].ToString() == string.Empty) ? " " : DateTime.Parse(dr_Temp_Main[0]["DUE_DATE"].ToString()).ToString("yyyy/MM/dd");//應付款日 dr_Temp_Result["DETL_0_0"] += " "; dr_Temp_Result["DETL_0_0"] += "應付總額:"; dr_Temp_Result["DETL_0_0"] += string.Format("{0:#,0}", i_Total_Inv_Able + i_Total_Inv_Free + i_Total_Inv_Zero).PadLeft(10); #endregion #region 頁首上面[橫線] dr_Temp_Result["DETL_1_0"] = "-----------"; dr_Temp_Result["DETL_1_1"] = "----------------------"; dr_Temp_Result["DETL_1_2"] = "----------------------"; dr_Temp_Result["DETL_1_3"] = "----------------------"; dr_Temp_Result["DETL_1_4"] = "----------------------"; dr_Temp_Result["DETL_1_5"] = "----------------------"; dr_Temp_Result["DETL_1_6"] = "----------------------"; dr_Temp_Result["DETL_1_7"] = "-----|-----"; dr_Temp_Result["DETL_1_8"] = "--------------"; dr_Temp_Result["DETL_1_9"] = "----------------------"; dr_Temp_Result["DETL_1_10"] = "----------------------"; dr_Temp_Result["DETL_1_11"] = "----------------------"; dr_Temp_Result["DETL_1_12"] = "----------------------"; dr_Temp_Result["DETL_1_13"] = "----------------------"; dr_Temp_Result["DETL_1_14"] = "----------------------"; #endregion #region 頁首[標題] dr_Temp_Result["DETL_2_0"] = "日期"; dr_Temp_Result["DETL_2_1"] = "屬性"; dr_Temp_Result["DETL_2_2"] = "稅別"; dr_Temp_Result["DETL_2_3"] = "高見單號"; dr_Temp_Result["DETL_2_4"] = "通路單號"; dr_Temp_Result["DETL_2_5"] = "未稅金額"; dr_Temp_Result["DETL_2_6"] = "含稅金額"; dr_Temp_Result["DETL_2_7"] = "|"; dr_Temp_Result["DETL_2_8"] = "日期"; dr_Temp_Result["DETL_2_9"] = "屬性"; dr_Temp_Result["DETL_2_10"] = "稅別"; dr_Temp_Result["DETL_2_11"] = "高見單號"; dr_Temp_Result["DETL_2_12"] = "通路單號"; dr_Temp_Result["DETL_2_13"] = "未稅金額"; dr_Temp_Result["DETL_2_14"] = "含稅金額"; #endregion #region 頁首下面[橫線] dr_Temp_Result["DETL_3_0"] = "-----------"; dr_Temp_Result["DETL_3_1"] = "----------------------"; dr_Temp_Result["DETL_3_2"] = "----------------------"; dr_Temp_Result["DETL_3_3"] = "----------------------"; dr_Temp_Result["DETL_3_4"] = "----------------------"; dr_Temp_Result["DETL_3_5"] = "----------------------"; dr_Temp_Result["DETL_3_6"] = "----------------------"; dr_Temp_Result["DETL_3_7"] = "-----|-----"; dr_Temp_Result["DETL_3_8"] = "--------------"; dr_Temp_Result["DETL_3_9"] = "----------------------"; dr_Temp_Result["DETL_3_10"] = "----------------------"; dr_Temp_Result["DETL_3_11"] = "----------------------"; dr_Temp_Result["DETL_3_12"] = "----------------------"; dr_Temp_Result["DETL_3_13"] = "----------------------"; dr_Temp_Result["DETL_3_14"] = "----------------------"; #endregion } #endregion #region 設定Detl內容 int i_Actual_Purchase = 0;//進貨實際寫入筆數 int i_Actual_Return = 0;//退貨實際寫入筆數 decimal dec_TOT_AMT_AND_TAX = 0;//計算含稅金額 //i_Detl_Content = Detl內容行數 for (int d = 0; d < i_Detl_Content; d++) { int i_dr_Temp_Detl_Count = a * i_Detl_Content + d; #region 進貨部分 if (dr_Temp_Detl_Purchase.Length > i_dr_Temp_Detl_Count) { #region 計算含稅金額 #region 規則 /* * 原本的規則: * 如果稅別 = 應稅&零稅,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX * 如果稅別 = 免稅,含稅金額直接放0 * 20091005 秀玲修改規則 * 不管它的稅別,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX */ #endregion dec_TOT_AMT_AND_TAX = decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()) + decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); #endregion #region 寫入資料 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_0"] = DateTime.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["ACCT_DATE"].ToString()).ToString("yyyy/MM/dd");//日期 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_1"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["ACCT_KD"];//屬性 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_2"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"];//稅別 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_3"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["EA_NO"];//高見單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_4"] = dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["CHAN_SOURCE_NO"];//通路單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_5"] = (Math.Abs(decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString())) > 1000000) ? "******" : string.Format("{0:N}", dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"]);//未稅金額 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_6"] = (Math.Abs(dec_TOT_AMT_AND_TAX) > 1000000) ? "******" : string.Format("{0:N}", dec_TOT_AMT_AND_TAX);//含稅金額 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_7"] = "|"; #endregion #region 計算[進貨]的明細最後是寫到哪一行 i_Actual_Purchase = i_Detl_Title + d; #endregion #region 計算[小計]金額 dec_Subtotal_TOT_AMT_Purchase += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//[小計]-進貨未稅金額 dec_Subtotal_TOT_AMT_AND_TAX_Purchase += dec_TOT_AMT_AND_TAX;//[小計]-進貨含稅金額 #endregion #region 計算[單店小計]金額 if (dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "應稅") { dec_Single_Amount_Able += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[應稅]的[合計] dec_Single_Tax_Able += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString());//單店小計-[應稅]的[稅額] } else if (dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "免稅") { dec_Single_Amount_Free += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()); }//單店小計-[免稅]的[合計] else if (dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "零稅") { dec_Single_Amount_Zero += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[零稅]的[合計] dec_Single_Tax_Zero += decimal.Parse(dr_Temp_Detl_Purchase[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); //單店小計-[零稅]的[稅額] } #endregion } #endregion #region 退貨部分 if (dr_Temp_Detl_Return.Length > i_dr_Temp_Detl_Count) { #region 計算含稅金額 #region 規則 /* * 原本的規則: * 如果稅別 = 應稅&零稅,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX * 如果稅別 = 免稅,含稅金額直接放0 * 20091005 秀玲修改規則 * 不管它的稅別,含稅金額 = VDS_CAM_ACCT_CHECK_OUT.TOT_AMT + VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX */ #endregion dec_TOT_AMT_AND_TAX = decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()) + decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); #endregion #region 寫入資料 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_7"] = "|"; dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_8"] = DateTime.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["ACCT_DATE"].ToString()).ToString("yyyy/MM/dd");//日期 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_9"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["ACCT_KD"];//屬性 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_10"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"];//稅別 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_11"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["EA_NO"];//高見單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_12"] = dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["CHAN_SOURCE_NO"];//通路單號 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_13"] = (Math.Abs(decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString())) > 1000000) ? "******" : string.Format("{0:N}", dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"]);//未稅金額 dr_Temp_Result["DETL_" + Convert.ToString(i_Detl_Title + d) + "_14"] = (Math.Abs(dec_TOT_AMT_AND_TAX) > 1000000) ? "******" : string.Format("{0:N}", dec_TOT_AMT_AND_TAX);//含稅金額 #endregion #region 計算[退貨]的明細最後是寫到哪一行 i_Actual_Return = i_Detl_Title + d; #endregion #region 計算[小計]金額 dec_Subtotal_TOT_AMT_Return += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//[小計]-退貨未稅金額 dec_Subtotal_TOT_AMT_AND_TAX_Return += dec_TOT_AMT_AND_TAX;//[小計]-退貨含稅金額 #endregion #region 計算[單店小計]金額 if (dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "應稅") { dec_Single_Amount_Able += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[應稅]的[合計] dec_Single_Tax_Able += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString());//單店小計-[應稅]的[稅額] } else if (dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "免稅") { dec_Single_Amount_Free += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString()); }//單店小計-[免稅]的[合計] else if (dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TAX_TYPE"].ToString() == "零稅") { dec_Single_Amount_Zero += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT"].ToString());//單店小計-[零稅]的[合計] dec_Single_Tax_Zero += decimal.Parse(dr_Temp_Detl_Return[i_dr_Temp_Detl_Count]["TOT_AMT_TAX"].ToString()); //單店小計-[零稅]的[稅額] } #endregion } #endregion } #endregion #region 設定Detl頁尾[小計]&[單店小計]&[總計] #region 規則 /* * 單店小計中發票總額的計算方式,必須與昭宜開立發票的程式相同 * 與昭宜確認過 * 發票總額的計算方式= * (1)所有明細資料的 VDS_CAM_ACCT_CHECK_OUT.TOT_AMT 先加總後,四捨五入的金額 * 加上 * (2)所有明細資料的 VDS_CAM_ACCT_CHECK_OUT.TOT_AMT_TAX 先加總後,四捨五入的金額 */ #endregion //取得Detl頁尾[小計]&[單店小計]&[總計]從哪一行開始 int i_Detl_Subtotal_Begin = ((i_Actual_Purchase > i_Actual_Return) ? i_Actual_Purchase : i_Actual_Return) + 1; //判斷是否為最後一筆 if ((i_Detl_Content * a + i_Detl_Subtotal_Begin - i_Detl_Title == ((dr_Temp_Detl_Purchase.Length > dr_Temp_Detl_Return.Length) ? dr_Temp_Detl_Purchase.Length : dr_Temp_Detl_Return.Length)) || (b_IsFinally == true)) { //i_Detl_Count = Detl明細資料總共有幾行(包含[頁首][內容][頁尾小計][頁尾總計]) //i_Detl_Subtotal = Detl頁尾小計有幾行 int i_Detl_Total_Begin = 0;//紀錄Detl頁尾[小計]&[單店小計]&[總計]從哪一行開始 int i_Actual_Detl_Total_Begin = 0;//設定[小計]&[單店小計]&[總計]是要在哪一行 int i_Original_i_Actual_Total = 0;//若是這一頁是只印[小計]&[單店小計]&[總計]部分,這個變數紀錄上一頁是印到第幾筆 if (b_IsFinally == true) { i_Original_i_Actual_Total = i_Actual_Total; } else { i_Detl_Total_Begin = i_Detl_Subtotal_Begin; } #region 小計 #region [小計]上方那一條線 if ((i_Detl_Total_Begin + 0 < i_Detl_Count) && (i_Actual_Total < 1)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 0; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_1"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_2"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_3"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_4"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_5"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_6"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_7"] = "-----|-----"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_8"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_9"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_10"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_11"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_12"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_13"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_14"] = "----------------------"; i_Actual_Total = 1; } #endregion #region [小計]資料 if ((i_Detl_Total_Begin + 1 < i_Detl_Count) && (i_Actual_Total < 2)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 1; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = "小計"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_5"] = (Math.Abs(dec_Subtotal_TOT_AMT_Purchase) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_Purchase);//進貨[未稅金額]小計 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_6"] = (Math.Abs(dec_Subtotal_TOT_AMT_AND_TAX_Purchase) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_AND_TAX_Purchase);//進貨[含稅金額]小計 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_7"] = "|"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_13"] = (Math.Abs(dec_Subtotal_TOT_AMT_Return) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_Return);//退貨[未稅金額]小計 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_14"] = (Math.Abs(dec_Subtotal_TOT_AMT_AND_TAX_Return) > 1000000) ? "******" : string.Format("{0:N}", dec_Subtotal_TOT_AMT_AND_TAX_Return);//退貨[含稅金額]小計 i_Actual_Total = 2; } #endregion #region [小計]下方那一條線 if ((i_Detl_Total_Begin + 2 < i_Detl_Count) && (i_Actual_Total < 3)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 2; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_1"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_2"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_3"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_4"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_5"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_6"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_7"] = "-----|-----"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_8"] = "--------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_9"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_10"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_11"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_12"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_13"] = "----------------------"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_14"] = "----------------------"; i_Actual_Total = 3; } #endregion #endregion #region 單店小計 if ((i_Detl_Total_Begin + 3 < i_Detl_Count) && (i_Actual_Total < 4)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 3; } //注意:[應稅 合計:$]中間的空白,是[全型]的空白 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "單店小計".PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(39); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "應稅 :未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Able, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Tax_Able, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); if (dec_Single_Amount_Able < 0) { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } else { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Able, MidpointRounding.AwayFromZero) + System.Math.Round(dec_Single_Tax_Able, MidpointRounding.AwayFromZero)).PadLeft(10); i_Actual_Total = 4; } if ((i_Detl_Total_Begin + 4 < i_Detl_Count) && (i_Actual_Total < 5)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 4; } //注意:[免稅 合計:$]中間的空白,是[全型]的空白 dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(39); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "免稅 :未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Free, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(8); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); if (dec_Single_Amount_Free < 0) { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } else { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Free, MidpointRounding.AwayFromZero)).PadLeft(10); i_Actual_Total = 5; } if ((i_Detl_Total_Begin + 5 < i_Detl_Count) && (i_Actual_Total < 6)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 5; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(39); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "零稅率:未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Zero, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Tax_Zero, MidpointRounding.AwayFromZero)).PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); if (dec_Single_Amount_Zero < 0) { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } else { dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總額:$"; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", System.Math.Round(dec_Single_Amount_Zero, MidpointRounding.AwayFromZero) + System.Math.Round(dec_Single_Tax_Zero, MidpointRounding.AwayFromZero)).PadLeft(10); i_Actual_Total = 6; } #endregion #region 中間空一行 if ((i_Detl_Total_Begin + 6 < i_Detl_Count) && (i_Actual_Total < 7)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 6; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] = string.Empty; i_Actual_Total = 7; } #endregion #region 總計 if ((i_Detl_Total_Begin + 7 < i_Detl_Count) && (i_Actual_Total < 8)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 7; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "總計".PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "應稅發票號碼 :"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += (s_INV_NO_Able.Length > 22) ? s_INV_NO_Able.Substring(0, 21) : s_INV_NO_Able.PadRight(21); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(2); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "應稅 :未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Amount_Able).PadLeft(10);//總計-[應稅]的[未稅金額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Tax_Able).PadLeft(10);//總計-[應稅]的[稅額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "發票總額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Inv_Able).PadLeft(10);//總計-[應稅]的[發票總額] i_Actual_Total = 8; } if ((i_Detl_Total_Begin + 8 < i_Detl_Count) && (i_Actual_Total < 9)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 8; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "免稅發票號碼 :"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += (s_INV_NO_Free.Length > 22) ? s_INV_NO_Free.Substring(0, 21) : s_INV_NO_Free.PadRight(21); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(2); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "免稅 :未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Amount_Free).PadLeft(10);//總計-[免稅]的[未稅金額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(8); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadLeft(10); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "發票總額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Inv_Free).PadLeft(10);//總計-[免稅]的[發票總額] i_Actual_Total = 9; } if ((i_Detl_Total_Begin + 9 < i_Detl_Count) && (i_Actual_Total < 10)) { if (b_IsFinally == true) { i_Actual_Detl_Total_Begin = i_Actual_Total - i_Original_i_Actual_Total; } else { i_Actual_Detl_Total_Begin = i_Detl_Total_Begin + 9; } dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(4, ' '); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "零稅率發票號碼:"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += (s_INV_NO_Zero.Length > 22) ? s_INV_NO_Zero.Substring(0, 21) : s_INV_NO_Zero.PadRight(21); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(2); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "零稅率:未稅金額"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Amount_Zero).PadLeft(10);//總計-[零稅]的[未稅金額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "稅額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Tax_Zero).PadLeft(10);//總計-[零稅]的[稅額] dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Empty.PadRight(5); dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += "發票總額:$"; dr_Temp_Result["DETL_" + i_Actual_Detl_Total_Begin.ToString() + "_0"] += string.Format("{0:#,0}", i_Total_Inv_Zero).PadLeft(10);//總計-[零稅]的[發票總額] i_Actual_Total = 10; } #endregion //設定明細資料是否為最後一筆 b_IsFinally = true; } #endregion } #endregion dt_Temp_Result.Rows.Add(dr_Temp_Result); } #endregion } #endregion return dt_Temp_Result; }