/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { try { var member = new LHCustomerPrice { FCode = txtFCode.Text, FItemCode = txtFItemCode.Text, FCompanyId = CurrentUser.AccountComId, FFlag = 1, FMemo = txtFMemo.Text, FPrice = Convert.ToDecimal(txtFPrice.Text.Trim()), FBeginDate = dateBegin.SelectedDate, FCreateBy = CurrentUser.AccountName, FCreateDate = DateTime.Now }; return(CustomerPriceService.Add(member)); } catch (Exception ex) { throw; } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { var errorRow = -1; try { using (var ts = new TransactionScope()) { var data = ViewState["dtData"] as DataTable; if (data == null) { return; } var stringBuilder = new StringBuilder(); for (int i = 0; i < data.Rows.Count; i++) { errorRow = i + 1; var item = new LHCustomerPrice { FCode = data.Rows[i]["客户代码"].ToString(), FItemCode = data.Rows[i]["商品代码"].ToString(), FPrice = Convert.ToDecimal(data.Rows[i]["发货单价"]), FCompanyId = CurrentUser.AccountComId, FBeginDate = Convert.ToDateTime(data.Rows[i]["执行开始时间"]), FFlag = 1 }; CustomerPriceService.AddEntity(item); } //写入数据库 CustomerPriceService.SaveChanges(); ts.Complete(); Alert.Show("引入完成。", MessageBoxIcon.Information); } } catch (Exception ex) { Alert.Show(string.Format(@"引入失败,请排查模版内容是否完善,出错定位行:{0} ", errorRow), MessageBoxIcon.Information); } }