/// <summary>
/// 根据单号从数据库中删除单据的表头和内容
/// </summary>
/// <param name="billNum">单据号</param>
private bool DeleteBillByBillNum(string billNum)
{
//实例化数据适配器
using (var da = new v_mantissa_lot_card_loseTableAdapter())
//取得数据库连接
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_mantissa_lot_card_lose_headTableAdapter())
using (var daContent = new t_mantissa_lot_card_lose_contentTableAdapter())
using (var daBalance = new t_mantissa_lot_card_balanceTableAdapter())
{
//设置连接对象
daHead.Connection = daContent.Connection = daBalance.Connection = tran.Connection;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
//遍历行执行删除各行的结存记录和写回已入库结存记录
foreach (DataSetMantissaLose.v_mantissa_lot_card_loseRow row in tab.Rows)
{
//执行插入到尾数结存清单
daBalance.InsertData(
row.prev_proc_name,
row.proc_name,
row.lot_id,
row.product_num,
row.pnl_qty,
row.pcs_qty,
"尾数盘亏单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
Session["user_name"].ToString()
);
}
//根据盘亏单号删除全部盘亏内容记录
daContent.DeleteByBillNum(billNum);
//根据盘亏单号删除全部盘亏表头记录
daHead.Delete(billNum);
}
}
//提交事务
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_mantissa_lot_card_loseTableAdapter())
//取得数据库连接
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_mantissa_lot_card_lose_contentTableAdapter())
using (var daBalance = new t_mantissa_lot_card_balanceTableAdapter())
{
//设置连接对象
daContent.Connection = daBalance.Connection = tran.Connection;
//设置事务
daContent.Transaction = daBalance.Transaction = tran;
//遍历行执行删除各行的结存记录和写回已入库结存记录
foreach (DataSetMantissaLose.v_mantissa_lot_card_loseRow row in tab.Rows)
{
//执行插入到尾数结存清单
daBalance.InsertData(
row.prev_proc_name,
row.proc_name,
row.lot_id,
row.product_num,
row.pnl_qty,
row.pcs_qty,
"尾数盘亏单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
Session["user_name"].ToString()
);
}
//根据盘亏单号和行号删除盘亏记录
daContent.Delete(billNum, rowId);
//检测当前盘亏记录内容行数
int? iCount = daContent.CountByBillNum(billNum);
if (iCount.HasValue && iCount.Value <= 0)
{
//表头适配器
using (var daHead = new t_mantissa_lot_card_lose_headTableAdapter())
{
//删除表头
daHead.Delete(billNum);
}
}
}
//提交事务
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(FormViewDeleteEventArgs e)
{
//当前单号
string billNum = Convert.ToString(e.Keys[0]);
//数据适配器
//当前数据库连接
//当前更新语句对象
using (var da = new v_mantissa_lot_card_outTableAdapter())
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_mantissa_lot_card_out_headTableAdapter())
using (var daContent = new t_mantissa_lot_card_out_contentTableAdapter())
using (var daBalance = new t_mantissa_lot_card_balanceTableAdapter())
{
//设置数据库连接
daHead.Connection = daContent.Connection = daBalance.Connection = conn;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
//将之前的单据内容写回
foreach (DataSetMantissaOut.v_mantissa_lot_card_outRow row in tab.Rows)
{
//检测是否超过原下部门余数
if (ydOperateBalanceLotCrad.IsOutstripProcBalance(
tran,
row.next_proc_name,
row.lot_id,
null,
row.pnl_qty,
row.pcs_qty
))
{
return false;
}
//修改原下部门批量卡余数
if (!ydOperateBalanceLotCrad.UpdateBalanceAfterInsert(
tran,
row.next_proc_name,
row.lot_id,
null,
row.pnl_qty,
row.pcs_qty
))
{
return false;
}
//执行插入到尾数结存清单
daBalance.InsertData(
row.prev_proc_name,
row.proc_name,
row.lot_id,
row.product_num,
row.pnl_qty,
row.pcs_qty,
"尾数出库单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
Session["user_name"].ToString()
);
}
//从单据内容中删除
daContent.DeleteByBillNum(billNum);
//从单据表头中删除
daHead.Delete(billNum);
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//非数字返回失败
throw new Exception(ex.Message);
}
}
}
}
/// <summary>
/// 根据输入的参数值来执行更新数据
/// </summary>
/// <param name="e">传入的带有数据的事件参数</param>
/// <returns></returns>
private bool UpdateData(FormViewUpdateEventArgs e)
{
//数据适配器
//当前添加语句对象
//当前数据库连接
using (var da = new v_mantissa_lot_card_outTableAdapter())
using (var conn = da.Connection)
{
//打开数据库连接
conn.Open();
//开启事务
using (var tran = conn.BeginTransaction())
{
//设置事务
da.Transaction = tran;
//试运行
try
{
//部门名称
string procName = e.OldValues["proc_name"].ToString();
//当前行单号
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_mantissa_lot_card_out_headTableAdapter())
using (var daContent = new t_mantissa_lot_card_out_contentTableAdapter())
using (var daBalance = new t_mantissa_lot_card_balanceTableAdapter())
using (var daProc = new t_proc_lot_card_balanceTableAdapter())
{
//设置数据库连接
daHead.Connection = daContent.Connection = daBalance.Connection = daProc.Connection = conn;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = daProc.Transaction = tran;
//将之前的单据内容写回
foreach (DataSetMantissaOut.v_mantissa_lot_card_outRow row in tab.Rows)
{
//检测是否超过原下部门余数
if (ydOperateBalanceLotCrad.IsOutstripProcBalance(
tran,
row.next_proc_name,
row.lot_id,
null,
row.pnl_qty,
row.pcs_qty
))
{
return false;
}
//修改原下部门批量卡余数
if (!ydOperateBalanceLotCrad.UpdateBalanceAfterInsert(
tran,
row.next_proc_name,
row.lot_id,
null,
row.pnl_qty,
row.pcs_qty
))
{
return false;
}
//执行插入到尾数结存清单
daBalance.InsertData(
row.prev_proc_name,
row.proc_name,
row.lot_id,
row.product_num,
row.pnl_qty,
row.pcs_qty,
"尾数出库单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
Session["user_name"].ToString()
);
}
//从单据内容中删除
daContent.DeleteByBillNum(billNum);
//从单据表头中删除
daHead.Delete(billNum);
//日期
DateTime billDate = Convert.ToDateTime(e.NewValues["bill_date"]);
//下部门
string nextProcName = Convert.ToString(e.NewValues["next_proc_name"]);
//单据备注
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"]);
//保存表头
daHead.Insert(
billDate,
billNum,
procName,
nextProcName,
billRemark,
addPerson,
addTime,
lastChangeTime
);
//遍历子表执行保存
for (int iRow = 0; iRow < 10; iRow++)
{
//子表各控件
var tr = tabDataListSon.Rows[iRow + 1];
var litRowId = (Literal)tr.Cells[0].Controls[0];
var txtPrevProcName = (TextBox)tr.Cells[1].Controls[0];
var txtLotId = (TextBox)tr.Cells[2].Controls[0];
var txtProductNum = (TextBox)tr.Cells[3].Controls[0];
var txtPnlQty = (TextBox)tr.Cells[4].Controls[0];
var txtPcsQty = (TextBox)tr.Cells[5].Controls[0];
var txtRemark = (TextBox)tr.Cells[6].Controls[0];
//取得数据
byte rowId = Convert.ToByte(litRowId.Text);
string prevProcName = txtPrevProcName.Text;
string lotId = txtLotId.Text;
string productNum = txtProductNum.Text;
int pnlQty = txtPnlQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPnlQty.Text.Trim());
int pcsQty = txtPcsQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPcsQty.Text.Trim());
string remark = txtRemark.Text;
//存在数据才保存
if (lotId.Length > 0 && productNum.Length > 0 && pnlQty + pcsQty > 0)
{
//保存到单据内容清单
daContent.Insert(
billNum,
rowId,
prevProcName,
lotId,
productNum,
pnlQty,
pcsQty,
remark
);
//保存到部门批量卡结存清单
daProc.Insert(
procName,
nextProcName,
lotId,
productNum,
pnlQty,
pcsQty,
"出库单写入" + (remark.Length > 0 ? ":" + remark : string.Empty),
Session["user_name"].ToString(),
DateTime.Now,
DateTime.Now,
null,
null,
true
);
//从尾数结存清单中扣除
if (!ydOperateMantissaLotCard.DecreaseMantissaBalance(
daBalance,
prevProcName,
lotId,
pnlQty,
pcsQty
))
{
return false;
}
}
}
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//非数字返回失败
throw new Exception(ex.Message);
}
}
}
}
/// <summary>
/// 根据输入的LOT格式来保存多条数据到数据库
/// </summary>
/// <param name="e">传入的带有数据的事件参数</param>
/// <param name="procName">当前部门名称</param>
/// <returns></returns>
private bool InsertData(FormViewInsertEventArgs e, string procName)
{
//日期
DateTime billDate = Convert.ToDateTime(e.Values["bill_date"]);
//单号
string billNum = Convert.ToString(e.Values["bill_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_mantissa_lot_card_back_headTableAdapter())
using (var daContent = new t_mantissa_lot_card_back_contentTableAdapter())
using (var daBalance = new t_mantissa_lot_card_balanceTableAdapter())
using (var conn = daHead.Connection)
{
//打开数据库连接
conn.Open();
//开启事务
using (var tran = conn.BeginTransaction())
{
//设置数据库连接对象
daContent.Connection = daBalance.Connection = conn;
//设置事务
daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
//试运行
try
{
//保存表头
daHead.Insert(
billDate,
billNum,
procName,
billRemark,
addPerson,
addTime,
lastChangeTime
);
//遍历子表执行保存
for (int iRow = 0; iRow < 10; iRow++)
{
//子表各控件
var tr = tabDataListSon.Rows[iRow + 1];
var litRowId = (Literal)tr.Cells[0].Controls[0];
var txtPrevProcName = (TextBox)tr.Cells[1].Controls[0];
var txtLotId = (TextBox)tr.Cells[2].Controls[0];
var txtProductNum = (TextBox)tr.Cells[3].Controls[0];
var txtPnlQty = (TextBox)tr.Cells[4].Controls[0];
var txtPcsQty = (TextBox)tr.Cells[5].Controls[0];
var txtRemark = (TextBox)tr.Cells[6].Controls[0];
//取得数据
byte rowId = Convert.ToByte(litRowId.Text);
string prevProcName = txtPrevProcName.Text;
string lotId = txtLotId.Text;
string productNum = txtProductNum.Text;
int pnlQty = txtPnlQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPnlQty.Text.Trim());
int pcsQty = txtPcsQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPcsQty.Text.Trim());
string remark = txtRemark.Text;
//存在数据才保存
if (lotId.Length > 0 && productNum.Length > 0 && pnlQty + pcsQty > 0)
{
//保存到单据内容清单
daContent.Insert(
billNum,
rowId,
prevProcName,
lotId,
productNum,
pnlQty,
pcsQty,
remark
);
//保存到尾数结存清单
daBalance.InsertData(
prevProcName,
procName,
lotId,
productNum,
pnlQty,
pcsQty,
"尾数盘亏单写回" + (remark.Length <= 0 ? string.Empty : ":" + remark),
addPerson
);
}
}
//提交事务
tran.Commit();
//返回成功
return true;
}
catch (Exception ex)
{
//回滚事务
tran.Rollback();
//非数字返回失败
throw new Exception(ex.Message);
}
}
}
}