/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntity(string keyValue, Mes_OutWorkShopTempEntity entity)
{
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_OutWorkShopTemp(");
strSql.Append("ID,");
strSql.Append("O_StockCode,");
strSql.Append("O_StockName,");
strSql.Append("O_WorkShop,");
strSql.Append("O_WorkShopName,");
strSql.Append("O_OrderNo,");
strSql.Append("O_Status,");
strSql.Append("O_CreateBy,");
strSql.Append("O_CreateDate,");
strSql.Append("O_GoodsCode,");
strSql.Append("O_GoodsName,");
strSql.Append("O_Unit,");
strSql.Append("O_Qty,");
strSql.Append("O_Batch,");
strSql.Append("O_Remark,");
strSql.Append("O_Barcode,");
strSql.Append("O_Price,");
strSql.Append("O_Record");
strSql.Append(")");
strSql.Append(" VALUES (");
strSql.Append("@ID,");
strSql.Append("@O_StockCode,");
strSql.Append("@O_StockName,");
strSql.Append("@O_WorkShop,");
strSql.Append("@O_WorkShopName,");
strSql.Append("@O_OrderNo,");
strSql.Append("@O_Status,");
strSql.Append("@O_CreateBy,");
strSql.Append("@O_CreateDate,");
strSql.Append("@O_GoodsCode,");
strSql.Append("@O_GoodsName,");
strSql.Append("@O_Unit,");
strSql.Append("@O_Qty,");
strSql.Append("@O_Batch,");
strSql.Append("@O_Remark,");
strSql.Append("@O_Barcode,");
strSql.Append("@O_Price,");
strSql.Append("@O_Record");
strSql.Append(")");
paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
}
else
{
strSql.Append("UPDATE Mes_OutWorkShopTemp SET ");
strSql.Append("B_BasketCode=@B_BasketCode,");
strSql.Append("B_BasketName=@B_BasketName,");
strSql.Append("M_Weight=@M_Weight ");
strSql.Append(" WHERE ID=@ID");
paramList.Add(new SqlParameter("@ID", keyValue));
}
paramList.Add(new SqlParameter("@O_StockCode", entity.O_StockCode));
paramList.Add(new SqlParameter("@O_StockName", entity.O_StockName));
paramList.Add(new SqlParameter("@O_WorkShop", entity.O_WorkShop));
paramList.Add(new SqlParameter("@O_WorkShopName", entity.O_WorkShopName));
paramList.Add(new SqlParameter("@O_OrderNo", entity.O_OrderNo));
paramList.Add(new SqlParameter("@O_Status", entity.O_Status));
paramList.Add(new SqlParameter("@O_CreateBy", entity.O_CreateBy));
paramList.Add(new SqlParameter("@O_CreateDate", entity.O_CreateDate));
paramList.Add(new SqlParameter("@O_GoodsCode", entity.O_GoodsCode));
paramList.Add(new SqlParameter("@O_GoodsName", entity.O_GoodsName));
paramList.Add(new SqlParameter("@O_Unit", entity.O_Unit));
paramList.Add(new SqlParameter("@O_Qty", entity.O_Qty));
paramList.Add(new SqlParameter("@O_Batch", entity.O_Batch));
paramList.Add(new SqlParameter("@O_Remark", entity.O_Remark));
paramList.Add(new SqlParameter("@O_Barcode", entity.O_Barcode));
paramList.Add(new SqlParameter("@O_Price", entity.O_Price));
paramList.Add(new SqlParameter("@O_Record", entity.O_Record));
var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray());
return(result);
}
catch (Exception)
{
throw;
}
}
private void btn_save_Click(object sender, EventArgs e)
{
if (cmbGoodsCode.Text == "" || cmbGoodsName.Text == "" || cmbPc.Text == "" || txtName.Text == "")
{
lblTS.Text = "物料或者批次不能为空!";
return;
}
if (txtQty.Text == "")
{
lblTS.Text = "数量不能为空!";
return;
}
try
{
if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(txtStockQty.Text))
{
lblTS.Text = "不能超过库存数量!";
return;
}
}
catch (Exception ex)
{
lblTS.Text = "数量只能为数字!";
return;
}
if (MessageBox.Show("是否保存", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
try
{
Mes_OutWorkShopTempEntity OutWorkShopTempEntity = new Mes_OutWorkShopTempEntity();
OutWorkShopTempEntity.O_StockCode = cmbStock.Text;
OutWorkShopTempEntity.O_StockName = cmbStockName.Text;
OutWorkShopTempEntity.O_WorkShop = cmbWorkShop.Text;
OutWorkShopTempEntity.O_WorkShopName = cmbWorkshopName.Text;
OutWorkShopTempEntity.O_OrderNo = comOrderNo.Text;
OutWorkShopTempEntity.O_Status = 1;
OutWorkShopTempEntity.O_CreateBy = Globels.strUser;
OutWorkShopTempEntity.O_CreateDate = DateTime.Now;
OutWorkShopTempEntity.O_GoodsCode = cmbGoodsCode.Text;
OutWorkShopTempEntity.O_GoodsName = txtName.Text;
OutWorkShopTempEntity.O_Unit = strUnit;
OutWorkShopTempEntity.O_Qty = Convert.ToDecimal(txtQty.Text);
OutWorkShopTempEntity.O_Batch = cmbPc.Text;
OutWorkShopTempEntity.O_Remark = "";
OutWorkShopTempEntity.O_Barcode = txtBarcode.Text;
OutWorkShopTempEntity.O_Price = Convert.ToDecimal(txtPrice.Text);
OutWorkShopTempEntity.O_Record = cmbRecord.Text;
Mes_OutWorkShopTempBLL OutWorkShopTempBLL = new Mes_OutWorkShopTempBLL();
if (OutWorkShopTempBLL.SaveEntity("", OutWorkShopTempEntity) > 0)
{
untCommon.InfoMsg("添加成功！");
Update();
cls();
txtBarcode.SelectAll();
txtBarcode.Focus();
//frmParent.loadData();
}
else
{
//untCommon.InfoMsg("添加失败！");
lblTS.Text = "添加失败!";
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
lblTS.Text = "系统提示：" + ex.ToString();
}
}
}
