public static string getCardNumberFromEDC(string excelRoute, string pwd, string storeCaseNumber, string unKnowCardNumber, string approvalCode, string money)
{
string result_cardNumberFromEDC = "null";
ExcelTool e1 = new ExcelTool();
e1.openExcel(excelRoute, pwd);
e1.selectSheet(DateTime.Now.ToString("MMdd"));
tmp_stroeCaseNoCol = 8; //商店代號
tmp_cardNumberCol = 7; //卡號
tmp_approveCol = 14; //授權碼
tmp_moneyCol = 18; //金額
int lastRow = e1.getLastRow();
for (int i = 2; i <= lastRow; i++)
{
string excel_unKonwCardNumber;
string excel_storeCaseNumber = e1.getCellValue(i, tmp_stroeCaseNoCol);
string excel_cardNumber = e1.getCellValue(i, tmp_cardNumberCol);
string excel_approvel = e1.getCellValue(i, tmp_approveCol);
string excel_money = e1.getDoubleCellValue(i, tmp_moneyCol).ToString();
excel_unKonwCardNumber = excel_cardNumber.Substring(0, 6) + "XXXXXX" + excel_cardNumber.Substring(12, 4);
if ("822" + storeCaseNumber == excel_storeCaseNumber && unKnowCardNumber == excel_unKonwCardNumber && approvalCode == excel_approvel && (money == excel_money || "-" + money == excel_money))
{
result_cardNumberFromEDC = excel_cardNumber;
break;
}
}
e1.closeExcel();
return(result_cardNumberFromEDC);
}
public static string getCardNumner(string excelRoute, string pwd, string unKnowCardNumber, string approvalCode, string money)
{
string result_cardNumber = "null";
bool haveThisCard = false;
ExcelTool e1 = new ExcelTool();
e1.openExcel(excelRoute, pwd);
e1.selectSheet("Sheet1");
tmp_stroeCaseNoCol = e1.findValueColumn("A1", "S1", "商店代號");
tmp_stroeNameCol = e1.findValueColumn("A1", "S1", "商店名稱");
tmp_accountDateCol = e1.findValueColumn("A1", "S1", "帳務日期");
tmp_unKnowCardCol = e1.findValueColumn("A1", "S1", "卡號前6後4碼");
tmp_cardNumberCol = e1.findValueColumn("A1", "S1", "卡號");
tmp_tradeCaseNoCol = e1.findValueColumn("A1", "S1", "交易碼");
tmp_transationDateCol = e1.findValueColumn("A1", "S1", "交易日期");
tmp_moneyCol = e1.findValueColumn("A1", "S1", "交易金額");
tmp_approveCol = e1.findValueColumn("A1", "S1", "授權碼");
var tempIndex_List = e1.findConditionIndex(unKnowCardNumber, tmp_unKnowCardCol);
foreach (int i in tempIndex_List)
{
string excel_unKonwCardNumber = e1.getCellValue(i, tmp_unKnowCardCol);
string excel_approvel = e1.getCellValue(i, tmp_approveCol);
string excel_money = System.Convert.ToString(e1.getDoubleCellValue(i, tmp_moneyCol));
if (unKnowCardNumber == excel_unKonwCardNumber && approvalCode == excel_approvel && (money == excel_money || "-" + money == excel_money))
{
result_cardNumber = e1.getCellValue(i, tmp_cardNumberCol);
haveThisCard = true;
break;
}
}
if (haveThisCard)
{
foreach (int i in tempIndex_List)
{
string excel_unKonwCardNumber = e1.getCellValue(i, tmp_unKnowCardCol);
string excel_approvel = e1.getCellValue(i, tmp_approveCol);
string excel_money = System.Convert.ToString(e1.getDoubleCellValue(i, tmp_moneyCol));
if (unKnowCardNumber == excel_unKonwCardNumber && (money == excel_money || "-" + money == excel_money))
{
var c = new customers();
c.storeCaseNo = e1.getCellValue(i, tmp_stroeCaseNoCol);
c.storeName = e1.getCellValue(i, tmp_stroeNameCol);
c.accountDate = e1.getDoubleCellValue(i, tmp_accountDateCol).ToString();
c.cardNumber = e1.getCellValue(i, tmp_cardNumberCol);
c.tradeCaseNo = e1.getCellValue(i, tmp_tradeCaseNoCol);
c.transationDate = e1.getCellValue(i, tmp_transationDateCol);
c.tradeMoney = e1.getDoubleCellValue(i, tmp_moneyCol).ToString();
c.approvalCaseNo = e1.getCellValue(i, tmp_approveCol);
tempStructureList.Add(c);
}
}
}
e1.closeExcel();
return(result_cardNumber);
}
