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; } }