protected void GoXml(string sKind0up)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
//提醒一
string sTableInNo = "MAllowanceNumber";
string sKind0upAll = sKind0up + "H";
string sTableSN = sKind0up + "SN";
DataView dvResult1 = query.Kind1SelectTbl2(sTableSN + "," + sTableInNo, sKind0upAll, "ExXmlYN='N' ", sTableInNo, "");
if (dvResult1 != null)
{
for (int i = 0; i < dvResult1.Count; i++)
{
string sPgSN = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string ASN = Convert.ToString(dvResult1.Table.Rows[i][0]);
string MInvoiceNumber = Convert.ToString(dvResult1.Table.Rows[i][1]);
//開始生成XML
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, "[生成XML發票號碼:]" + MInvoiceNumber, "", "", 1);
//提醒二
if (query.ExXmlD0401(ASN, MInvoiceNumber, sKind0up, sKind0upAll, sPgSN) == true)
{
//最後要更新 ExXmlYN & ExXmlTime
System.Collections.Hashtable data = new System.Collections.Hashtable();
data["ExXmlYN"] = "Y";
//data["ExXmlTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
query.UpdateData(sKind0upAll, data, sTableSN, ASN);
}
//結束生成XML
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, "[生成XML發票號碼:]" + MInvoiceNumber, "", "", 2);
}
}
}
}
public void Begin()
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.MkDailyRrport();
}
}
private static void Main(string[] args)
{
AllocConsole();
for (;;)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
var queryData1 = query.Kind1SelectTbl2("*", "A0401H", " ExPdfYN <> 'Y' ", "", "");
var queryData2 = query.Kind1SelectTbl2("*", "C0401H", " ExPdfYN <> 'Y' ", "", "");
var queryData3 = query.Kind1SelectTbl2("*", "B0401H", " ExPdfYN <> 'Y' ", "", "");
var queryData4 = query.Kind1SelectTbl2("*", "D0401H", " ExPdfYN <> 'Y' ", "", "");
if (queryData1 != null || queryData2 != null || queryData3 != null || queryData4 != null)
{
var rows1 = queryData1.Table.Rows;
var rows2 = queryData2.Table.Rows;
var rows3 = queryData3.Table.Rows;
var rows4 = queryData4.Table.Rows;
if (rows1.Count > 0 || rows2.Count > 0 || rows3.Count > 0 || rows4.Count > 0)
{
SendMail();
}
}
}
Console.WriteLine("Check Einvoice PDF Has Create,Pls wait 5 seconds......");
System.Threading.Thread.Sleep(5000);
}
}
public void Begin(string sKind0)
{
////路徑要做變數@"D:\eInvoiceTXT\ImInput"
////sFPath = @"D:\eInvoiceTXT\ImInput";
////sFName = @"D:\eInvoiceTXT\ImInput\C0401H2017030501.txt";
//NSysDB.XMLClass oXMLeParamts = new NSysDB.XMLClass();
//string sFPathN = oXMLeParamts.GetParaXml("ImTxPaN");
//string sFPathP = oXMLeParamts.GetParaXml("ImTxPaP");
//string sFPathY = oXMLeParamts.GetParaXml("ImTxPaY");
//using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
//{
// query.CreateDIR(sFPathN);
// query.CreateDIR(sFPathP);
// query.CreateDIR(sFPathY);
//}
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.CreateDIRok("");
// string[] sArr;
// query.ReturnArr(out sArr);
// string sFPathN = sArr[0];
// string sFPathP = sArr[1];
// string sFPathY = sArr[2];
//string sPaPartition = sArr[3];
//Console.WriteLine(sFPathN);
//Console.ReadLine();
}
}
public string HelloWorld()
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.GoLogsAll("HelloWorldN", "HelloWorldN已被觸發了喔!!", "", "", "", 1);
}
return("有到喔!!");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["GGYY"] != null)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
// query.GoLogsAll("HelloWorldY", "HelloWorldY已被觸發了喔!!", Convert.ToString(sHelloWorldY), "", "", 1);
query.GoLogsAll("HelloWorldY", "HelloWorldY已被觸發了喔!!", Request.QueryString["GGYY"].ToString(), "", "", 1);
}
}
}
private static void SendMail()
{
XMLClass oXMLeParamts = new XMLClass();
string eToWho1 = "*****@*****.**";
string eFromWho1 = oXMLeParamts.GetParaXml("eFromWho");
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.AutoEMail(eToWho1, "", eFromWho1, "", "PDF未產生，盡速處理");
}
}
public void Begin(string sCheckWhere)
{
string sPgSN = DateTime.Now.ToString("yyyyMMddHHmmssfff");
foreach (string OkFName in System.IO.Directory.GetFileSystemEntries(sCheckWhere, "*.*"))
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, OkFName, "文字檔資料內容有誤!導致轉檔失敗!請盡速檢查文字檔內容!", "", 51);
}
}
}
public string HelloWorld(string sHelloWorldY)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
// query.GoLogsAll("HelloWorldY", "HelloWorldY已被觸發了喔!!", Convert.ToString(sHelloWorldY), "", "", 1);
query.GoLogsAll("HelloWorldY", "HelloWorldY已被觸發了喔!!", "", "", "", 1);
}
try
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.GoLogsAll("HelloWorldY", "HelloWorldY已被觸發了喔!!", Convert.ToString(sHelloWorldY), "", "", 1);
}
}
catch (Exception ex)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
query.GoLogsAll("HelloWorldY", "HelloWorldY已被觸發了喔!!", ex.ToString(), "", "", 1);
}
}
string a123;
if (sHelloWorldY == null)
{
a123 = "GG";
}
else
{
a123 = "YY";
}
return(a123);
// return sHelloWorldY;
//return "已被觸發了";
}
private DataTable GetLogsAllData(string Condition)
{
DataTable GetLogsAllDataGo = null;
DataView dvResult = null;
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
dvResult = query.Kind1SelectTbl2("ProgramKey,ProgramState,ProgramTime,ProgramMotion,ProgramName", "LogsAll", Condition, "ProgramTime", "Desc");
}
if (dvResult != null)
{
GetLogsAllDataGo = dvResult.Table;
labCount.Text = dvResult.Count.ToString() + "筆";
}
else
{
labCount.Text = "";
}
return(GetLogsAllDataGo);
}
//protected void GoXmlC0401(string GoXML, string sPgSN)
protected void GoXml(string sKind0up)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
string sKind0upAll = sKind0up + "H";
//DataView dvResult1 = query.Kind1SelectTbl2("AC0401SN,MInvoiceNumber", "AC0401", "ACKind='" + GoXML + "' And ExXmlYN='N'", "MInvoiceNumber", "");
//DataView dvResult1 = query.Kind1SelectTbl2("C0401SN,MInvoiceNumber", "C0401H", "ACKind='" + sKind0upAll + "' And ExXmlYN='N'", "MInvoiceNumber", "");
DataView dvResult1 = query.Kind1SelectTbl2("C0401SN,MInvoiceNumber", "C0401H", "ExXmlYN='N' ", "MInvoiceNumber", "");
if (dvResult1 != null)
{
for (int i = 0; i < dvResult1.Count; i++)
{
string sPgSN = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string C0401SN = Convert.ToString(dvResult1.Table.Rows[i][0]);
string MInvoiceNumber = Convert.ToString(dvResult1.Table.Rows[i][1]);
//開始生成XML
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, "[生成XML發票號碼:]" + MInvoiceNumber, "", "", 1);
//bool ExAC0401ok = query.ExAC0401(AC0401SN, MInvoiceNumber, GoXML, sPgSN);
bool ExXmlC0401ok = query.ExXmlC0401(C0401SN, MInvoiceNumber, sKind0up, sKind0upAll, sPgSN);
Console.WriteLine(ExXmlC0401ok);
if (ExXmlC0401ok == true)
{
//最後要更新 C0401H/ExXmlYN & ExXmlTime
System.Collections.Hashtable data = new System.Collections.Hashtable();
data["ExXmlYN"] = "Y";
//data["ExXmlTime"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
query.UpdateData("C0401H", data, "C0401SN", C0401SN);
}
//結束生成XML
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, "[生成XML發票號碼:]" + MInvoiceNumber, "", "", 2);
}
}
}
}
public void Begin(string MAllowanceNumber = null)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
//MPDFaw.exe 1706160010 //生成PDF MAllowanceNumber
////MPDFaw.exe ALL //全部生成PDF //ExPdfYN=N
System.Data.DataView dvResultALLA = query.Kind1SelectTbl2("MAllowanceNumber", "B0401H", "(ExPdfYN IS NULL) OR (ExPdfYN <> 'Y')", "", "");
//Console.WriteLine(MAllowanceNumber);
if (dvResultALLA != null)
{
if (dvResultALLA.Count > 0)
{
for (int i = 0; i < dvResultALLA.Count; i++)
{
//B2B折讓證明單 B0401
query.CallMkPDFaw(Convert.ToString(dvResultALLA.Table.Rows[i][0]));
}
}
}
System.Data.DataView dvResultALLC = query.Kind1SelectTbl2("MAllowanceNumber", "D0401H", "(ExPdfYN IS NULL) OR (ExPdfYN <> 'Y')", "", "");
if (dvResultALLC != null)
{
if (dvResultALLC.Count > 0)
{
for (int i = 0; i < dvResultALLC.Count; i++)
{
//B2C折讓證明單 D0401
query.CallMkPDFaw(Convert.ToString(dvResultALLC.Table.Rows[i][0]));
}
}
}
//}
}
}
public void BeginByNumberList(string identityKey)
{
string sPgSN = DateTime.Now.ToString("yyyyMMddHHmmssfff");
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
var b0401List = new List <string>();
var queryData = query.Kind1SelectTbl2("*", "PRINT_TEMP", " PRINT_METHOD='B0401H' and IDEN_KEY = '" + identityKey + "'", "", "");
if (queryData != null)
{
var rows = queryData.Table.Rows;
for (int i = 0; i < rows.Count; i++)
{
b0401List.Add(rows[i]["PRINT_EINV_NUM"].ToString());
}
}
if (b0401List.Count > 0)
{
Console.WriteLine("B0401 產生PDF 開始.");
}
int bIndex = 0;
//B2B折讓證明單 B0401
foreach (var b0401 in b0401List)
{
bIndex = b0401List.IndexOf(b0401) + 1;
Console.WriteLine(string.Format("B0401 產生PDF 第{0}筆 {1} 折讓證明單開始.", bIndex, b0401));
query.CallMkPDFaw(b0401);
Hashtable hashTable = new Hashtable();
hashTable["MAKE_FILE_DATE"] = DateTime.UtcNow;
query.UpdateData2("PRINT_TEMP", hashTable, "IDEN_KEY = '" + identityKey + "' AND PRINT_EINV_NUM = " + "'" + b0401 + "'");
Console.WriteLine(string.Format("B0401 產生PDF 第{0}筆 {1} 折讓證明單結束.", bIndex, b0401));
}
if (b0401List.Count > 0)
{
Console.WriteLine("B0401 PDF 產生結束 共計:" + bIndex + "筆");
}
queryData = new DataView();
var d0401List = new List <string>();
queryData = query.Kind1SelectTbl2("*", "PRINT_TEMP", " PRINT_METHOD='D0401H' and IDEN_KEY = '" + identityKey + "'", "", "");
if (queryData != null)
{
var rows = queryData.Table.Rows;
for (int i = 0; i < rows.Count; i++)
{
d0401List.Add(rows[i]["PRINT_EINV_NUM"].ToString());
}
}
if (d0401List.Count > 0)
{
Console.WriteLine("D0401 產生PDF 開始.");
}
int dIndex = 0;
//B2C折讓證明單 D0401H
foreach (var d0401 in d0401List)
{
dIndex = d0401List.IndexOf(d0401) + 1;
Console.WriteLine(string.Format("D0401 產生PDF 第{0}筆 {1} 折讓證明單開始.", dIndex, d0401));
query.CallMkPDFaw(d0401);
Hashtable hashTable = new Hashtable();
hashTable["MAKE_FILE_DATE"] = DateTime.UtcNow;
query.UpdateData2("PRINT_TEMP", hashTable, "IDEN_KEY = '" + identityKey + "' AND PRINT_EINV_NUM = " + "'" + d0401 + "'");
Console.WriteLine(string.Format("D0401 產生PDF 第{0}筆 {1} 折讓證明單結束.", dIndex, d0401));
}
if (d0401List.Count > 0)
{
Console.WriteLine("D0401 PDF 產生結束 共計:" + dIndex + "筆");
}
}
}
public void Begin(string sKind0)
{
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{ query.CreateDIRok(""); }
}
public void BeginByNumberList(string identityKey)
{
string sPgSN = DateTime.Now.ToString("yyyyMMddHHmmssfff");
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
var a0401List = new List <string>();
var queryData = query.Kind1SelectTbl2("*", "PRINT_TEMP", " PRINT_METHOD='A0401H' and IDEN_KEY = '" + identityKey + "'", "", "");
if (queryData != null)
{
var rows = queryData.Table.Rows;
for (int i = 0; i < rows.Count; i++)
{
a0401List.Add(rows[i]["PRINT_EINV_NUM"].ToString());
}
}
#region 生成B2B 發票PDF
if (a0401List.Count > 0)
{
Console.WriteLine("A0401 產生PDF 開始.");
}
int aIndex = 0;
foreach (var a0401 in a0401List)
{
aIndex = a0401List.IndexOf(a0401) + 1;
if (a0401.Trim().Length == 10)
{
try
{
Console.WriteLine(string.Format("A0401 產生PDF 第{0}筆 {1} 證明聯開始.", aIndex, a0401));
//發票證明聯
query.CallMkPDFinvoAll(a0401, "1");
Console.WriteLine(string.Format("A0401 產生PDF 第{0}筆 {1} 證明聯結束.", aIndex, a0401));
Console.WriteLine(string.Format("A0401 產生PDF 第{0}筆 {1} 證明聯補印開始.", aIndex, a0401));
//發票證明聯補印
query.CallMkPDFinvoAll(a0401, "3");
Console.WriteLine(string.Format("A0401 產生PDF 第{0}筆 {1} 證明聯補印結束.", aIndex, a0401));
}
catch (Exception ex)
{
Console.WriteLine("A0401 產生PDF發生錯誤 第" + aIndex + "筆： " + ex.Message);
throw ex;
}
//格式二
//query.CallMkPDFinvoAll2(Convert.ToString(dvResultALLA.Table.Rows[i][0]));
}
else
{
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, a0401, "[發票號碼不是10碼!!不生成PDF]", "", 41);
}
}
if (a0401List.Count > 0)
{
Console.WriteLine("A0401 PDF 產生結束 共計:" + aIndex + "筆");
}
foreach (var inv in a0401List)
{
Hashtable hashTable = new Hashtable();
hashTable["MAKE_FILE_DATE"] = DateTime.UtcNow;
query.UpdateData2("PRINT_TEMP", hashTable, "IDEN_KEY = '" + identityKey + "' AND PRINT_EINV_NUM = " + "'" + inv + "'");
}
#endregion 生成B2B 發票PDF
#region 生成B2C 發票PDF
queryData = new DataView();
var c0401List = new List <string>();
queryData = query.Kind1SelectTbl2("*", "PRINT_TEMP", " PRINT_METHOD='C0401H' and IDEN_KEY = '" + identityKey + "'", "", "");
if (queryData != null)
{
var rows = queryData.Table.Rows;
for (int i = 0; i < rows.Count; i++)
{
c0401List.Add(rows[i]["PRINT_EINV_NUM"].ToString());
}
}
if (c0401List.Count > 0)
{
Console.WriteLine("C0401 產生PDF 開始.");
}
int cIndex = 0;
foreach (var c0401 in c0401List)
{
cIndex = c0401List.IndexOf(c0401) + 1;
if (c0401.Trim().Length == 10)
{
try
{
//發票證明聯
Console.WriteLine(string.Format("C0401 產生PDF 第{0}筆 {1} 證明聯開始.", cIndex, c0401));
query.CallMkPDFinvo(c0401, "1");
Console.WriteLine(string.Format("C0401 產生PDF 第{0}筆 {1} 證明聯開始.", cIndex, c0401));
Console.WriteLine(string.Format("C0401 產生PDF 第{0}筆 {1} 證明聯補印開始.", cIndex, c0401));
//發票證明聯補印
query.CallMkPDFinvo(c0401, "3");
Console.WriteLine(string.Format("C0401 產生PDF 第{0}筆 {1} 證明聯補印結束.", cIndex, c0401));
//格式二
//query.CallMkPDFinvoAll2(Convert.ToString(dvResultALLA.Table.Rows[i][0]));
}
catch (Exception ex)
{
Console.WriteLine("A0401 產生PDF發生錯誤 第" + aIndex + "筆： " + ex.Message);
throw ex;
}
}
else
{
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, c0401, "[發票號碼不是10碼!!不生成PDF]", "", 41);
}
}
if (c0401List.Count > 0)
{
Console.WriteLine("C0401 PDF 產生結束 共計:" + aIndex + "筆");
}
foreach (var inv in c0401List)
{
Hashtable hashTable = new Hashtable();
hashTable["MAKE_FILE_DATE"] = DateTime.UtcNow;
query.UpdateData2("PRINT_TEMP", hashTable, "IDEN_KEY = '" + identityKey + "' AND PRINT_EINV_NUM = " + "'" + inv + "'");
}
#endregion 生成B2C 發票PDF
}
}
public void Begin(string sMInvoiceNumber = null)
{
string sPgSN = DateTime.Now.ToString("yyyyMMddHHmmssfff");
using (NSysDB.NTSQL.SQL1 query = new NSysDB.NTSQL.SQL1())
{
////MkPDF.exe ALL //全部生成PDF //ExPdfYN=N
#region 生成B2B 發票PDF
System.Data.DataView dvResultALLA = query.Kind1SelectTbl2("MInvoiceNumber", "A0401H", "(ExPdfYN IS NULL) OR (ExPdfYN <> 'Y')", "", "");
if (dvResultALLA != null)
{
if (dvResultALLA.Count > 0)
{
for (int i = 0; i < dvResultALLA.Count; i++)
{
if (Convert.ToString(dvResultALLA.Table.Rows[i][0]).Trim().Length == 10)
{
//發票證明聯
query.CallMkPDFinvoAll(Convert.ToString(dvResultALLA.Table.Rows[i][0]), "1");
//發票證明聯補印
query.CallMkPDFinvoAll(Convert.ToString(dvResultALLA.Table.Rows[i][0]), "3");
//格式二
//query.CallMkPDFinvoAll2(Convert.ToString(dvResultALLA.Table.Rows[i][0]));
}
else
{
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, Convert.ToString(dvResultALLA.Table.Rows[i][0]), "[發票號碼不是10馬!!不生成PDF]", "", 41);
}
}
}
}
#endregion 生成B2B 發票PDF
#region 生成B2C 發票PDF
System.Data.DataView dvResultALLC = query.Kind1SelectTbl2("MInvoiceNumber", "C0401H", "(ExPdfYN IS NULL) OR (ExPdfYN <> 'Y')", "", "");
if (dvResultALLC != null)
{
if (dvResultALLC.Count > 0)
{
for (int i = 0; i < dvResultALLC.Count; i++)
{
if (Convert.ToString(dvResultALLC.Table.Rows[i][0]).Trim().Length == 10)
{
//發票證明聯
query.CallMkPDFinvo(Convert.ToString(dvResultALLC.Table.Rows[i][0]), "1");
//發票證明聯補印
query.CallMkPDFinvo(Convert.ToString(dvResultALLC.Table.Rows[i][0]), "3");
}
else
{
query.GoLogsAll(sPgSN, System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName, Convert.ToString(dvResultALLC.Table.Rows[i][0]), "[發票號碼不是10馬!!不生成PDF]", "", 41);
}
}
}
}
#endregion 生成B2C 發票PDF
}
}
