protected override void ExecuteMethod()
{
var table = Excel.ExcelImport(file.OpenReadStream());
var result = table.rows.Remove(table.rows.FirstOrDefault());
List <EnterpriseTempoary> datalist = new List <EnterpriseTempoary>();
foreach (var item in table.rows)
{
try
{
var EnterpriseTempoaryModel = new EnterpriseTempoary
{
ID = !String.IsNullOrEmpty(item.columns.ElementAt(0).ColumnValue) ? Convert.ToInt64(item.columns.ElementAt(0).ColumnValue) : 0,
EnterpriseName = item.columns.ElementAt(1).ColumnValue,
AccountNumber = item.columns.ElementAt(2).ColumnValue,
DistributionAccount = item.columns.ElementAt(3).ColumnValue,
AccountPeriod = item.columns.ElementAt(4).ColumnValue,
TravelServiceAgreementURL = item.columns.ElementAt(5).ColumnValue,
CreditAmount = !String.IsNullOrEmpty(item.columns.ElementAt(6).ColumnValue) ? Convert.ToDecimal(item.columns.ElementAt(6).ColumnValue) : 0,
RefuseReason = item.columns.ElementAt(7).ColumnValue
};
datalist.Add(EnterpriseTempoaryModel);
}
catch (Exception ex)
{
}
}
var sql_result = EpRep.UpdateEnterpriseTempoaryStatus(datalist);
Result.Data = sql_result;
}
/// <summary>
/// 执行方法
/// </summary>
protected override void ExecuteMethod()
{
var table = Excel.ExcelImport(file.OpenReadStream());
table.rows.Remove(table.rows.FirstOrDefault());
List <EnterpriseTempoary> DataList = new List <EnterpriseTempoary>();
foreach (var item in table.rows)
{
try
{
var EnterpriseTempoaryModel = new EnterpriseTempoary
{
EnterpriseName = item.columns.ElementAt(0).ColumnValue.Trim(),
AccountNumber = item.columns.ElementAt(1).ColumnValue.Trim(),
CreditAmount = Convert.ToDecimal(item.columns.ElementAt(2).ColumnValue),
DistributionAccount = item.columns.ElementAt(3).ColumnValue.Trim(),
AccountPeriod = item.columns.ElementAt(4).ColumnValue.Trim()
};
DataList.Add(EnterpriseTempoaryModel);
}
catch (Exception ex)
{
}
}
var result = EpRep.QuestSaveList(DataList, this.Parameter.UserId);
this.Result.Data = result;
}
