/// <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 LHItems { FCode = data.Rows[i]["商品代码"].ToString(), FName = data.Rows[i]["商品名称"].ToString(), FSpec = data.Rows[i]["规格"].ToString(), FSpell = ChineseSpell.MakeSpellCode(data.Rows[i]["商品名称"].ToString(), "", SpellOptions.FirstLetterOnly).ToUpper(), //设置默认组号 FGroupNum = data.Rows[i]["商品代码"].ToString(), FUnit = data.Rows[i]["计量单位"].ToString(), FCateId = "2002", FSubCateId = "2002", FPurchasePrice = Convert.ToDecimal(data.Rows[i]["采购单价"]), FSalesPrice = Convert.ToDecimal(data.Rows[i]["发货单价"]), FMemo = data.Rows[i]["摘要"].ToString(), FCompanyId = CurrentUser.AccountComId, FFlag = 1 }; ItemsService.AddEntity(item); //ItemsService.Add(item); } //写入数据库 ItemsService.SaveChanges(); ts.Complete(); Alert.Show("引入完成。", MessageBoxIcon.Information); } } catch (Exception ex) { Alert.Show(string.Format(@"引入失败,请排查模版内容是否完善,出错定位行:{0} ", errorRow), MessageBoxIcon.Information); } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { int errorRow = -1; try { //using (TransactionScope ts = new TransactionScope()) { DataTable 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; if (!string.IsNullOrWhiteSpace(data.Rows[i][2].ToString())) { LHFactor item = new LHFactor { FCompanyCode = tbxFCustomer.Text, FBar = decimal.Parse(data.Rows[i][0].ToString()), FTemperature = decimal.Parse(data.Rows[i][1].ToString()), FDivisor = data.Rows[i][2].ToString(), }; ItemsService.AddEntity(item); } else { break; } } //写入数据库 ItemsService.SaveChanges(); //ts.Complete(); Alert.Show("引入完成。", MessageBoxIcon.Information); } } catch (DBConcurrencyException ex) { Alert.Show(string.Format(@"引入失败,请排查模版内容是否完善,出错定位行:{0} ", ex.Message), MessageBoxIcon.Information); } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { int errorRow = -1; try { //using (TransactionScope ts = new TransactionScope()) { DataTable 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; LHWaterSpace item = new LHWaterSpace { FCompanyCode = tbxFCustomer.Text, FGCode = data.Rows[i][1].ToString(), FChassisNo = data.Rows[i][2].ToString(), FM3 = decimal.Parse(data.Rows[i][3].ToString()), }; ItemsService.AddEntity(item); } //写入数据库 ItemsService.SaveChanges(); //ts.Complete(); Alert.Show("引入完成。", MessageBoxIcon.Information); } } catch (Exception ex) { Alert.Show(string.Format(@"引入失败,请排查模版内容是否完善,出错定位行:{0} ", ex.Message), MessageBoxIcon.Information); } }