public IHttpActionResult AddLinkMailboxQuery([FromBody] JObject value)
{
int uid = (int)value["Uid"];
int countryId = (int)value["CountryId"];
string reviewId = value["ReviewId"].ToString();
decimal price = (decimal)value["Price"];
LinkMailboxQuery mailboxQuery = new LinkMailboxQuery
{
UserId = uid,
State = 1,
ReviewLink = reviewId,
SubTime = DateTime.Now,
Price = price,
CountryId = countryId
};
entities.LinkMailboxQuery.Add(mailboxQuery);
int result = entities.SaveChanges();
if (result > 0)
{
return(Ok(Respone.Success("提交成功")));
}
else
{
return(Ok(Respone.No("发生了点问题，请稍后再试")));
}
}
public IHttpActionResult ExcelLinkMailboxQuery()
{
try
{
string uid = HttpContext.Current.Session["UserId"].ToString();
int s = 0;
int sum = 0;
var pric = entities.NavBySubmeun.Where(e => e.ModularId == 12).Select(e => e.Price).FirstOrDefault();
var filelist = HttpContext.Current.Request.Files;
var bad = new List <ExcelLinkMailboxQueryModel>();
var linkMail = new List <LinkMailboxQuery>();
if (filelist.Count > 0)
{
for (var i = 0; i < filelist.Count; i++)
{
var file = filelist[i];
var dataTable = ExcelHelp.ExcelToTableForXLSX(file.InputStream); //excel转成datatable
bad = dataTable.ToDataList <ExcelLinkMailboxQueryModel>(); //datatable转成list
}
}
sum = bad.Count();
foreach (var item in bad)
{
int cname = entities.Country.Where(e => e.CountryName == item.国家.Trim()).Select(e => e.Id).FirstOrDefault();
if (cname > 0 && uid != null)
{
var box = new LinkMailboxQuery
{
UserId = Convert.ToInt32(uid),
State = 1,
Price = pric,
ReviewLink = item.Review,
CountryId = cname,
SubTime = DateTime.Now
};
linkMail.Add(box);
s++;
}
else
{
return(Ok(Respone.No("EXCEL数据有误")));
}
}
if (s == sum)
{
var dt = linkMail.ToDataTable();
if (string.IsNullOrWhiteSpace(dt.TableName))
{
dt.TableName = "LinkMailboxQuery";
}
SqlBulkCopyHelper.SaveTable(dt); //批量插入
var list = new { succeed = linkMail.Take(100).ToList() };
return(Ok(Respone.Success("导入成功")));
}
else
{
return(Ok(Respone.No("导入失败")));
}
}
catch (Exception ex)
{
return(Ok(ex.ToString()));
}
}
