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