public async Task<bool> UpdateDDPalReportAsync(string FilePath, int AccountNo, bool bSuccess)
{
bool bRet = await Task.Run(() =>
{
try
{
Application excel = new Application();
excel.Visible = false;
Workbook wb = excel.Workbooks.Open(FilePath);
Worksheet ws = wb.ActiveSheet as Worksheet;
int nRow = AccountNo + 1;
int nAccountIndex = AccountNo - 1;
for (int i = 1; i < 8; i++)
{
((Range)(ws.Cells[nRow, i])).HorizontalAlignment = XlHAlign.xlHAlignLeft;
}
ws.Cells[nRow, 1] = aJDAccount[nAccountIndex].UserName;
ws.Cells[nRow, 2] = aJDAccount[nAccountIndex].Password;
if (bSuccess)
{
ws.Cells[nRow, 3] = OrderNo;
ws.Cells[nRow, 4] = SinglePalCount;
ws.Cells[nRow, 5] = OrderMoney;
ws.Cells[nRow, 6] = Settings.Default.Remark;
ws.Cells[nRow, 7] = "否";
}
else
{
((Range)(ws.Cells[nRow, 1])).Interior.ColorIndex = 3;
((Range)(ws.Cells[nRow, 2])).Interior.ColorIndex = 3;
}
wb.Save();
if (wb != null)
wb.Close();
if (excel != null)
{
excel.Quit();
App.KillExcel(excel);
excel = null;
}
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message, Globals.JD_CAPTION);
Trace.TraceInformation("Rudy Exception=> UpdateDDPalReportAsync： " + e.Source + ";" + e.Message);
return false;
}
return true;
}).ConfigureAwait(false);
return bRet;
}
public async Task<bool> SetAddressAccoutInfoAsync(string FilePath)
{
bool bRet = await Task.Run(() =>
{
if (aAccountInfo != null)
aAccountInfo.Clear();
try
{
Application excel = new Application();
excel.Visible = false;
Workbook wb = excel.Workbooks.Open(FilePath);
Worksheet ws = wb.ActiveSheet as Worksheet;
int nRowCount = ws.UsedRange.Cells.Rows.Count;//get the used rows count.
AccountInfo infoTemp;
for (int i = 2; i <= nRowCount; i++)
{
infoTemp.Account = ((Range)ws.Cells[i, 1]).Text;
infoTemp.Password = ((Range)ws.Cells[i, 2]).Text;
infoTemp.FullName = ((Range)ws.Cells[i, 3]).Text;
infoTemp.Mobile = ((Range)ws.Cells[i, 4]).Text;
infoTemp.Province = ((Range)ws.Cells[i, 5]).Text;
infoTemp.City = ((Range)ws.Cells[i, 6]).Text;
infoTemp.County = ((Range)ws.Cells[i, 7]).Text;
infoTemp.Town = ((Range)ws.Cells[i, 8]).Text;
infoTemp.DetailAddress = ((Range)ws.Cells[i, 9]).Text;
aAccountInfo.Add(infoTemp);
}
if (wb != null)
wb.Close();
if (excel != null)
{
excel.Quit();
App.KillExcel(excel);
excel = null;
}
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message, Globals.JD_CAPTION);
Trace.TraceInformation("Rudy Exception=> SetAddressAccoutInfoAsync： " + e.Source + ";" + e.Message);
return false;
}
return true;
}).ConfigureAwait(false);
return bRet;
}
public async Task<bool> CreateDDPalReportAsync(string FilePath)
{
Trace.TraceInformation("Rudy Trace =>CreateDDPalReportAsync: Report Path = " + FilePath);
bool bRet = await Task.Run(() =>
{
try
{
Application excel = new Application();
excel.Visible = false;
Workbook wb = excel.Workbooks.Add();
Worksheet ws = wb.Sheets[1] as Worksheet;
ws.Cells[1, 1] = "账户";
ws.Cells[1, 2] = "密码";
ws.Cells[1, 3] = "订单编号";
ws.Cells[1, 4] = "数量";
ws.Cells[1, 5] = "金额(元)";
ws.Cells[1, 6] = "备注";
ws.Cells[1, 7] = "已评论";
for (int i = 1; i < 8; i++)
{
((Range)(ws.Cells[1, i])).HorizontalAlignment = XlHAlign.xlHAlignLeft;
((Range)(ws.Cells[1, i])).ColumnWidth = 12;
}
wb.SaveAs(FilePath);
if (wb != null)
wb.Close();
if (excel != null)
{
excel.Quit();
App.KillExcel(excel);
excel = null;
}
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message, Globals.JD_CAPTION);
Trace.TraceInformation("Rudy Exception=> CreateDDPalReportAsync： " + e.Source + ";" + e.Message);
return false;
}
return true;
}).ConfigureAwait(false);
return bRet;
}
