public override void ReadData() { List <CancelAllowanceConfirm> B0202 = new List <CancelAllowanceConfirm>(); var Value = SQLMethod.Count_B0202(); if (Value != null) { Form1.B0202Num = Value.Count; foreach (var B0202Data in Value) { CancelAllowanceConfirm data = new CancelAllowanceConfirm(); data.CancelAllowanceNumber = B0202Data.CancelAllowanceNumber.Trim(); data.AllowanceDate = B0202Data.AllowanceDate.Trim(); data.BuyerId = B0202Data.BuyerId.Trim(); data.SellerId = B0202Data.SellerId.Trim(); data.CancelDate = B0202Data.CancelDate.Trim(); data.CancelTime = B0202Data.CancelTime.Substring(0, 2) + ":" + B0202Data.CancelTime.Substring(2, 2) + ":00"; B0202.Add(data); } CancelAllowanceConfirm = B0202; if (Value.Count > 0) { XMLMethod.Save_B0202(CancelAllowanceConfirm); } } else { Form1.B0202Num = 0; } }
public override void ReadData() { List <RejectInvoice> A0301 = new List <RejectInvoice>(); var Value = SQLMethod.Count_A0301(); if (Value != null)//檢查退回發票數量 { Form1.A0301Num = Value.Count; foreach (var A0301Data in Value) { RejectInvoice data = new RejectInvoice(); data.RejectInvoiceNumber = A0301Data.RejectInvoiceNumber.Trim(); data.InvoiceDate = A0301Data.InvoiceDate.Trim(); data.BuyerId = A0301Data.BuyerId.Trim(); data.SellerId = A0301Data.SellerId.Trim(); data.RejectDate = A0301Data.RejectDate.Trim(); data.RejectTime = A0301Data.RejectTime.Substring(0, 2) + ":" + A0301Data.RejectTime.Substring(2, 2) + ":00"; data.RejectReason = A0301Data.RejectReason.Trim(); A0301.Add(data); } RejectInvoice = A0301; if (Value.Count > 0) { XMLMethod.Save_A0301(RejectInvoice); } } else { Form1.A0301Num = 0; } }
public override void ReadData() { List <InvoicConfirm> A0102 = new List <InvoicConfirm>(); var Value = SQLMethod.Count_A0102(); if (Value != null)//檢查發票接收確認數量 { Form1.A0102Num = Value.Count; foreach (var A0102Data in Value) { InvoicConfirm data = new InvoicConfirm(); data.InvoiceNumber = A0102Data.InvoiceNumber.Trim(); data.InvoiceDate = A0102Data.InvoiceDate.Trim(); data.BuyerId = A0102Data.BuyerID.Trim(); data.SellerId = A0102Data.SellerID.Trim(); data.ReceiveDate = A0102Data.ReceiveDate.Trim(); data.ReceiveTime = A0102Data.ReceiveTime.Substring(0, 2) + ":" + A0102Data.ReceiveTime.Substring(2, 2) + ":00"; A0102.Add(data); } InvoicConfirm = A0102; if (Value.Count > 0) { XMLMethod.Save_A0102(InvoicConfirm); } } else { Form1.A0102Num = 0; } }
public FileAsset(String filename, XMLMethod method, object obj, ReadDelegate readDelegate) { Filename = filename; Method = method; Object = obj; ReadMethod = readDelegate; }
public override void ReadData() { List <CancelAllowance> B0201 = new List <CancelAllowance>(); var Value = SQLMethod.Count_B0201(); if (Value != null) { Form1.B0201Num = Value.Count; foreach (var B0201Data in Value) { CancelAllowance data = new CancelAllowance(); data.CancelAllowanceNumber = B0201Data.CancelAllowanceNumber.Trim(); data.AllowanceDate = B0201Data.AllowanceDate.Trim(); data.BuyerId = B0201Data.BuyerId.Trim(); data.SellerId = B0201Data.SellerId.Trim(); data.CancelDate = B0201Data.CancelDate.Trim(); data.CancelTime = B0201Data.CancelTime.Substring(0, 2) + ":" + B0201Data.CancelTime.Substring(2, 2) + ":00"; data.CancelReason = B0201Data.CancelReason.Trim(); B0201.Add(data); } CancelAllowance = B0201; if (Value.Count > 0) { XMLMethod.Save_B0201(CancelAllowance); } } else { Form1.B0201Num = 0; } }
public override void ReadData() { List <Invoice> A0401 = new List <Invoice>(); var Value = SQLMethod.Count_A0401(); if (Value != null)//檢查開立發票數量 { Form1.A0401Num = Value.Count; var Item = SQLMethod.Count_A0401_detail(); if (Item != null)//檢查開立發票細項 { foreach (var A0401Data in Value) { Invoice data = new Invoice(); data.Main.InvoiceNumber = A0401Data.InvoiceNumber.Trim(); data.Main.InvoiceDate = A0401Data.InvoiceDate.Trim(); data.Main.InvoiceTime = A0401Data.InvoiceTime.Substring(0, 2) + ":" + A0401Data.InvoiceTime.Substring(2, 2) + ":00"; data.Main.Seller.Identifier = A0401Data.SellerID.Trim(); data.Main.Seller.Name = A0401Data.SellerName.Trim(); data.Main.Seller.Address = A0401Data.SellerAddress.Trim(); data.Main.Seller.PersonInCharge = A0401Data.SellerPersonInCharge.Trim(); data.Main.Seller.TelephoneNumber = A0401Data.SellerTelephoneNumber.Trim(); data.Main.Buyer.Identifier = A0401Data.BuyerID.Trim(); data.Main.Buyer.Name = A0401Data.BuyerName.Trim(); data.Main.InvoiceType = A0401Data.InvoiceType.Trim(); data.Main.DonateMark = A0401Data.DonateMark.Trim(); foreach (var a0401Data in Item) { if (a0401Data.InvoiceNumber == A0401Data.InvoiceNumber) { ProductItem Productitem = new ProductItem(); Productitem.Description = a0401Data.Description.Trim(); Productitem.Quantity = Convert.ToDecimal(a0401Data.Quantity); Productitem.Unit = a0401Data.Unit.Trim(); Productitem.UnitPrice = Convert.ToDecimal(a0401Data.UniPrice); Productitem.Amount = Convert.ToDecimal(a0401Data.Amount); Productitem.SequenceNumber = a0401Data.SequenceNumber.Trim(); data.Details.Add(Productitem); } } data.Amount.SalesAmount = Convert.ToDecimal(A0401Data.SalesAmount); data.Amount.TaxType = A0401Data.TaxType.Trim(); data.Amount.TaxAmount = Convert.ToDecimal(A0401Data.TaxAmount); data.Amount.TotalAmount = Convert.ToDecimal(A0401Data.TotalAmount); A0401.Add(data); } Invoice = A0401; if (Value.Count > 0) { XMLMethod.Save_A0401(Invoice); } } } else { Form1.A0401Num = 0; } }
public override void ReadData() { List <Allowance> B0101 = new List <Allowance>(); var Value = SQLMethod.Count_B0101(); if (Value != null)//檢查開立發票數量 { Form1.B0101Num = Value.Count; var Item = SQLMethod.Count_B0101_detail(); if (Item != null)//檢查開立發票細項 { foreach (var B0101Data in Value) { Allowance data = new Allowance(); data.Main.AllowanceNumber = B0101Data.AllowanceNumber.Trim(); data.Main.AllowanceDate = B0101Data.AllowanceDate.Trim(); data.Main.Seller.Identifier = B0101Data.SellerID.Trim(); data.Main.Seller.Name = B0101Data.SellerName.Trim(); data.Main.Buyer.Identifier = B0101Data.BuyerID.Trim(); data.Main.Buyer.Name = B0101Data.BuyerName.Trim(); data.Main.AllowanceType = B0101Data.AllowanceType.Trim(); foreach (var b0101Data in Item) { if (b0101Data.AllowanceNumber == B0101Data.AllowanceNumber) { ProductItem ProductItem = new ProductItem(); ProductItem.OriginalInvoiceDate = b0101Data.OriginalInvoiceDate.Trim(); ProductItem.OriginalInvoiceNumber = b0101Data.OriginalInvoiceNumber.Trim(); ProductItem.OriginalDescription = b0101Data.OriginalDescription.Trim(); ProductItem.Quantity = Convert.ToDecimal(b0101Data.Quantity); ProductItem.Unit = b0101Data.Unit.Trim(); ProductItem.UnitPrice = Convert.ToDecimal(b0101Data.UnitPrice); ProductItem.Amount = Convert.ToDecimal(b0101Data.Amount); ProductItem.Tax = Convert.ToDecimal(b0101Data.Tax); ProductItem.AllowanceSequenceNumber = b0101Data.AllowanceSequenceNumber.Trim(); ProductItem.TaxType = b0101Data.TaxType.Trim(); data.Details.Add(ProductItem); } } data.Amount.TaxAmount = Convert.ToDecimal(B0101Data.taxamount); data.Amount.TotalAmount = Convert.ToDecimal(B0101Data.Totalamount); B0101.Add(data); } Allowance = B0101; if (Value.Count > 0) { XMLMethod.Save_B0101(Allowance); } } } else { Form1.B0101Num = 0; } }
public override void ReadData() { List <BranchTrackBlank> E0402 = new List <BranchTrackBlank>(); var Value = SQLMethod.Count_E0402(); if (Value != null)//檢查開立發票數量 { Form1.E0402Num = Value.Count; var Item = SQLMethod.Count_E0402_detail(); if (Item != null)//檢查開立發票細項 { foreach (var E0401Data in Value) { BranchTrackBlank data = new BranchTrackBlank(); data.Main.HeadBan = E0401Data.Headban.Trim(); data.Main.BranchBan = E0401Data.Branchban.Trim(); data.Main.InvoiceType = E0401Data.Invoicetype.Trim(); data.Main.YearMonth = E0401Data.Yearmonth.Trim(); data.Main.InvoiceTrack = E0401Data.Invoicetrack.Trim(); foreach (var e0402Data in Item) { BranchTrackBlankItem ProductItem = new BranchTrackBlankItem(); ProductItem.InvoiceBeginNo = e0402Data.Invoicebeginno.Trim(); ProductItem.InvoiceEndNo = e0402Data.Invoiceendno.Trim(); data.Details.Add(ProductItem); } E0402.Add(data); } BranchTrackBlank = E0402; if (Value.Count > 0) { XMLMethod.Save_E0402(BranchTrackBlank); } } } else { Form1.E0402Num = 0; } }
public Form1() { InitializeComponent(); Log.Logger = new LoggerConfiguration() .WriteTo.Console() .WriteTo.File($"{AppDomain.CurrentDomain.BaseDirectory}\\log\\log-.txt", rollingInterval: RollingInterval.Day, outputTemplate: "{Timestamp:yyyy-MM-dd HH:mm:ss.fff zzz} [{Level:u3}] {Message:lj}{NewLine}{Exception}") .CreateLogger(); //宣告Serilog初始化 RemoveReportPathSetting = InitialMethod.RemoveReportPath(); SqlDBSetting = InitialMethod.SqlDB(); SQLMethod = new SQLMethod() { Form1 = this, setting = SqlDBSetting }; SQLMethod.SQLConnect(); XMLMethod = new XMLMethod() { Form1 = this, RemoveReportPathSetting = RemoveReportPathSetting }; A0101Protocol a0101Protocol = new A0101Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0101Protocol); A0102Protocol a0102Protocol = new A0102Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0102Protocol); A0201Protocol a0201Protocol = new A0201Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0201Protocol); A0202Protocol a0202Protocol = new A0202Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0202Protocol); A0301Protocol a0301Protocol = new A0301Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0301Protocol); A0302Protocol a0302Protocol = new A0302Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0302Protocol); A0401Protocol a0401Protocol = new A0401Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0401Protocol); A0501Protocol a0501Protocol = new A0501Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(a0501Protocol); B0101Protocol b0101Protocol = new B0101Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(b0101Protocol); B0102Protocol b0102Protocol = new B0102Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(b0102Protocol); B0201Protocol b0201Protocol = new B0201Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(b0201Protocol); B0202Protocol b0202Protocol = new B0202Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(b0202Protocol); B0401Protocol b0401Protocol = new B0401Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(b0401Protocol); B0501Protocol b0501Protocol = new B0501Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(b0501Protocol); E0402Protocol e0402Protocol = new E0402Protocol() { SQLMethod = SQLMethod, Form1 = this, XMLMethod = XMLMethod }; absProtocols.Add(e0402Protocol); }
public FileAsset(String filename, XMLMethod method, Object obj) { Filename = filename; Object = obj; Method = method; }