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