/// <summary>
/// 称重记录保存
/// </summary>
private void addWeighStorage()
{
try
{
MesWeightRecordBLL MesWeightRecordBLL = new MesWeightRecordBLL();
if (checkInput())
{
MesMaterInDetailBLL MaterInDetailBLL = new MesMaterInDetailBLL();
var rows = MaterInDetailBLL.GetList_GoodsCode(txtGoodsCode.Text, "");
if (rows[0].M_GoodsCode == txtGoodsCode.Text && rows[0].M_GoodsName == txtGoodsName.Text && rows[0].M_Qty.ToString() == txtQty.Text)
{
untCommon.InfoMsg("称重记录数据错误！");
return;
}
MesWeightRecordEntity MesWeightRecord = new MesWeightRecordEntity();
MesWeightRecord.P_OrderNo = txtOrderNo.Text;
MesWeightRecord.W_Kind = comKind.Text;
MesWeightRecord.W_Date = DateTime.Now;
MesWeightRecord.W_GoodsCode = txtGoodsCode.Text;
MesWeightRecord.W_GoodsName = txtGoodsName.Text;
MesWeightRecord.W_Batch = txtBatch.Text;
MesWeightRecord.W_Qty = decimal.Parse(txtQty.Text);
MesWeightRecord.W_Unit = txtUnit.Text;
if (MesWeightRecordBLL.SaveEntity("", MesWeightRecord) > 0)
{
untCommon.InfoMsg("称重记录添加成功！");
}
else
{
untCommon.InfoMsg("称重记录添加失败！");
}
}
}
catch (Exception ex)
{
untCommon.ErrorMsg("设备管理添加数据异常：" + ex.Message);
}
}
/// <summary>
/// 称重记录保存
/// </summary>
//private void addWeighStorage()
//{
// try
// {
// MesWeightRecordBLL MesWeightRecordBLL = new MesWeightRecordBLL();
// MesMaterInDetailBLL MaterInDetailBLL = new MesMaterInDetailBLL();
// var rows = MaterInDetailBLL.GetList_GoodsCode("","");
// if (checkInput())
// {
// rows = MaterInDetailBLL.GetList_GoodsCode(txtGoodsCode.Text,M_MaterInNo);
// if (rows[0].M_GoodsCode == txtGoodsCode.Text && rows[0].M_GoodsName == txtGoodsName.Text && rows[0].M_Qty.ToString() == txtQty.Text)
// {
// untCommon.InfoMsg("称重记录数据错误！");
// return;
// }
// MesWeightRecordEntity MesWeightRecord = new MesWeightRecordEntity();
// MesWeightRecord.P_OrderNo = P_OrderNo;
// MesWeightRecord.W_Kind = W_Kind;
// MesWeightRecord.W_Date = DateTime.Now;
// MesWeightRecord.W_GoodsCode = txtGoodsCode.Text;
// MesWeightRecord.W_GoodsName = txtGoodsName.Text;
// MesWeightRecord.W_Batch = txtBatch.Text;
// MesWeightRecord.W_Qty = decimal.Parse(txtQty.Text);
// MesWeightRecord.W_Unit = txtUnit.Text;
// if (MesWeightRecordBLL.SaveEntity("", MesWeightRecord) > 0)
// {
// untCommon.InfoMsg("称重记录添加成功！");
// whether = 2;
// //frmParent.loadData();
// frmStorage.Refresh();
// }
// else
// {
// untCommon.InfoMsg("称重记录添加失败！");
// }
// }
// rows = MaterInDetailBLL.GetList(M_MaterInNo);
// dataGridView.DataSource = rows;
// }
// catch (Exception ex)
// {
// untCommon.ErrorMsg("称重数据异常：" + ex.Message);
// }
//}
/// <summary>
/// 保存
/// </summary>
private void addStorage()
{
try
{
string[] strGoods = comGoods.Text.ToString().Split('$');
MesWeightRecordBLL MesWeightRecordBLL = new MesWeightRecordBLL();
MesMaterInDetailBLL MaterInDetailBLL = new MesMaterInDetailBLL();
MesWeightRecordEntity MesWeightRecord = new MesWeightRecordEntity();
var rows = MaterInDetailBLL.GetList_GoodsCode("", "");
if (checkInput())
{
//rows = MaterInDetailBLL.GetList_GoodsCode(txtGoodsCode.Text,M_MaterInNo);
//if (rows[0].M_GoodsCode == txtGoodsCode.Text && rows[0].M_GoodsName == txtGoodsName.Text && rows[0].M_Qty.ToString() == txtQty.Text)
//{
// untCommon.InfoMsg("称重记录数据错误！");
// return;
//}
MesWeightRecord.P_OrderNo = P_OrderNo;
MesWeightRecord.W_Kind = W_Kind;
MesWeightRecord.W_Date = DateTime.Now;
MesWeightRecord.W_GoodsCode = strGoods[0];
MesWeightRecord.W_GoodsName = strGoods[1];
MesWeightRecord.W_Batch = txtBatch.Text;
MesWeightRecord.W_Qty = decimal.Parse(txtQty.Text);
MesWeightRecord.W_Unit = txtUnit.Text;
MesMaterInDetailEntity MaterInDetail = new MesMaterInDetailEntity();
MesGoodsBLL GoodsBLL = new MesGoodsBLL();
//MesMaterInDetailEntity MaterInDetail = new MesMaterInDetailEntity();
var Goods_rows = GoodsBLL.GetList(strGoods[0], "");
string cz = "";//是否存在相同物料
MaterInDetail.M_MaterInNo = txtMaterInNo.Text;
MaterInDetail.M_GoodsCode = strGoods[0];
MaterInDetail.M_GoodsName = strGoods[1];
MaterInDetail.M_Batch = txtBatch.Text;
MaterInDetail.M_Price = Convert.ToDecimal(txtPrice.Text);
MaterInDetail.M_GoodsItax = Itox;
if (checkBox1.Checked == true)
{
drqQty = decimal.Parse(txtBasketQty.Text);
MaterInDetail.M_Qty = decimal.Parse(txtQty.Text) - drqQty;
}
else
{
MaterInDetail.M_Qty = decimal.Parse(txtQty.Text);
}
MaterInDetail.M_Unit = txtUnit.Text;
MaterInDetail.M_Kind = Convert.ToString(Goods_rows[0].G_Kind);
// MesGoodsBLL GoodsBLL = new MesGoodsBLL();
//var Goods_rows = GoodsBLL.GetList(MaterInDetail.M_GoodsCode, MaterInDetail.M_GoodsName);
if (Goods_rows == null || Goods_rows.Count < 1)
{
untCommon.InfoMsg("输入的物料名称错误，请重新输入！");
return;
}
else if (Goods_rows[0].G_Kind == 1)
{
//txtGoodsCode.Text = Goods_rows[0].G_Code;
//txtGoodsName.Text = Goods_rows[0].G_Name;
txtUnit.Text = Goods_rows[0].G_Unit;
}
else
{
untCommon.InfoMsg("输入的物料名称错误，请重新输入！");
return;
}
int i = dataGridView.Rows.Count;
if (dataGridView.RowCount > 0 && dataGridView.DataSource != null)
{
for (int j = 0; j < i; j++)
{
if (dataGridView.Rows[j].Cells["物料编码"].Value.ToString() == strGoods[0])
{
if (dataGridView.Rows[j].Cells["批次"].Value.ToString() == txtBatch.Text.Trim())
{
cz = "存在";
}
}
}
}
if (cz == "存在")
{
var MaterInDetai_rows = MaterInDetailBLL.GetList_GoodsCode(MaterInDetail.M_GoodsCode, M_MaterInNo);
var rowData = MaterInDetailBLL.GetEntity(MaterInDetai_rows[0].ID);
//
decimal dPrice = (rowData.M_Price * rowData.M_Qty + MaterInDetail.M_Price * MaterInDetail.M_Qty) / (rowData.M_Qty + MaterInDetail.M_Qty);
rowData.M_Price = dPrice;
rowData.M_Qty += MaterInDetail.M_Qty;
if (MaterInDetailBLL.SaveEntityTrans(rowData.ID, rowData, "", MesWeightRecord) > 0)//事务
{
untCommon.InfoMsg("修改成功！");
whether = 2;
//frmParent.loadData();
frmStorage.Refresh();
}
else
{
untCommon.InfoMsg("修改失败！");
}
//if (MaterInDetailBLL.SaveEntity(rowData.ID, rowData) > 0)
//{
// untCommon.InfoMsg("修改失败！");
// whether = 2;
// //frmParent.loadData();
// frmStorage.Refresh();
// clear();
//}
//else
//{
// untCommon.InfoMsg("修改失败！");
//}
}
else
{
if (MaterInDetailBLL.SaveEntityTrans("", MaterInDetail, "", MesWeightRecord) > 0)
{
untCommon.InfoMsg("添加成功！");
//frmParent.loadData();
whether = 2;
frmStorage.Refresh();
}
else
{
untCommon.InfoMsg("添加失败！");
}
}
}
rows = MaterInDetailBLL.GetList(M_MaterInNo);
dataGridView.DataSource = rows;
}
catch (Exception ex)
{
untCommon.ErrorMsg("称重保存数据异常：" + ex.Message);
}
}
/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntity(string keyValue, MesWeightRecordEntity entity)
{
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_WeightRecord(");
strSql.Append("ID,");
strSql.Append("P_OrderNo,");
strSql.Append("W_Kind,");
strSql.Append("W_Date,");
strSql.Append("W_GoodsCode,");
strSql.Append("W_GoodsName,");
strSql.Append("W_Unit,");
strSql.Append("W_Qty,");
strSql.Append("W_Batch");
strSql.Append(")");
strSql.Append("VALUES(");
strSql.Append("@ID,");
strSql.Append("@P_OrderNo,");
strSql.Append("@W_Kind,");
strSql.Append("@W_Date,");
strSql.Append("@W_GoodsCode,");
strSql.Append("@W_GoodsName,");
strSql.Append("@W_Unit,");
strSql.Append("@W_Qty,");
strSql.Append("@W_Batch");
strSql.Append(")");
paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
}
else
{
strSql.Append("UPDATE Mes_WeightRecord SET ");
strSql.Append("P_OrderNo=@P_OrderNo,");
strSql.Append("W_Kind=@W_Kind,");
strSql.Append("W_Date=@W_Date,");
strSql.Append("W_GoodsCode=@W_GoodsCode,");
strSql.Append("W_GoodsName=@W_GoodsName,");
strSql.Append("W_Unit=@W_Unit,");
strSql.Append("W_Qty=@W_Qty,");
strSql.Append("W_Batch=@W_Batch ");
strSql.Append(" WHERE ID=@ID");
paramList.Add(new SqlParameter("@ID", keyValue));
}
paramList.Add(new SqlParameter("@P_OrderNo", entity.P_OrderNo));
paramList.Add(new SqlParameter("@W_Kind", entity.W_Kind));
paramList.Add(new SqlParameter("@W_Date", entity.W_Date));
paramList.Add(new SqlParameter("@W_GoodsCode", entity.W_GoodsCode));
paramList.Add(new SqlParameter("@W_GoodsName", entity.W_GoodsName));
paramList.Add(new SqlParameter("@W_Unit", entity.W_Unit));
paramList.Add(new SqlParameter("@W_Qty", entity.W_Qty));
paramList.Add(new SqlParameter("@W_Batch", entity.W_Batch));
var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray());
return(result);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 保存实体数据 事务
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntityTrans(string keyValue, MesMaterInDetailEntity entity, string WeightRecord_keyValue, MesWeightRecordEntity WeightRecord_entity)
{
SqlTrans trans = new SqlTrans();
SqlConnection con = trans.TranConn();;
SqlTransaction tran = trans.TransBegin(con);
string role = "";
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
var WeightRecord_strSql = new StringBuilder();
var WeightRecord_paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_MaterInDetail(");
strSql.Append("ID,");
strSql.Append("M_MaterInNo,");
strSql.Append("M_OrderNo,");
strSql.Append("M_GoodsCode,");
strSql.Append("M_Kind,");
strSql.Append("M_GoodsName,");
strSql.Append("M_GoodsItax,");
strSql.Append("M_Unit,");
strSql.Append("M_Qty,");
strSql.Append("M_Batch,");
strSql.Append("M_Price,");
strSql.Append("M_Remark");
strSql.Append(")");
strSql.Append("VALUES(");
strSql.Append("@ID,");
strSql.Append("@M_MaterInNo,");
strSql.Append("@M_OrderNo,");
strSql.Append("@M_GoodsCode,");
strSql.Append("@M_Kind,");
strSql.Append("@M_GoodsName,");
strSql.Append("@M_GoodsItax,");
strSql.Append("@M_Unit,");
strSql.Append("@M_Qty,");
strSql.Append("@M_Batch,");
strSql.Append("@M_Price,");
strSql.Append("@M_Remark");
strSql.Append(")");
paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
}
else
{
strSql.Append("UPDATE Mes_MaterInDetail SET ");
strSql.Append("M_MaterInNo=@M_MaterInNo,");
strSql.Append("M_OrderNo=@M_OrderNo,");
strSql.Append("M_GoodsCode=@M_GoodsCode,");
strSql.Append("M_Kind=@M_Kind,");
strSql.Append("M_GoodsName=@M_GoodsName,");
strSql.Append("M_Unit=@M_Unit,");
strSql.Append("M_Qty=@M_Qty,");
strSql.Append("M_Price=@M_Price,");
strSql.Append("M_Batch=@M_Batch,");
strSql.Append("M_Remark=@M_Remark ");
strSql.Append(" WHERE ID=@ID");
paramList.Add(new SqlParameter("@ID", keyValue));
}
paramList.Add(new SqlParameter("@M_MaterInNo", entity.M_MaterInNo));
paramList.Add(new SqlParameter("@M_OrderNo", entity.M_OrderNo));
paramList.Add(new SqlParameter("@M_GoodsCode", entity.M_GoodsCode));
paramList.Add(new SqlParameter("@M_Kind", entity.M_Kind));
paramList.Add(new SqlParameter("@M_GoodsName", entity.M_GoodsName));
paramList.Add(new SqlParameter("@M_GoodsItax", entity.M_GoodsItax));
paramList.Add(new SqlParameter("@M_Unit", entity.M_Unit));
paramList.Add(new SqlParameter("@M_Qty", entity.M_Qty));
paramList.Add(new SqlParameter("@M_Batch", entity.M_Batch));
paramList.Add(new SqlParameter("@M_Price", entity.M_Price));
paramList.Add(new SqlParameter("@M_Remark", entity.M_Remark));
SqlHelper.ExecuteNonQuery(tran, CommandType.Text, strSql.ToString(), paramList.ToArray());
WeightRecord_strSql.Append("INSERT INTO Mes_WeightRecord(");
WeightRecord_strSql.Append("ID,");
WeightRecord_strSql.Append("P_OrderNo,");
WeightRecord_strSql.Append("W_Kind,");
WeightRecord_strSql.Append("W_Date,");
WeightRecord_strSql.Append("W_GoodsCode,");
WeightRecord_strSql.Append("W_GoodsName,");
WeightRecord_strSql.Append("W_Unit,");
WeightRecord_strSql.Append("W_Qty,");
WeightRecord_strSql.Append("W_Batch");
WeightRecord_strSql.Append(")");
WeightRecord_strSql.Append("VALUES(");
WeightRecord_strSql.Append("@ID,");
WeightRecord_strSql.Append("@P_OrderNo,");
WeightRecord_strSql.Append("@W_Kind,");
WeightRecord_strSql.Append("@W_Date,");
WeightRecord_strSql.Append("@W_GoodsCode,");
WeightRecord_strSql.Append("@W_GoodsName,");
WeightRecord_strSql.Append("@W_Unit,");
WeightRecord_strSql.Append("@W_Qty,");
WeightRecord_strSql.Append("@W_Batch");
WeightRecord_strSql.Append(")");
WeightRecord_paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
WeightRecord_paramList.Add(new SqlParameter("@P_OrderNo", WeightRecord_entity.P_OrderNo));
WeightRecord_paramList.Add(new SqlParameter("@W_Kind", WeightRecord_entity.W_Kind));
WeightRecord_paramList.Add(new SqlParameter("@W_Date", WeightRecord_entity.W_Date));
WeightRecord_paramList.Add(new SqlParameter("@W_GoodsCode", WeightRecord_entity.W_GoodsCode));
WeightRecord_paramList.Add(new SqlParameter("@W_GoodsName", WeightRecord_entity.W_GoodsName));
WeightRecord_paramList.Add(new SqlParameter("@W_Unit", WeightRecord_entity.W_Unit));
WeightRecord_paramList.Add(new SqlParameter("@W_Qty", WeightRecord_entity.W_Qty));
WeightRecord_paramList.Add(new SqlParameter("@W_Batch", WeightRecord_entity.W_Batch));
SqlHelper.ExecuteNonQuery(tran, CommandType.Text, WeightRecord_strSql.ToString(), WeightRecord_paramList.ToArray());
trans.TransCommit(tran);
trans.TransEnd(con);
return(1);
}
catch (Exception)
{
trans.TransRollback(tran);
trans.TransEnd(con);
throw;
}
}
