/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.SellGoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SellGoodsInfo set "); strSql.Append("GoodsID=@GoodsID,"); strSql.Append("EmployeeID=@EmployeeID,"); strSql.Append("CompanyName=@CompanyName,"); strSql.Append("DepotName=@DepotName,"); strSql.Append("GoodsName=@GoodsName,"); strSql.Append("SellGoodsNum=@SellGoodsNum,"); strSql.Append("SellGoodsPrice=@SellGoodsPrice,"); strSql.Append("SellNeedPay=@SellNeedPay,"); strSql.Append("SellHasPay=@SellHasPay,"); strSql.Append("SellRemark=@SellRemark"); strSql.Append("Flag=@Flag"); strSql.Append("SellGoodsTime=@SellGoodsTime"); strSql.Append(" where SellID=@SellID "); SqlParameter[] parameters = { new SqlParameter("@SellID", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@DepotName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50), new SqlParameter("@SellGoodsNum", SqlDbType.Int), new SqlParameter("@SellGoodsPrice", SqlDbType.Float), new SqlParameter("@SellNeedPay", SqlDbType.Float), new SqlParameter("@SellHasPay", SqlDbType.Float), new SqlParameter("@SellRemark", SqlDbType.NVarChar, -1), new SqlParameter("@Flag", SqlDbType.Int), new SqlParameter("@SellGoodsTime", SqlDbType.DateTime) }; parameters[0].Value = model.SellID; parameters[1].Value = model.GoodsID; parameters[2].Value = model.EmployeeID; parameters[3].Value = model.CompanyName; parameters[4].Value = model.DepotName; parameters[5].Value = model.GoodsName; parameters[6].Value = model.SellGoodsNum; parameters[7].Value = model.SellGoodsPrice; parameters[8].Value = model.SellNeedPay; parameters[9].Value = model.SellHasPay; parameters[10].Value = model.SellRemark; parameters[11].Value = model.Flag; parameters[12].Value = model.SellGoodsTime; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
private void toolSave_Click(object sender, EventArgs e) { if (txtSellID.Text == "" || txtDepotName.Text == "" || txtGoodsID.Text == "" || txtGoodsName.Text == "" || txtdeSellPrice.Text == "" || txtSellNeedPay.Text == "" || txtdeSellHasPay.Text == "") { MessageBox.Show("请将信息添加完整!"); return; } Model.SellGoodsInfo model = new Model.SellGoodsInfo();//实例化model层 model.SellID = txtSellID.Text.Trim(); model.GoodsID = txtGoodsID.Text.Trim(); model.EmployeeID = cboEmpID.Text.Trim(); model.CompanyName = txtCompanyName.Text.Trim(); model.DepotName = txtDepotName.Text.Trim(); model.GoodsName = txtGoodsName.Text.Trim(); model.SellGoodsNum = int.Parse(numSellGoodsNum.Value.ToString()); model.SellGoodsTime = DateTime.Parse(this.DaSellGoodsTime.Text); model.SellGoodsPrice = txtdeSellPrice.Text.Trim(); model.SellNeedPay = txtSellNeedPay.Text.Trim(); model.SellHasPay = txtdeSellHasPay.Text.Trim(); model.SellRemark = txtSellRemark.Text.Trim(); BLL.SellGoodsInfo bll = new BLL.SellGoodsInfo();//实例化BLL层 Model.KCInfo kcInfo = new Model.KCInfo(); kcInfo.GoodsID = txtGoodsID.Text.Trim(); kcInfo.GoodsName = txtGoodsName.Text; kcInfo.DepotName = txtDepotName.Text.Trim(); kcInfo.CompanyName = txtCompanyName.Text.Trim(); string strWhere = " GoodsID = '" + kcInfo.GoodsID + "'"; BLL.KCInfo bllkcInfo = new BLL.KCInfo();//实例化BLL层 DataSet ds = new DataSet(); ds = bllkcInfo.GetList(strWhere); int sum = int.Parse(ds.Tables[0].Rows[0]["商品数量"].ToString()); kcInfo.GoodsNum = sum - int.Parse(numSellGoodsNum.Value.ToString()); switch (flag) { case 0: { } break; case 1: { if (bll.Add(model)) //将员工信息添加到数据库中,根据返回值判断是否添加成功 { DataBind(); //窗体登录时绑定数据到DataGridView ControlStatus(); } if (!bllkcInfo.Update(kcInfo)) { MessageBox.Show("未能够把数据添加到仓库中"); } } break; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.SellGoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SellGoodsInfo("); strSql.Append("SellID,GoodsID,EmployeeID,CompanyName,DepotName,GoodsName,SellGoodsNum,SellGoodsPrice,SellNeedPay,SellHasPay,SellRemark,Flag,SellGoodsTime)"); strSql.Append(" values ("); strSql.Append("@SellID,@GoodsID,@EmployeeID,@CompanyName,@DepotName,@GoodsName,@SellGoodsNum,@SellGoodsPrice,@SellNeedPay,@SellHasPay,@SellRemark,@Flag,@SellGoodsTime)"); SqlParameter[] parameters = { new SqlParameter("@SellID", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@DepotName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50), new SqlParameter("@SellGoodsNum", SqlDbType.Int), new SqlParameter("@SellGoodsPrice", SqlDbType.Float), new SqlParameter("@SellNeedPay", SqlDbType.Float), new SqlParameter("@SellHasPay", SqlDbType.Float), new SqlParameter("@SellRemark", SqlDbType.NVarChar, -1), new SqlParameter("@Flag", SqlDbType.Int), new SqlParameter("@SellGoodsTime", SqlDbType.DateTime) }; parameters[0].Value = model.SellID; parameters[1].Value = model.GoodsID; parameters[2].Value = model.EmployeeID; parameters[3].Value = model.CompanyName; parameters[4].Value = model.DepotName; parameters[5].Value = model.GoodsName; parameters[6].Value = model.SellGoodsNum; parameters[7].Value = model.SellGoodsPrice; parameters[8].Value = model.SellNeedPay; parameters[9].Value = model.SellHasPay; parameters[10].Value = model.SellRemark; parameters[11].Value = model.Flag; parameters[12].Value = model.SellGoodsTime; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(Model.SellGoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SellGoodsInfo "); strSql.Append(" where SellID=@SellID "); SqlParameter[] parameters = { new SqlParameter("@SellID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.SellID; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(Model.SellGoodsInfo model) { return(dal.Delete(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.SellGoodsInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.SellGoodsInfo model) { return(dal.Add(model)); }