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;
}
protected override void ExecuteMethod()
{
var list = EpRep.GetDistEnterpriseList(Parameter.UserId);
List <string> titlelist = new List <string>();
titlelist.Add("企业编号");
titlelist.Add("企业名称");
titlelist.Add("共管账号");
titlelist.Add("分销账号");
titlelist.Add("账期");
titlelist.Add("差旅协议地址");
titlelist.Add("授信金额");
titlelist.Add("拒绝理由");
List <string> keylist = new List <string>();
keylist.Add("ID");
keylist.Add("EnterpriseName");
keylist.Add("AccountNumber");
keylist.Add("DistributionAccount");
keylist.Add("AccountPeriod");
keylist.Add("TravelServiceAgreementURL");
keylist.Add("CreditAmount");
keylist.Add("RefuseReason");
var filebytes = Excel.ExcelExport <EnterpriseTempoary>(list, titlelist, keylist);
Result.Data = Convert.ToBase64String(filebytes);
}
/// <summary>
/// 执行方法
/// </summary>
protected override void ExecuteMethod()
{
//导出Excel数据
var table = Excel.ExcelImport(file.OpenReadStream());
//去除表头
table.rows.Remove(table.rows.FirstOrDefault());
//组织批量数据库实体
List <EnterpriseStaff> DataList = new List <EnterpriseStaff>();
foreach (var item in table.rows)
{
byte i = 1;
byte p = 0;
if (!string.IsNullOrWhiteSpace(item.columns.ElementAt(0).ColumnValue))
{
var EnterpriseStaffModel = new EnterpriseStaff
{
EnterpriseId = Parameter.EnterpriseId,
StaffName = Convert(item.columns.ElementAt(0).ColumnValue),
PhoneNumber = Convert(item.columns.ElementAt(1).ColumnValue),
IdentificationNumber = Convert(item.columns.ElementAt(2).ColumnValue),
IsJob = TranIsJob(item.columns.ElementAt(3).ColumnValue.Trim()),
SubsidiaryDepartment = Convert(item.columns.ElementAt(4).ColumnValue),
JobPosition = Convert(item.columns.ElementAt(5).ColumnValue),
DocumentType = 1,
CreateTime = DateTime.Now,
ModifyTime = DateTime.Now,
Modifier = Parameter.UserId
};
DataList.Add(EnterpriseStaffModel);
}
}
//数据库批量插入
this.Result.Data = EpRep.AddStaffList(DataList);
}
