/// <summary>
/// 批量插入记录,并扣减库存??
/// </summary>
public void BatInsert(int cartID, DataTable ptDT)
{
if (ptDT.Rows.Count < 1)
{
return;
}
DataTable dt = codeBll.SelStruct();
string[] ignores = "id,cartid".Split(',');
foreach (DataRow ptDR in ptDT.Rows)
{
DataRow dr = dt.NewRow();
foreach (DataColumn dc in dt.Columns)
{
string cname = dc.ColumnName.ToLower();
if (cname.Equals("id") || cname.Equals("cartid"))
{
continue;
}
if (!ptDT.Columns.Contains(cname))
{
continue;
}
dr[cname] = ptDR[cname];
}
dr["CartID"] = cartID;
dr["Remind"] = "";
codeBll.Insert(dr);
}
}
public IActionResult Import_Submit()
{
var file = Request.Form.Files["file_up"];
if (file == null)
{
return(WriteErr("未指定文件"));
}
if (file.Length < 100)
{
return(WriteErr("文件为空"));
}
string ext = Path.GetExtension(file.FileName).ToLower();
if (ext != ".xlsx")
{
return(WriteErr("只允许上传xlsx文件"));
}
//-------------------------
DataTable excelDT = Import_Logical.Excel_ToDT(XMLPath, file.OpenReadStream());
B_CodeModel codeBll = new B_CodeModel(excelDT.TableName);
DataTable modelDT = codeBll.SelStruct();
//将数据直接写入数据库,或将其转换为模型再写入
foreach (DataRow dr in excelDT.Rows)
{
//将第一列作为主键忽略掉
codeBll.Insert(dr, modelDT.Columns[0].ColumnName);
}
return(WriteOK("数据导入完成"));
}
protected void Page_Load(object sender, EventArgs e)
{
promoStruct = promoBll.SelStruct();
if (!IsPostBack)
{
MyBind();
Call.SetBreadCrumb(Master, "<li><a href='AdminManage.aspx'>用户管理</a></li><li><a href='UserManage.aspx'>会员管理</a></li><li><a href='" + Request.RawUrl + "'>推广佣金</a></li>");
}
}
public DataRow GetReaderFromModel(M_WX_APPID model)
{
DataTable dt = codeBll.SelStruct();
DataRow dr = dt.NewRow();
dr["Alias"] = model.Alias;
dr["APPID"] = model.APPID;
dr["Secret"] = model.Secret;
dr["StoreId"] = model.IsDefault;
dr["WxNo"] = model.WxNo;
dr["OrginID"] = model.OrginID;
dr["Pay_AccountID"] = model.Pay_AccountID;
dr["QRCode"] = model.QRCode;
return(dr);
}