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