/// <summary>
/// 根据单号从数据库中删除单据的表头和内容
/// </summary>
/// <param name="billNum">单据号</param>
private bool DeleteBillByBillNum(string billNum)
{
//实例化数据适配器
using (var da = new v_material_inTableAdapter())
//取得数据库连接
using (var conn = da.Connection)
{
//打开数据库连接
conn.Open();
//事务
using (var tran = conn.BeginTransaction())
{
//设置事务
da.Transaction = tran;
try
{
//取得之前入仓单清单记录
var tab = da.GetDataByBillNum(billNum);
//检测是否存在数据
if (tab.Rows.Count >= 0)
{
//单据表头行、内容行、原料结存和待入仓数据适配器
using (var daHead = new t_material_in_headTableAdapter())
using (var daContent = new t_material_in_contentTableAdapter())
using (var daBalance = new t_material_balanceTableAdapter())
{
//设置连接对象
daHead.Connection = daContent.Connection = daBalance.Connection = tran.Connection;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
//遍历行执行删除各行的结存记录和写回待入仓记录
foreach (DataSetMaterialIn.v_material_inRow row in tab.Rows)
{
//执行扣减结存
if (!ydOperateMaterial.DecreaseMaterialBalance(
daBalance,
BillType.In,
row.supplier_name,
row.material_name,
row.price,
row.qty
))
{
return false;
}
}
//根据入仓单号删除全部入仓内容记录
if (daContent.DeleteByBillNum(billNum) <= 0)
{
throw new Exception("根据单号删除全部入仓内容记录失败！");
}
//根据入仓单号删除全部入仓表头记录
if (daHead.Delete(billNum) <= 0)
{
throw new Exception("根据单号删除全部入仓表头记录失败！");
}
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//抛出错误
throw new Exception("删除入仓单记录出现错误:\n" + ex.Message);
}
}
}
}
/// <summary>
/// 执行删除数据并处理相关数据一致性
/// </summary>
/// <param name="e">传入的带有数据的事件参数</param>
/// <returns></returns>
private bool DeleteData(ListViewDeleteEventArgs e)
{
//实例化数据适配器
using (var da = new v_material_inTableAdapter())
//取得数据库连接
using (var conn = da.Connection)
{
//打开数据库连接
conn.Open();
//事务
using (var tran = conn.BeginTransaction())
{
//设置事务
da.Transaction = tran;
try
{
//当前入仓单号
string billNum = e.Keys[0].ToString();
//当前行号
byte rowId = Convert.ToByte(e.Keys[1]);
//取得该条入仓单清单记录
var tab = da.GetDataByBillNumAndRowId(billNum, rowId);
//检测是否存在数据
if (tab.Rows.Count <= 0)
{
throw new Exception(string.Format("当前单据:\n单号:{0}\n行号:{1}\n已经被其他用户删除!", billNum, rowId));
}
//单据内容、原料结存适配器
using (var daContent = new t_material_in_contentTableAdapter())
using (var daBalance = new t_material_balanceTableAdapter())
{
//设置连接对象
daContent.Connection = daBalance.Connection = tran.Connection;
//设置事务
daContent.Transaction = daBalance.Transaction = tran;
//遍历行执行删除各行的结存记录
foreach (DataSetMaterialIn.v_material_inRow row in tab.Rows)
{
//执行扣减结存
if (!ydOperateMaterial.DecreaseMaterialBalance(
daBalance,
BillType.In,
row.supplier_name,
row.material_name,
row.price,
row.qty
))
{
return false;
}
}
//根据入仓单号和行号删除入仓记录
if (daContent.Delete(billNum, rowId) <= 0)
{
throw new Exception("根据单号删除内容记录失败！");
}
//检测当前入仓记录内容行数
int? iCount = (int?)daContent.CountByBillNum(billNum);
if (iCount.HasValue && iCount.Value <= 0)
{
//表头适配器
using (var daHead = new t_material_in_headTableAdapter())
{
//删除表头
if (daHead.Delete(billNum) <= 0)
{
throw new Exception("根据单号删除表头记录失败！");
}
}
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//抛出错误
throw new Exception("删除入仓单记录出现错误:\n" + ex.Message);
}
}
}
}
/// <summary>
/// 设置入仓单数据
/// </summary>
/// <param name="strBillNum">入仓单单号清单</param>
private void GetMaterialData(string strBillNum)
{
Int64 iBillNum;
var l = new List<string>();
if (strBillNum != null && strBillNum.Length > 0)
{
//分解单号
string[] billNums = strBillNum.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
//遍历
foreach (var billNum in billNums)
{
if (Int64.TryParse(billNum, out iBillNum))
{
l.Add(iBillNum.ToString());
}
}
}
if (l.Count <= 0)
{
Response.Write("未检测到传入正确的单据编号！");
return;
}
//修改标题
this.Title = "入仓单预览" + strBillNum;
//设置公司名称
if (Session["user_name"].ToString() == "yd")
{
strCompanyName = "某某某";
}
else
{
strCompanyName = "通宇";
}
//表头行各单元格css
cssClasses =
("rowidtdth,materialcodetdth,materialnametdth," +
"materialsizetdth,qtytdth,materialunittdth,pricetdth,amounttdth,remarktdth").Split(',');
//表头行各单元格显示的字符
showTexts =
"行号,物料代码,物料名称,规格,数量,单位,单价,金额,备注".Split(',');
//数据适配器
using (var daHead = new t_material_in_headTableAdapter())
using (var daContent = new t_material_in_contentTableAdapter())
using (var conn = daHead.Connection)
{
//设置数据库连接对象
daContent.Connection = conn;
//打开数据库连接
conn.Open();
//初始化表头表身
tabHead = new DataSetMaterialIn.t_material_in_headDataTable();
tabContent = new DataSetMaterialIn.t_material_in_contentDataTable();
//设置填充不清除之前数据
daHead.ClearBeforeFill = false;
daContent.ClearBeforeFill = false;
//遍历获取数据
foreach (var billNum in l)
{
//获取表头数据
daHead.FillDataByBillNum(tabHead, billNum);
//获取表身数据
daContent.FillDataByBillNum(tabContent, billNum);
}
}
}
/// <summary>
/// 根据输入的LOT格式来保存多条数据到数据库
/// </summary>
/// <param name="e">传入的带有数据的事件参数</param>
/// <returns></returns>
private bool InsertData(FormViewInsertEventArgs e)
{
//日期
DateTime billDate = Convert.ToDateTime(e.Values["bill_date"]);
//单号
string billNum = Convert.ToString(e.Values["bill_num"]);
//供应商代码
string supplierCode;
//供应商名称
string supplierName = Convert.ToString(e.Values["supplier_name"]);
//送货单号
string deliveryNum = Convert.ToString(e.Values["delivery_num"]);
//单据备注
string billRemark = Convert.ToString(e.Values["remark"]);
//录入员
string addPerson = e.Values["add_person"].ToString();
//录入时间
DateTime addTime = Convert.ToDateTime(e.Values["add_time"]);
//最后修改时间
DateTime lastChangeTime = Convert.ToDateTime(e.Values["last_change_time"]);
//数据适配器
//当前添加语句对象
//当前数据库连接
using (var daHead = new t_material_in_headTableAdapter())
using (var daContent = new t_material_in_contentTableAdapter())
using (var daBalance = new t_material_balanceTableAdapter())
using (var daSupplier = new t_material_supplierTableAdapter())
using (var daName = new t_material_nameTableAdapter())
using (var daPrice = new t_material_price_historyTableAdapter())
using (var conn = daHead.Connection)
{
//打开数据库连接
conn.Open();
//开启事务
using (var tran = conn.BeginTransaction())
{
//设置数据库连接对象
daContent.Connection = daBalance.Connection = daSupplier.Connection
= daName.Connection = daPrice.Connection = conn;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = daSupplier.Transaction
= daName.Transaction = daPrice.Transaction = tran;
//试运行
try
{
//执行更新到物料名称清单
UpdateToSupplierName(
daSupplier,
out supplierCode,
supplierName,
addPerson
);
//含有数据的行数
int iCountContent = 0;
//遍历子表执行保存
for (int iRow = 0; iRow < 10; iRow++)
{
//当前列号
var iCol = -1;
//子表各控件
var tr = tabDataListSon.Rows[iRow + 1];
var litRowId = (Literal)tr.Cells[++iCol].Controls[0];
var txtMaterialType = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialCode = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialName = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialSize = (TextBox)tr.Cells[++iCol].Controls[0];
var txtQty = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialUnit = (TextBox)tr.Cells[++iCol].Controls[0];
var txtPrice = (TextBox)tr.Cells[++iCol].Controls[0];
var txtRemark = (TextBox)tr.Cells[++iCol].Controls[0];
//取得数据
byte rowId = Convert.ToByte(litRowId.Text);
string materialType = txtMaterialType.Text;
string materialCode = txtMaterialCode.Text;
string materialName = txtMaterialName.Text;
string materialSize = txtMaterialSize.Text;
decimal qty = txtQty.Text.Trim().Length <= 0 ? 0m : decimal.Parse(txtQty.Text.Trim());
string materialUnit = txtMaterialUnit.Text;
decimal price = txtPrice.Text.Trim().Length <= 0 ? 0m : decimal.Parse(txtPrice.Text.Trim());
string remark = txtRemark.Text;
//存在数据才保存
if (materialName.Length > 0 && materialUnit.Length > 0 && qty > 0)
{
//执行更新到物料名称清单
UpdateToMaterialName(
daName,
materialType,
supplierCode,
supplierName,
ref materialCode,
materialName,
materialSize,
materialUnit,
price,
addPerson
);
//保存到原料结存清单
if (daBalance.InsertData(
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
qty,
materialUnit,
price,
remark,
addPerson,
false
) <= 0)
{
throw new Exception("保存到原料结存清单失败！");
}
//保存到单据内容清单
if (daContent.Insert(
billNum,
rowId,
materialType,
materialCode,
materialName,
materialSize,
qty,
materialUnit,
price,
remark
) <= 0)
{
throw new Exception("保存到单据内容清单失败！");
}
//保存到历史单价清单
if (daPrice.UpdateData(
price,
addPerson,
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
materialUnit
) <= 0)
{
//执行添加
if (daPrice.InsertData(
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
materialUnit,
price,
addPerson
) <= 0)
{
throw new Exception("保存到物料历史单价清单失败！");
}
}
//含有数据的行数计数
iCountContent++;
}
}
//保存表头
if (iCountContent > 0)
{
if (daHead.Insert(
billDate,
billNum,
supplierCode,
supplierName,
deliveryNum,
billRemark,
addPerson,
addTime,
lastChangeTime
) <= 0)
{
throw new Exception("保存到表头记录失败！");
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//非数字返回失败
throw new Exception(ex.Message);
}
}
}
}
/// <summary>
/// 执行删除数据并处理相关数据一致性
/// </summary>
/// <param name="e">传入的带有数据的事件参数</param>
/// <returns></returns>
private bool DeleteData(FormViewDeleteEventArgs e)
{
//当前单号
string billNum = Convert.ToString(e.Keys[0]);
//数据适配器
//当前数据库连接
//当前更新语句对象
using (var da = new v_material_inTableAdapter())
using (var conn = da.Connection)
{
//打开数据库连接
conn.Open();
//开启事务
using (var tran = conn.BeginTransaction())
{
//试运行
try
{
//设置事务
da.Transaction = tran;
//获取数据
var tab = da.GetDataByBillNum(billNum);
//检查是否获取到行
if (tab.Rows.Count == 0)
{
//显示失败
throw new Exception("当前记录已经被其他用户删除！");
}
//数据适配器
using (var daHead = new t_material_in_headTableAdapter())
using (var daContent = new t_material_in_contentTableAdapter())
using (var daBalance = new t_material_balanceTableAdapter())
{
//设置数据库连接
daHead.Connection = daContent.Connection = daBalance.Connection = conn;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
//将之前的单据内容写回
foreach (DataSetMaterialIn.v_material_inRow row in tab.Rows)
{
//从原料结存清单中扣除
if (!ydOperateMaterial.DecreaseMaterialBalance(
daBalance,
BillType.In,
row.material_type,
row.supplier_name,
row.material_name,
row.price,
row.qty
))
{
return false;
}
}
//从单据内容中删除
if (daContent.DeleteByBillNum(billNum) <= 0)
{
throw new Exception("根据单号删除内容记录失败！");
}
//从单据表头中删除
if (daHead.Delete(billNum) <= 0)
{
throw new Exception("根据单号删除表头记录失败！");
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//非数字返回失败
throw new Exception(ex.Message);
}
}
}
}
protected void fvMaterialInAdd_DataBound(object sender, EventArgs e)
{
//设置单据清单可见
tabDataListSon.Visible = true;
//清空入仓单内容清单
for (int i = 0; i < 10; i++)
{
//清空清单数据到控件
ClearBillContent(i);
}
//新增状态
switch (fvMaterialInAdd.CurrentMode)
{
//新增状态
case FormViewMode.Insert:
//当前单据日期文本框
var tb = (TextBox)fvMaterialInAdd.FindControl("txtBillDate");
if (tb != null)
{
//检查用户提供的单据日期参数标识
string strBillDate = Request["bdate"];
DateTime billDate;
if (strBillDate != null && strBillDate.Length > 0 &&
DateTime.TryParse(strBillDate, out billDate))
{
//设置默认单据日期为传入的日期
tb.Text = billDate.ToString("yyyy-MM-dd");
}
else
{
//设置默认单据日期为当前日期
tb.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
}
//当前单号文本框
tb = (TextBox)fvMaterialInAdd.FindControl("txtBillNum");
if (tb != null)
{
//户提供的单号参数标识
string strBillNum = Request["bnum"];
Int64 billNum;
if (strBillNum != null && strBillNum.Trim().Length >= 12 &&
Int64.TryParse(strBillNum, out billNum))
{
//设置默认单号为传入的单号加1
tb.Text = (billNum + 1).ToString();
}
else
{
//当前单号前缀字符串
string billNumPrefix = DateTime.Now.ToString("yyyyMMdd");
//数据适配器
using (var da = new t_material_in_headTableAdapter())
{
//获取已经使用的最大单号
string maxBillNum = da.GetMaxBillNumLikeBillNum(billNumPrefix + "%").ToString();
//检测取得的值
if (maxBillNum.Trim().Length < 12)
{
//执行转换
billNum = Int64.Parse(billNumPrefix + "0001");
//设置默认单号为传入的单号加1
tb.Text = billNum.ToString();
}
else
{
//执行转换
billNum = Int64.Parse(maxBillNum);
//设置默认单号为传入的单号加1
tb.Text = (billNum + 1).ToString();
}
}
}
}
//供应商代码文本框
tb = (TextBox)fvMaterialInAdd.FindControl("txtSupplierCode");
if (tb != null)
{
//检查用户提供的供应商代码参数标识
string supplierCode = Request["scode"];
if (supplierCode != null && supplierCode.Length > 0)
{
//设置默认供应商代码
tb.Text = supplierCode;
}
else
{
//设置默认供应商代码
tb.Text = string.Empty;
}
}
//供应商名称文本框
tb = (TextBox)fvMaterialInAdd.FindControl("txtSupplierName");
if (tb != null)
{
//检查用户提供的供应商名称参数标识
string supplierName = Request["sname"];
if (supplierName != null && supplierName.Length > 0)
{
//设置默认供应商名称
tb.Text = supplierName;
}
else
{
//设置默认供应商名称
tb.Text = string.Empty;
}
}
//送货单号文本框
tb = (TextBox)fvMaterialInAdd.FindControl("txtDeliveryNum");
if (tb != null)
{
//检查用户提供的送货单号参数标识
string deliveryNum = Request["dnum"];
if (deliveryNum != null && deliveryNum.Length > 0)
{
//设置默认送货单号
tb.Text = deliveryNum;
}
else
{
//设置默认送货单号
tb.Text = string.Empty;
}
}
break;
case FormViewMode.Edit:
case FormViewMode.ReadOnly:
//设置单据清单不可见
tabDataListSon.Visible = false;
//通过入仓单号获取数据清单
//取得传入的入仓单号
string billNum2 = Request["bnum"];
if (billNum2 != null && billNum2.Length > 0)
{
//获取清单
using (var daContent = new t_material_in_contentTableAdapter())
{
//获取数据
var tabContent = daContent.GetDataByBillNum(billNum2);
//检测是否找到数据
if (tabContent.Rows.Count > 0)
{
//设置单据清单可见
tabDataListSon.Visible = true;
//把内容写入页面
foreach (DataSetMaterialIn.t_material_in_contentRow row in tabContent.Rows)
{
//当前行号
int i = row.row_id - 1;
//写入清单数据到控件
SetBillContent(row, i);
}
}
}
}
break;
}
//当前物料代码文本框获取焦点
var tb2 = (TextBox)fvMaterialInAdd.FindControl("txtMaterialCode0");
if (tb2 != null)
{
//设置焦点
tb2.Focus();
}
}
/// <summary>
/// 根据输入的参数值来执行更新数据
/// </summary>
/// <param name="e">传入的带有数据的事件参数</param>
/// <returns></returns>
private bool UpdateData(FormViewUpdateEventArgs e)
{
//数据适配器
//当前添加语句对象
//当前数据库连接
using (var da = new v_material_inTableAdapter())
using (var conn = da.Connection)
{
//打开数据库连接
conn.Open();
//开启事务
using (var tran = conn.BeginTransaction())
{
//设置事务
da.Transaction = tran;
//试运行
try
{
//当前行单号
string billNum = Convert.ToString(e.Keys[0]);
//获取数据
using (var tab = da.GetDataByBillNum(billNum))
{
//检查是否获取到行
if (tab.Rows.Count == 0)
{
//显示失败
throw new Exception("当前记录已经被其他用户删除！");
}
//数据适配器
using (var daHead = new t_material_in_headTableAdapter())
using (var daContent = new t_material_in_contentTableAdapter())
using (var daBalance = new t_material_balanceTableAdapter())
using (var daName = new t_material_nameTableAdapter())
using (var daPrice = new t_material_price_historyTableAdapter())
{
//设置数据库连接
daHead.Connection = daContent.Connection = daBalance.Connection
= daName.Connection = daPrice.Connection = conn;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction
= daName.Transaction = daPrice.Transaction = tran;
//将之前的单据内容写回
foreach (DataSetMaterialIn.v_material_inRow row in tab.Rows)
{
//从原料结存清单中扣除
if (!ydOperateMaterial.DecreaseMaterialBalance(
daBalance,
BillType.In,
row.material_type,
row.supplier_name,
row.material_name,
row.price,
row.qty
))
{
return false;
}
}
//从单据内容中删除
if (daContent.DeleteByBillNum(billNum) <= 0)
{
throw new Exception("从单据内容中删除失败！");
}
//从单据表头中删除
if (daHead.Delete(billNum) <= 0)
{
throw new Exception("从单据表头中删除失败！");
}
//日期
DateTime billDate = Convert.ToDateTime(e.NewValues["bill_date"]);
//供应商代码
string supplierCode = Convert.ToString(e.NewValues["supplier_code"]);
//供应商名称
string supplierName = Convert.ToString(e.NewValues["supplier_name"]);
//送货单号
string deliveryNum = Convert.ToString(e.NewValues["delivery_num"]);
//单据备注
string billRemark = Convert.ToString(e.NewValues["remark"]);
//录入员
string addPerson = e.NewValues["add_person"].ToString();
//录入时间
DateTime addTime = Convert.ToDateTime(e.NewValues["add_time"]);
//最后修改时间
DateTime lastChangeTime = Convert.ToDateTime(e.NewValues["last_change_time"]);
//含有数据的行数
int iCountContent = 0;
//遍历子表执行保存
for (int iRow = 0; iRow < 10; iRow++)
{
//列号
var iCol = -1;
//子表各控件
var tr = tabDataListSon.Rows[iRow + 1];
var litRowId = (Literal)tr.Cells[++iCol].Controls[0];
var txtMaterialType = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialCode = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialName = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialSize = (TextBox)tr.Cells[++iCol].Controls[0];
var txtQty = (TextBox)tr.Cells[++iCol].Controls[0];
var txtMaterialUnit = (TextBox)tr.Cells[++iCol].Controls[0];
var txtPrice = (TextBox)tr.Cells[++iCol].Controls[0];
var txtRemark = (TextBox)tr.Cells[++iCol].Controls[0];
//取得数据
byte rowId = Convert.ToByte(litRowId.Text);
string materialType = txtMaterialType.Text;
string materialCode = txtMaterialCode.Text;
string materialName = txtMaterialName.Text;
string materialSize = txtMaterialSize.Text;
decimal qty = txtQty.Text.Trim().Length <= 0 ? 0m : decimal.Parse(txtQty.Text.Trim());
string materialUnit = txtMaterialUnit.Text;
decimal price = txtPrice.Text.Trim().Length <= 0 ? 0m : decimal.Parse(txtPrice.Text.Trim());
string remark = txtRemark.Text;
//存在数据才保存
if (materialCode.Length > 0 && materialName.Length > 0 && materialUnit.Length > 0 && qty > 0)
{
//保存到原料结存清单
if (daBalance.InsertData(
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
qty,
materialUnit,
price,
remark,
addPerson,
false
) <= 0)
{
throw new Exception("保存到原料结存清单失败！");
}
//保存到单据内容清单
if (daContent.Insert(
billNum,
rowId,
materialType,
materialCode,
materialName,
materialSize,
qty,
materialUnit,
price,
remark
) <= 0)
{
throw new Exception("保存到单据内容清单失败！");
}
//保存到物料名称清单
if (daName.UpdateData(
price,
addPerson,
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
materialUnit
) <= 0)
{
//获取最大的物料编码
var maxCode = string.Empty;
if (materialCode.Trim().Length > 0)
{
maxCode = materialCode.Substring(0, 1);
}
if (maxCode.Length > 0)
{
maxCode = daName.GetMaxCodeLikeMaterialCode(maxCode + "%").ToString();
}
if (maxCode.Length <= 0)
{
maxCode = daName.GetMaxCode().ToString();
}
//最大编码如果没有找到
if (maxCode.Length <= 0)
{
//设置默认物料代码
materialCode = "A00001";
}
else
{
//设置默认物料代码
materialCode = string.Format(
"{0}{1:00000}",
maxCode.Substring(0, 1),
(Math.Round(ydPublicMethod.Val(maxCode.Substring(1)), 0) + 1)
);
}
//执行添加
if (daName.InsertData(
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
materialUnit,
price,
addPerson
) <= 0)
{
throw new Exception("保存到物料名称清单失败！");
}
}
//保存到历史单价清单
if (daPrice.UpdateData(
price,
addPerson,
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
materialUnit
) <= 0)
{
//执行添加
if (daPrice.InsertData(
materialType,
supplierCode,
supplierName,
materialCode,
materialName,
materialSize,
materialUnit,
price,
addPerson
) <= 0)
{
throw new Exception("保存到物料历史单价清单失败！");
}
}
//含有数据的行数计数
iCountContent++;
}
}
//保存表头
if (iCountContent > 0)
{
if (daHead.Insert(
billDate,
billNum,
supplierCode,
supplierName,
deliveryNum,
billRemark,
addPerson,
addTime,
lastChangeTime
) <= 0)
{
throw new Exception("从单据表头中删除失败！");
}
}
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//非数字返回失败
throw new Exception(ex.Message);
}
}
}
}