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; }