private IList <BillDailyIssue> BindIssue(bool AddNew)
{
List <BillDailyIssue> lis = new List <BillDailyIssue>();
BillDailyIssue Issue;
TextBox txtFlightTicketNum, txtOuterReferenceID, txtOwnerName, txtCost, txtInnerReferenceID, txtBankStatement;
//保存现有的gridview 数据
for (int i = 0; i < gvIssue.Rows.Count; i++)
{
if (gvIssue.Rows[i].Visible == false)
{
continue;
}
txtFlightTicketNum = (TextBox)gvIssue.Rows[i].FindControl("txtFlightTicketNum");
txtOuterReferenceID = (TextBox)gvIssue.Rows[i].FindControl("txtOuterReferenceID");
txtInnerReferenceID = (TextBox)gvIssue.Rows[i].FindControl("txtInnerReferenceID");
txtBankStatement = (TextBox)gvIssue.Rows[i].FindControl("txtBankStatement");
txtOwnerName = (TextBox)gvIssue.Rows[i].FindControl("txtOwnerName");
txtCost = (TextBox)gvIssue.Rows[i].FindControl("txtCost");
if (txtFlightTicketNum.Text.Trim() != "")
{
Issue = new BillDailyIssue();
Issue.IssueDate = DateTime.Parse(txtIssueDate.Text);
Issue.OwnerName = txtOwnerName.Text.Trim();
Issue.FlightTicketNum = txtFlightTicketNum.Text.Trim();
Issue.OuterReferenceID = txtOuterReferenceID.Text.Trim();
if (txtCost.Text != "")
{
Issue.Cost = decimal.Parse(txtCost.Text.Trim());
}
Issue.InnerReferenceID = txtInnerReferenceID.Text.Trim();
Issue.BankStatement = txtBankStatement.Text.Trim();
lis.Add(Issue);
}
}
//新增一行
if (AddNew)
{
Issue = new BillDailyIssue();
Issue.IssueDate = DateTime.Parse(txtIssueDate.Text);
Issue.OwnerName = "";
lis.Add(Issue);
}
return(lis);
}
/// <summary>
///
/// </summary>
/// <param name="filename"></param>
private void ExtractExcelData(string filename)
{
List <BillDailyIssue> lis = new List <BillDailyIssue>();
BillDailyIssue Deal;
FileStream file = new FileStream(filename, FileMode.Open);
HSSFWorkbook wb = new HSSFWorkbook(file);
HSSFSheet sht;
sht = wb.GetSheetAt(0); //取第一个sheet
//取行Excel的最大行数
int rowsCount = sht.PhysicalNumberOfRows;
DateTime IssueDate = sht.GetRow(1).GetCell(0).DateCellValue;//第2行第1列是出票日期
//第1行是header,不是数据,第3行开始
for (int i = 2; i < rowsCount; i++)
{
//如果内部订单号是空,跳过
if (sht.GetStringCellValue(i, "A") == "")
{
continue;
}
Deal = new BillDailyIssue();
Deal.FlightTicketNum = sht.GetStringCellValue(i, "A");
//外部amadeus订单号
Deal.OuterReferenceID = sht.GetStringCellValue(i, "B");
Deal.Cost = (decimal)sht.GetDoubleCellValue(i, "C");
Deal.OwnerName = sht.GetStringCellValue(i, "D");
Deal.InnerReferenceID = sht.GetStringCellValue(i, "E");
Deal.BankStatement = sht.GetStringCellValue(i, "F");
Deal.IssueDate = IssueDate;
lis.Add(Deal);
}
file.Close();
svr.SaveIssue(lis);
}
private IList<BillDailyIssue> BindIssue(bool AddNew)
{
List<BillDailyIssue> lis = new List<BillDailyIssue>();
BillDailyIssue Issue;
TextBox txtFlightTicketNum, txtOuterReferenceID, txtOwnerName, txtCost, txtInnerReferenceID,txtBankStatement;
//保存现有的gridview 数据
for (int i = 0; i < gvIssue.Rows.Count; i++)
{
if (gvIssue.Rows[i].Visible == false) continue;
txtFlightTicketNum = (TextBox)gvIssue.Rows[i].FindControl("txtFlightTicketNum");
txtOuterReferenceID = (TextBox)gvIssue.Rows[i].FindControl("txtOuterReferenceID");
txtInnerReferenceID = (TextBox)gvIssue.Rows[i].FindControl("txtInnerReferenceID");
txtBankStatement = (TextBox)gvIssue.Rows[i].FindControl("txtBankStatement");
txtOwnerName = (TextBox)gvIssue.Rows[i].FindControl("txtOwnerName");
txtCost = (TextBox)gvIssue.Rows[i].FindControl("txtCost");
if (txtFlightTicketNum.Text.Trim() != "")
{
Issue = new BillDailyIssue();
Issue.IssueDate = DateTime.Parse(txtIssueDate.Text);
Issue.OwnerName = txtOwnerName.Text.Trim();
Issue.FlightTicketNum = txtFlightTicketNum.Text.Trim();
Issue.OuterReferenceID = txtOuterReferenceID.Text.Trim();
if (txtCost.Text != "")
Issue.Cost = decimal.Parse(txtCost.Text.Trim());
Issue.InnerReferenceID = txtInnerReferenceID.Text.Trim();
Issue.BankStatement = txtBankStatement.Text.Trim();
lis.Add(Issue);
}
}
//新增一行
if (AddNew)
{
Issue = new BillDailyIssue();
Issue.IssueDate = DateTime.Parse(txtIssueDate.Text);
Issue.OwnerName = "";
lis.Add(Issue);
}
return lis;
}
/// <summary>
///
/// </summary>
/// <param name="filename"></param>
private void ExtractExcelData(string filename)
{
List<BillDailyIssue> lis = new List<BillDailyIssue>();
BillDailyIssue Deal;
FileStream file = new FileStream(filename, FileMode.Open);
HSSFWorkbook wb = new HSSFWorkbook(file);
HSSFSheet sht;
sht = wb.GetSheetAt(0); //取第一个sheet
//取行Excel的最大行数
int rowsCount = sht.PhysicalNumberOfRows;
DateTime IssueDate = sht.GetRow(1).GetCell(0).DateCellValue;//第2行第1列是出票日期
//第1行是header,不是数据,第3行开始
for (int i = 2; i < rowsCount; i++)
{
//如果内部订单号是空,跳过
if (sht.GetStringCellValue(i, "A") == "")
continue;
Deal = new BillDailyIssue();
Deal.FlightTicketNum = sht.GetStringCellValue(i, "A");
//外部amadeus订单号
Deal.OuterReferenceID = sht.GetStringCellValue(i, "B");
Deal.Cost = (decimal)sht.GetDoubleCellValue(i, "C");
Deal.OwnerName = sht.GetStringCellValue(i, "D");
Deal.InnerReferenceID = sht.GetStringCellValue(i, "E");
Deal.BankStatement = sht.GetStringCellValue(i, "F");
Deal.IssueDate = IssueDate;
lis.Add(Deal);
}
file.Close();
svr.SaveIssue(lis);
}
