/// <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(); } } }