/// <summary> /// 增加一条数据 /// </summary> public bool Add(Warehousing.model.TStock model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.id != "") { strSql1.Append("id,"); strSql2.Append("" + model.id + ","); } if (model.code != null) { strSql1.Append("code,"); strSql2.Append("'" + model.code + "',"); } if (model.name != null) { strSql1.Append("name,"); strSql2.Append("'" + model.name + "',"); } if (model.spec != null) { strSql1.Append("spec,"); strSql2.Append("'" + model.spec + "',"); } if (model.unit != null) { strSql1.Append("unit,"); strSql2.Append("'" + model.unit + "',"); } if (model.price != null) { strSql1.Append("price,"); strSql2.Append("" + model.price + ","); } if (model.number != null) { strSql1.Append("number,"); strSql2.Append("" + model.number + ","); } strSql.Append("insert into TStock("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQLite.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
private void txtGoodId_EditValueChanged(object sender, EventArgs e) { bll.TStock bll = new bll.TStock(); model.TStock mod = bll.GetModel(txtGoodId.Text); if (null != mod) { txtCode.Text = mod.code; txtName.Text = mod.name; txtPrice.Text = mod.price + ""; txtSpec.Text = mod.spec; txtUnit.Text = mod.unit; } else { reset(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Warehousing.model.TStock GetModel(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" id,code,name,spec,unit,price,number "); strSql.Append(" from TStock "); strSql.Append(" where id='" + id + "'"); Warehousing.model.TStock model = new Warehousing.model.TStock(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Warehousing.model.TStock DataRowToModel(DataRow row) { Warehousing.model.TStock model = new Warehousing.model.TStock(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = row["id"].ToString(); } if (row["code"] != null) { model.code = row["code"].ToString(); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["spec"] != null) { model.spec = row["spec"].ToString(); } if (row["unit"] != null) { model.unit = row["unit"].ToString(); } if (row["price"] != null && row["price"].ToString() != "") { model.price = decimal.Parse(row["price"].ToString()); } if (row["number"] != null && row["number"].ToString() != "") { model.number = int.Parse(row["number"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Warehousing.model.TStock model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Warehousing.model.TStock model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Warehousing.model.TStock model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TStock set "); if (model.code != null) { strSql.Append("code='" + model.code + "',"); } else { strSql.Append("code= null ,"); } if (model.name != null) { strSql.Append("name='" + model.name + "',"); } else { strSql.Append("name= null ,"); } if (model.spec != null) { strSql.Append("spec='" + model.spec + "',"); } else { strSql.Append("spec= null ,"); } if (model.unit != null) { strSql.Append("unit='" + model.unit + "',"); } else { strSql.Append("unit= null ,"); } if (model.price != null) { strSql.Append("price=" + model.price + ","); } else { strSql.Append("price= null ,"); } if (model.number != null) { strSql.Append("number=" + model.number + ","); } else { strSql.Append("number= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where id=" + model.id + " "); int rowsAffected = DbHelperSQLite.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
private void btnSave_Click(object sender, EventArgs e) { if ("" == txtGoodId.Text) { MessageBox.Show("请填写一料一号"); return; } if ("" == txtCode.Text) { MessageBox.Show("请填写商品编码"); return; } if ("" == txtName.Text) { MessageBox.Show("请填写商品名称"); return; } if ("" == txtNumber.Text || 0 == int.Parse(txtNumber.Text)) { MessageBox.Show("请填写入库数量,不能为零"); return; } if ("" == txtPrice.Text) { MessageBox.Show("请填写商品商品价格"); return; } if ("" == txtSpec.Text) { MessageBox.Show("请填写规格型号"); return; } if ("" == txtUnit.Text) { MessageBox.Show("请填写计量单位"); return; } model.TStock mod = new model.TStock(); bll.TStock bll = new bll.TStock(); mod.id = txtGoodId.Text; mod.code = txtCode.Text; mod.name = txtName.Text; mod.number = int.Parse(txtNumber.Text); mod.price = decimal.Parse(txtPrice.Text); mod.spec = txtSpec.Text; mod.unit = txtUnit.Text; DialogResult dr = MessageBox.Show("确认入库 " + mod.number + mod.unit + "?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { bool isExists = bll.Exists(mod.id); bool isSuccess; if (isExists) { model.TStock dataRow = bll.GetModel(mod.id); mod.number = mod.number + dataRow.number; isSuccess = bll.Update(mod); } else { isSuccess = bll.Add(mod); } if (isSuccess) { MessageBox.Show("入库成功"); } else { MessageBox.Show("入库失败"); } reset(); txtGoodId.Text = ""; } }
private void btnSave_Click(object sender, EventArgs e) { if ("" == txtGoodId.Text) { MessageBox.Show("请填写一料一号"); return; } //if ("" == txtCode.Text) //{ // MessageBox.Show("请填写商品编码"); // return; //} //if ("" == txtName.Text) //{ // MessageBox.Show("请填写商品名称"); // return; //} //if ("" == txtNumber.Text) //{ // MessageBox.Show("请填写出库数量"); // return; //} //if ("" == txtPrice.Text) //{ // MessageBox.Show("请填写商品商品价格"); // return; //} //if ("" == txtSpec.Text) //{ // MessageBox.Show("请填写规格型号"); // return; //} //if ("" == txtUnit.Text) //{ // MessageBox.Show("请填写计量单位"); // return; //} //model.TStock mod = new model.TStock(); bll.TStock bll = new bll.TStock(); //mod.id = txtGoodId.Text; //mod.code = txtCode.Text; //mod.name = txtName.Text; //mod.number = int.Parse(txtNumber.Text); //mod.price = decimal.Parse(txtPrice.Text); //mod.spec = txtSpec.Text; //mod.unit = txtUnit.Text; bool isExists = bll.Exists(txtGoodId.Text); if (isExists) { if ("" == txtNumber.Text) { MessageBox.Show("请填写出库数量"); return; } model.TStock mod = new model.TStock(); mod.number = int.Parse(txtNumber.Text); model.TStock dataRow = bll.GetModel(txtGoodId.Text); if (0 < dataRow.number) { if (mod.number > dataRow.number) { MessageBox.Show("该商品库存为" + dataRow.number + dataRow.unit + ",无法出库" + mod.number + mod.unit); } else { mod.id = dataRow.id; mod.code = dataRow.code; mod.name = dataRow.name; mod.spec = dataRow.spec; mod.unit = dataRow.unit; mod.price = dataRow.price; DialogResult dr = MessageBox.Show("确认出库 " + mod.number + mod.unit + "?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { mod.number = dataRow.number - mod.number; if (bll.Update(mod)) { txtGoodId.Text = ""; reset(); MessageBox.Show("出库成功"); } else { MessageBox.Show("未知原因,出库失败"); } } } } else { MessageBox.Show("该商品库存为零,无法完成出库操作"); } } else { MessageBox.Show("未在仓库中查找到该商品,无法完成出库操作"); } }