private void dgvCellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } optrowid = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); if (model != null) { BLL.tb_proc dalp = new BLL.tb_proc(); Model.tb_proc molp = new Model.tb_proc(); molp = dalp.GetModel(int.Parse(model.cr_pid.ToString())); this.txtno.Text = molp.p_no; this.txtname.Text = molp.p_name; this.txttyid.Text = model.cr_pid.ToString(); this.txtorder.SelectedValue = model.cr_oid.ToString(); this.txtprice.Text = model.cr_price.ToString(); this.txtrek.Text = model.cr_remark; this.txtnum.Text = model.cr_num.ToString(); this.txtstatus.SelectedValue = model.cr_yan.ToString(); } } }
private void dgvCellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } optrowid = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(Int32.Parse(optrowid)); if (model != null) { Model.tb_proc ml = new Model.tb_proc(); ml = dalt.GetModel(int.Parse(model.p_pid.ToString())); txtname.Text = ml.p_name; txtno.Text = ml.p_no; txttyid.Text = model.p_pid.ToString(); txttime.Text = model.p_time; txtnumold.Text = model.p_numold.ToString(); txtnumnow.Text = model.p_numnow.ToString(); txtuser.Text = model.p_user; txtrek.Text = model.p_remark; } } }
private void dgvCellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } optrowid = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(Int32.Parse(optrowid)); if (model != null) { txttype.Text = getStr(1, int.Parse(model.p_tyid.ToString())); txtck.Text = getStr(2, int.Parse(model.p_ckid.ToString())); txtkuqu.Text = getStr(2, int.Parse(model.p_kqid.ToString())); txtrzsj.Text = getStr(4, int.Parse(model.p_rzfid.ToString())); txttyid.Text = model.p_tyid.ToString(); txtckid.Text = model.p_ckid.ToString(); txtkqid.Text = model.p_kqid.ToString(); txtrzsjid.Text = model.p_rzfid.ToString(); txtno.Text = model.p_no; txtname.Text = model.p_name; txtprice.Text = model.p_price; txtchjia.Text = model.p_shang; txtunit.SelectedText = model.p_unit; txtppai.Text = model.p_pinpai; txtmodel.Text = model.p_model; } } }
private void dgvCellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } optrowid = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); if (model != null) { this.txtno.Text = model.p_no; this.txtname.Text = model.p_name; this.txtsx.Text = model.p_sx; this.txtxx.Text = model.p_xx; } } }
private void tbBtnClick(object sender, ToolBarButtonClickEventArgs e) { if (e.Button.ToolTipText == "新增") { rstValue(); setModifyMode(true); optrowid = null; } if (e.Button.ToolTipText == "修改") { if (!String.IsNullOrEmpty(optrowid)) { setModifyMode(true); } else { MessageBox.Show("请选择所要修改的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "删除") { if (!String.IsNullOrEmpty(optrowid)) { DialogResult result = MessageBox.Show("确认删除?", "删除数据", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { dal.Delete(int.Parse(optrowid)); rstValue(); MessageBox.Show("恭喜你,删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); bindData("cr_type=1"); setModifyMode(false); optrowid = null; } } else { MessageBox.Show("请选择所要删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "提交") { if (ValidateIput()) { model = new Model.tb_churu(); if (!string.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); } model.cr_oid = int.Parse(this.txtorder.SelectedValue.ToString()); model.cr_pid = int.Parse(txttyid.Text); model.cr_price = decimal.Parse(txtprice.Text); model.cr_remark = txtrek.Text; model.cr_type = 1; model.cr_yan = int.Parse(this.txtstatus.SelectedValue.ToString()); int tempNum = int.Parse(this.txtnum.Text); if (tempNum <= 0) { MessageBox.Show("输入数量有误,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } model.cr_num = tempNum; if (String.IsNullOrEmpty(optrowid)) { model.cr_time = System.DateTime.Now.ToString("yyyy-MM-dd"); if (dal.Add(model) > 0) { BLL.tb_proc dap = new BLL.tb_proc(); Model.tb_proc mop = new Model.tb_proc(); mop = dap.GetModel(int.Parse(txttyid.Text)); if (model.cr_yan == 1) { mop.p_num = mop.p_num + int.Parse(this.txtnum.Text); //验收状态:是 } else { mop.p_num = mop.p_num + 0; //验收状态:否 } if (!string.IsNullOrEmpty(mop.p_sx)) { if (mop.p_num > int.Parse(mop.p_sx)) { MessageBox.Show("已超过库存预警上限,请更换", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } dap.Update(mop); if (model.cr_yan == 1) { MessageBox.Show("恭喜你,验收入库成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //验收状态:是 } else { MessageBox.Show("商品验收入库失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //验收状态:否 } rstValue(); bindData("cr_type=1"); setModifyMode(false); optrowid = null; } } else { if (dal.Update(model)) { MessageBox.Show("恭喜你,修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData("cr_type=1"); setModifyMode(false); optrowid = null; } } } } if (e.Button.ToolTipText == "取消") { bindData("cr_type=1"); rstValue(); setModifyMode(false); optrowid = null; } if (e.Button.ToolTipText == "退出") { this.Close(); } }
private void tbBtnClick(object sender, ToolBarButtonClickEventArgs e) { if (e.Button.ToolTipText == "新增") { rstValue(); setModifyMode(true); optrowid = null; } if (e.Button.ToolTipText == "修改") { if (!String.IsNullOrEmpty(optrowid)) { setModifyMode(true); } else { MessageBox.Show("请选择所要修改的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "删除") { if (!String.IsNullOrEmpty(optrowid)) { DialogResult result = MessageBox.Show("确认删除?", "删除数据", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { dal.Delete(int.Parse(optrowid)); rstValue(); MessageBox.Show("恭喜你,删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); bindData(""); setModifyMode(false); optrowid = null; } } else { MessageBox.Show("请选择所要删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "提交") { if (validateIput()) { model = new Model.tb_proc(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); } model.p_no = this.txtno.Text; model.p_name = this.txtname.Text; model.p_pinpai = this.txtppai.Text; model.p_model = this.txtmodel.Text; model.p_price = this.txtprice.Text; model.p_shang = txtchjia.Text; model.p_unit = txtunit.Text; model.p_ckid = int.Parse(this.txtckid.Text); model.p_kqid = int.Parse(this.txtkqid.Text); model.p_tyid = int.Parse(this.txttyid.Text); model.p_rzfid = int.Parse(this.txtrzsjid.Text); if (String.IsNullOrEmpty(optrowid)) { model.p_addtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm"); int i = dal.Add(model); if (i > 0) { MessageBox.Show("恭喜你,新增成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(""); setModifyMode(false); optrowid = null; } } else { if (dal.Update(model)) { MessageBox.Show("恭喜你,修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(""); setModifyMode(false); optrowid = null; } } } } if (e.Button.ToolTipText == "取消") { bindData(""); rstValue(); setModifyMode(false); optrowid = null; } if (e.Button.ToolTipText == "退出") { this.Close(); } }
private void tbBtnClick(object sender, ToolBarButtonClickEventArgs e) { if (e.Button.ToolTipText == "新增") { rstValue(); setModifyMode(true); optrowid = null; } if (e.Button.ToolTipText == "修改") { if (!String.IsNullOrEmpty(optrowid)) { setModifyMode(true); } else { MessageBox.Show("请选择所要修改的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "删除") { if (!String.IsNullOrEmpty(optrowid)) { DialogResult result = MessageBox.Show("确认删除?", "删除数据", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { dal.Delete(int.Parse(optrowid)); rstValue(); MessageBox.Show("恭喜你,删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); bindData(""); setModifyMode(false); optrowid = null; } } else { MessageBox.Show("请选择所要删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "提交") { if (validateInput()) { model = new Model.tb_pan(); if (!String.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); } model.p_pid = int.Parse(this.txttyid.Text); model.p_time = this.txttime.Text; int tempNumold = int.Parse(this.txtnumold.Text); if (tempNumold < 0) { MessageBox.Show("输入数量有误,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } model.p_numold = tempNumold; int tempNumnow = int.Parse(this.txtnumnow.Text); if (tempNumnow < 0) { MessageBox.Show("输入数量有误,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } model.p_numnow = tempNumnow; model.p_user = txtuser.Text; model.p_remark = this.txtrek.Text; if (String.IsNullOrEmpty(optrowid)) { int i = dal.Add(model); if (i > 0) { BLL.tb_proc dalp = new BLL.tb_proc(); Model.tb_proc molp = new Model.tb_proc(); molp = dalp.GetModel(int.Parse(model.p_pid.ToString())); molp.p_num = model.p_numnow; dalp.Update(molp); MessageBox.Show("恭喜你,新增成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(""); setModifyMode(false); optrowid = null; } } else { if (dal.Update(model)) { BLL.tb_proc dalp = new BLL.tb_proc(); Model.tb_proc molp = new Model.tb_proc(); molp = dalp.GetModel(int.Parse(model.p_pid.ToString())); molp.p_num = model.p_numnow; dalp.Update(molp); MessageBox.Show("恭喜你,修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(""); setModifyMode(false); optrowid = null; } } } } if (e.Button.ToolTipText == "取消") { bindData(""); rstValue(); setModifyMode(false); optrowid = null; } if (e.Button.ToolTipText == "退出") { this.Close(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.tb_proc model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.p_no != null) { strSql1.Append("p_no,"); strSql2.Append("'" + model.p_no + "',"); } if (model.p_name != null) { strSql1.Append("p_name,"); strSql2.Append("'" + model.p_name + "',"); } if (model.p_tyid != null) { strSql1.Append("p_tyid,"); strSql2.Append("" + model.p_tyid + ","); } if (model.p_pinpai != null) { strSql1.Append("p_pinpai,"); strSql2.Append("'" + model.p_pinpai + "',"); } if (model.p_model != null) { strSql1.Append("p_model,"); strSql2.Append("'" + model.p_model + "',"); } if (model.p_shang != null) { strSql1.Append("p_shang,"); strSql2.Append("'" + model.p_shang + "',"); } if (model.p_price != null) { strSql1.Append("p_price,"); strSql2.Append("'" + model.p_price + "',"); } if (model.p_unit != null) { strSql1.Append("p_unit,"); strSql2.Append("'" + model.p_unit + "',"); } if (model.p_sx != null) { strSql1.Append("p_sx,"); strSql2.Append("'" + model.p_sx + "',"); } if (model.p_xx != null) { strSql1.Append("p_xx,"); strSql2.Append("'" + model.p_xx + "',"); } if (model.p_desc != null) { strSql1.Append("p_desc,"); strSql2.Append("'" + model.p_desc + "',"); } if (model.p_addtime != null) { strSql1.Append("p_addtime,"); strSql2.Append("'" + model.p_addtime + "',"); } if (model.p_ckid != null) { strSql1.Append("p_ckid,"); strSql2.Append("" + model.p_ckid + ","); } if (model.p_kqid != null) { strSql1.Append("p_kqid,"); strSql2.Append("" + model.p_kqid + ","); } if (model.p_num != null) { strSql1.Append("p_num,"); strSql2.Append("" + model.p_num + ","); } if (model.p_rzfid != null) { strSql1.Append("p_rzfid,"); strSql2.Append("" + model.p_rzfid + ","); } strSql.Append("insert into tb_proc("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.tb_proc GetModel(int p_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" p_id,p_no,p_name,p_tyid,p_pinpai,p_model,p_shang,p_price,p_unit,p_sx,p_xx,p_desc,p_addtime,p_ckid,p_kqid,p_num,p_rzfid "); strSql.Append(" from tb_proc "); strSql.Append(" where p_id=" + p_id + ""); Model.tb_proc model = new Model.tb_proc(); DataSet ds = DbSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["p_id"] != null && ds.Tables[0].Rows[0]["p_id"].ToString() != "") { model.p_id = int.Parse(ds.Tables[0].Rows[0]["p_id"].ToString()); } if (ds.Tables[0].Rows[0]["p_no"] != null && ds.Tables[0].Rows[0]["p_no"].ToString() != "") { model.p_no = ds.Tables[0].Rows[0]["p_no"].ToString(); } if (ds.Tables[0].Rows[0]["p_name"] != null && ds.Tables[0].Rows[0]["p_name"].ToString() != "") { model.p_name = ds.Tables[0].Rows[0]["p_name"].ToString(); } if (ds.Tables[0].Rows[0]["p_tyid"] != null && ds.Tables[0].Rows[0]["p_tyid"].ToString() != "") { model.p_tyid = int.Parse(ds.Tables[0].Rows[0]["p_tyid"].ToString()); } if (ds.Tables[0].Rows[0]["p_pinpai"] != null && ds.Tables[0].Rows[0]["p_pinpai"].ToString() != "") { model.p_pinpai = ds.Tables[0].Rows[0]["p_pinpai"].ToString(); } if (ds.Tables[0].Rows[0]["p_model"] != null && ds.Tables[0].Rows[0]["p_model"].ToString() != "") { model.p_model = ds.Tables[0].Rows[0]["p_model"].ToString(); } if (ds.Tables[0].Rows[0]["p_shang"] != null && ds.Tables[0].Rows[0]["p_shang"].ToString() != "") { model.p_shang = ds.Tables[0].Rows[0]["p_shang"].ToString(); } if (ds.Tables[0].Rows[0]["p_price"] != null && ds.Tables[0].Rows[0]["p_price"].ToString() != "") { model.p_price = ds.Tables[0].Rows[0]["p_price"].ToString(); } if (ds.Tables[0].Rows[0]["p_unit"] != null && ds.Tables[0].Rows[0]["p_unit"].ToString() != "") { model.p_unit = ds.Tables[0].Rows[0]["p_unit"].ToString(); } if (ds.Tables[0].Rows[0]["p_sx"] != null && ds.Tables[0].Rows[0]["p_sx"].ToString() != "") { model.p_sx = ds.Tables[0].Rows[0]["p_sx"].ToString(); } if (ds.Tables[0].Rows[0]["p_xx"] != null && ds.Tables[0].Rows[0]["p_xx"].ToString() != "") { model.p_xx = ds.Tables[0].Rows[0]["p_xx"].ToString(); } if (ds.Tables[0].Rows[0]["p_desc"] != null && ds.Tables[0].Rows[0]["p_desc"].ToString() != "") { model.p_desc = ds.Tables[0].Rows[0]["p_desc"].ToString(); } if (ds.Tables[0].Rows[0]["p_addtime"] != null && ds.Tables[0].Rows[0]["p_addtime"].ToString() != "") { model.p_addtime = ds.Tables[0].Rows[0]["p_addtime"].ToString(); } if (ds.Tables[0].Rows[0]["p_ckid"] != null && ds.Tables[0].Rows[0]["p_ckid"].ToString() != "") { model.p_ckid = int.Parse(ds.Tables[0].Rows[0]["p_ckid"].ToString()); } if (ds.Tables[0].Rows[0]["p_kqid"] != null && ds.Tables[0].Rows[0]["p_kqid"].ToString() != "") { model.p_kqid = int.Parse(ds.Tables[0].Rows[0]["p_kqid"].ToString()); } if (ds.Tables[0].Rows[0]["p_num"] != null && ds.Tables[0].Rows[0]["p_num"].ToString() != "") { model.p_num = int.Parse(ds.Tables[0].Rows[0]["p_num"].ToString()); } if (ds.Tables[0].Rows[0]["p_rzfid"] != null && ds.Tables[0].Rows[0]["p_rzfid"].ToString() != "") { model.p_rzfid = int.Parse(ds.Tables[0].Rows[0]["p_rzfid"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.tb_proc model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_proc set "); if (model.p_no != null) { strSql.Append("p_no='" + model.p_no + "',"); } else { strSql.Append("p_no= null ,"); } if (model.p_name != null) { strSql.Append("p_name='" + model.p_name + "',"); } else { strSql.Append("p_name= null ,"); } if (model.p_tyid != null) { strSql.Append("p_tyid=" + model.p_tyid + ","); } else { strSql.Append("p_tyid= null ,"); } if (model.p_pinpai != null) { strSql.Append("p_pinpai='" + model.p_pinpai + "',"); } else { strSql.Append("p_pinpai= null ,"); } if (model.p_model != null) { strSql.Append("p_model='" + model.p_model + "',"); } else { strSql.Append("p_model= null ,"); } if (model.p_shang != null) { strSql.Append("p_shang='" + model.p_shang + "',"); } else { strSql.Append("p_shang= null ,"); } if (model.p_price != null) { strSql.Append("p_price='" + model.p_price + "',"); } else { strSql.Append("p_price= null ,"); } if (model.p_unit != null) { strSql.Append("p_unit='" + model.p_unit + "',"); } else { strSql.Append("p_unit= null ,"); } if (model.p_sx != null) { strSql.Append("p_sx='" + model.p_sx + "',"); } else { strSql.Append("p_sx= null ,"); } if (model.p_xx != null) { strSql.Append("p_xx='" + model.p_xx + "',"); } else { strSql.Append("p_xx= null ,"); } if (model.p_desc != null) { strSql.Append("p_desc='" + model.p_desc + "',"); } else { strSql.Append("p_desc= null ,"); } if (model.p_addtime != null) { strSql.Append("p_addtime='" + model.p_addtime + "',"); } else { strSql.Append("p_addtime= null ,"); } if (model.p_ckid != null) { strSql.Append("p_ckid=" + model.p_ckid + ","); } else { strSql.Append("p_ckid= null ,"); } if (model.p_kqid != null) { strSql.Append("p_kqid=" + model.p_kqid + ","); } else { strSql.Append("p_kqid= null ,"); } if (model.p_num != null) { strSql.Append("p_num=" + model.p_num + ","); } else { strSql.Append("p_num= null ,"); } if (model.p_rzfid != null) { strSql.Append("p_rzfid=" + model.p_rzfid + ","); } else { strSql.Append("p_rzfid= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where p_id=" + model.p_id + ""); int rowsAffected = DbSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
private void tbBtnClick(object sender, ToolBarButtonClickEventArgs e) { if (e.Button.ToolTipText == "修改") { if (!String.IsNullOrEmpty(optrowid)) { setModifyMode(true); } else { MessageBox.Show("请选择所要修改的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "提交") { if (validateIput()) { model = new Model.tb_proc(); if (!string.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); } if (!string.IsNullOrEmpty(this.txtsx.Text)) { int tempSx = int.Parse(this.txtsx.Text); if (tempSx < 0) { MessageBox.Show("预警上限数量输入有误,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } model.p_sx = tempSx + ""; } else { model.p_xx = ""; } if (!string.IsNullOrEmpty(this.txtxx.Text)) { int tempXx = int.Parse(this.txtxx.Text); if (tempXx < 0) { MessageBox.Show("预警下限数量输入有误,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } model.p_xx = tempXx + ""; } else { model.p_xx = ""; } if (!String.IsNullOrEmpty(optrowid)) { if (dal.Update(model)) { MessageBox.Show("恭喜你,修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData(""); setModifyMode(false); optrowid = null; } } } } if (e.Button.ToolTipText == "取消") { bindData(""); rstValue(); setModifyMode(false); optrowid = null; } if (e.Button.ToolTipText == "退出") { this.Close(); } }
private void tbBtnClick(object sender, ToolBarButtonClickEventArgs e) { if (e.Button.ToolTipText == "新增") { rstValue(); setModifyMode(true); optrowid = null; } if (e.Button.ToolTipText == "修改") { if (!String.IsNullOrEmpty(optrowid)) { setModifyMode(true); } else { MessageBox.Show("请选择所要修改的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "删除") { if (!String.IsNullOrEmpty(optrowid)) { DialogResult result = MessageBox.Show("确认删除?", "删除数据", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { dal.Delete(int.Parse(optrowid)); rstValue(); MessageBox.Show("恭喜你,删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); bindData("cr_type=3"); setModifyMode(false); optrowid = null; } } else { MessageBox.Show("请选择所要删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Button.ToolTipText == "提交") { if (validateInput()) { model = new Model.tb_churu(); if (!string.IsNullOrEmpty(optrowid)) { model = dal.GetModel(int.Parse(optrowid)); } model.cr_pid = int.Parse(txttyid.Text); model.cr_remark = txtdesc.Text; model.cr_type = 3; int tempNum = int.Parse(this.txtnum.Text); if (tempNum <= 0) { MessageBox.Show("输入数量有误,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } model.cr_num = tempNum; if (String.IsNullOrEmpty(optrowid)) { model.cr_time = System.DateTime.Now.ToString("yyyy-MM-dd"); Model.tb_proc mop = new Model.tb_proc(); BLL.tb_proc dap = new BLL.tb_proc(); mop = dap.GetModel(int.Parse(txttyid.Text)); if (mop.p_num < int.Parse(this.txtnum.Text)) { MessageBox.Show("库存不足,请更换", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { if (!string.IsNullOrEmpty(mop.p_xx)) { if (mop.p_num < int.Parse(mop.p_xx)) { MessageBox.Show("已达到库存预警下限", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } if (dal.Add(model) > 0) { mop.p_num = mop.p_num - int.Parse(this.txtnum.Text); dap.Update(mop); MessageBox.Show("恭喜你,报废成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData("cr_type=3"); setModifyMode(false); optrowid = null; } } } else { if (dal.Update(model)) { MessageBox.Show("恭喜你,修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); rstValue(); bindData("cr_type=3"); setModifyMode(false); optrowid = null; } } } } if (e.Button.ToolTipText == "取消") { bindData("cr_type=3"); rstValue(); setModifyMode(false); optrowid = null; } if (e.Button.ToolTipText == "退出") { this.Close(); } }