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 + "筆");
}
}
}
