private void btnSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("是否保存", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
Mes_WorkShopScanBLL WorkShopScanBLL = new Mes_WorkShopScanBLL();
Mes_WorkShopScanEntity WorkShopScanEntity = new Mes_WorkShopScanEntity();
WorkShopScanEntity.W_GoodsName = txtName.Text;
WorkShopScanEntity.W_WorkShop = Globels.strWorkShop;
WorkShopScanEntity.W_RecordCode = Globels.strRecord;
WorkShopScanEntity.W_GoodsCode = cmbGoodsCode.Text;
WorkShopScanEntity.W_Batch = cmbPc.Text;
WorkShopScanEntity.W_Price = Convert.ToDecimal(txtPrice.Text);
WorkShopScanEntity.W_Status = 1;
WorkShopScanEntity.W_Qty = Convert.ToDecimal(txtQty.Text);
WorkShopScanEntity.W_Unit = txtUnit.Text;
WorkShopScanEntity.W_Remark = "";
int nCount = WorkShopScanBLL.SaveEntity("", WorkShopScanEntity);
if (nCount > 0)
{
MessageBox.Show("添加成功");
Init();
}
}
}
/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntity(string keyValue, Mes_WorkShopScanEntity entity)
{
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_WorkShopScan(");
strSql.Append("ID,");
strSql.Append("W_RecordCode,");
strSql.Append("W_WorkShop,");
strSql.Append("W_Status,");
strSql.Append("W_GoodsCode,");
strSql.Append("W_GoodsName,");
strSql.Append("W_Unit,");
strSql.Append("W_Qty,");
strSql.Append("W_Price,");
strSql.Append("W_Batch,");
strSql.Append("W_Remark");
strSql.Append(")");
strSql.Append(" VALUES (");
strSql.Append("@ID,");
strSql.Append("@W_RecordCode,");
strSql.Append("@W_WorkShop,");
strSql.Append("@W_Status,");
strSql.Append("@W_GoodsCode,");
strSql.Append("@W_GoodsName,");
strSql.Append("@W_Unit,");
strSql.Append("@W_Qty,");
strSql.Append("@W_Price,");
strSql.Append("@W_Batch,");
strSql.Append("@W_Remark");
strSql.Append(")");
paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
}
else
{
}
paramList.Add(new SqlParameter("@W_RecordCode", entity.W_RecordCode));
paramList.Add(new SqlParameter("@W_WorkShop", entity.W_WorkShop));
paramList.Add(new SqlParameter("@W_Status", entity.W_Status));
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_Price", entity.W_Price));
paramList.Add(new SqlParameter("@W_Batch", entity.W_Batch));
paramList.Add(new SqlParameter("@W_Remark", entity.W_Remark));
var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray());
return(result);
}
catch (Exception)
{
throw;
}
}
