// 盘点材料、产品库存,向原料、产品库存修正表中插入盘点过后的数据 /* * 方法名称:InsertPMaterial() * 方法功能描述:盘点材料库存,向原料库存修正表中插入盘点过后的数据 * * 创建人:冯雪 * 创建时间:2009-03-20 * * 修改人: * 修改时间: * 修改内容: * */ public bool InsertPMaterial(CheckStockClass checkstockClass) { return(stockCheckDB.InsertPMaterial(checkstockClass)); }
/* * 方法名称:InsertPProduct() * 方法功能描述:盘点产品库存,向产品库存修正表中插入盘点过后的数据 * * 创建人:冯雪 * 创建时间:2009-03-20 * * 修改人: * 修改时间: * 修改内容: * */ public bool InsertPProduct(CheckStockClass checkstockClass) { return(stockCheckDB.InsertPProduct(checkstockClass)); }
private void btnSave_Click(object sender, EventArgs e) { // 盘点数量、差异数量; CheckStockClass checkstockClass = new CheckStockClass(); if (formHelper.inputCheck(groupBox1)) { #region 取出盘点数据 if (!txtInventory.Text.Trim().Equals("")) { checkstockClass.CheckStock = decimal.Parse(txtInventory.Text.Trim()); } else { checkstockClass.CheckStock = 0; } if (!txtDiversity.Text.Trim().Equals("")) { checkstockClass.Balance = decimal.Parse(txtDiversity.Text.Trim()); } else { checkstockClass.Balance = 0; } checkstockClass.InputMan = this.userName; checkstockClass.InputDate = dtpCheck.Value.ToString(); if (!txtRetouch.Text.Trim().Equals("")) { checkstockClass.Retouch = decimal.Parse(txtRetouch.Text.Trim()); } else { checkstockClass.Retouch = 0; } if (!txtDCause.Text.Trim().Equals("")) { checkstockClass.Remark = txtDCause.Text.Trim(); } else { checkstockClass.Remark = ""; } if (!txtTheory.Text.Trim().Equals("")) { checkstockClass.RetouchStock = decimal.Parse(txtTheory.Text.Trim()) + checkstockClass.Retouch; } else { checkstockClass.RetouchStock = 0 + checkstockClass.Retouch; } #endregion if (rbtnPMaterial.Checked) { // 生成材料盘点数据 checkstockClass.MslId = Convert.ToInt64(stockCLogic.SearchPMQuantity(mId).Rows[0][2].ToString()); if (stockCLogic.InsertPMaterial(checkstockClass)) { MessageBox.Show("保存记录成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); clearAction(); set_dgvCheck(); return; } else { MessageBox.Show("保存记录失败,请从新操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { // 生成产品盘点数据 checkstockClass.PslId = Convert.ToInt64(stockCLogic.SearchPPSuttle(pid).Rows[0][2].ToString()); if (stockCLogic.InsertPProduct(checkstockClass)) { MessageBox.Show("保存记录成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); clearAction(); set_dgvCheck(); return; } else { MessageBox.Show("保存记录失败,请从新操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }