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) { txtOderNo.Text = model.o_no; txtkhid.Text = model.o_busy.ToString(); modelz = dalz.GetModel((int)model.o_busy); txtCustomer.Text = modelz.h_name; txtsum.Text = model.o_sum; txtdesc.Text = model.o_desc; txtuser.Text = model.o_user; txtnum.Text = model.o_num + ""; DataTable dt = dalt.GetList(" p_id='" + model.o_pid + "'").Tables[0]; if (dt.Rows.Count > 0) { txtname.Text = dt.Rows[0]["p_name"].ToString(); txtProdNo.Text = dt.Rows[0]["p_no"].ToString(); } } } }
private void getStr(string _no) { string reStr = ""; if (!string.IsNullOrEmpty(_no)) { //DataTable dt = dalt.GetList(" p_no='" + _no + "' and p_rzfid=" + txtorder.SelectedValue).Tables[0]; DataTable dt = dalt.GetList(" p_no='" + _no + "' ").Tables[0]; if (dt.Rows.Count == 0) { MessageBox.Show("该超市无此商品"); return; } else { int num = Convert.ToInt32(dt.Rows[0]["p_num"]); if (num > 0) { txttyid.Text = dt.Rows[0]["p_id"].ToString(); reStr = dt.Rows.Count > 0 ? dt.Rows[0]["p_name"].ToString() : ""; txtname.Text = reStr; } else { MessageBox.Show("该商品无库存"); return; } } } }
private string getStr(string _no) { string reStr = ""; if (!string.IsNullOrEmpty(_no)) { DataTable dt = dalt.GetList(" p_no='" + _no + "' ").Tables[0]; txttyid.Text = dt.Rows[0]["p_id"].ToString(); txtnumold.Text = dt.Rows[0]["p_num"].ToString(); reStr = dt.Rows.Count > 0 ? dt.Rows[0]["p_name"].ToString() : ""; } return(reStr); }
private void getStr(string no) { string reStr = ""; if (!string.IsNullOrEmpty(no)) { DataTable dt = dalt.GetList(" p_no='" + no + "'").Tables[0]; if (dt.Rows.Count == 0) { MessageBox.Show("无此商品"); return; } txttyid.Text = dt.Rows[0]["p_id"].ToString(); reStr = dt.Rows.Count > 0 ? dt.Rows[0]["p_name"].ToString() : ""; txtname.Text = reStr; } }
private void getStr(string _no) { mode = der.GetModel(Convert.ToInt32(txtorder.SelectedValue)); String provider = Convert.ToString(mode.o_busy); string reStr = ""; if (!string.IsNullOrEmpty(_no)) { //DataTable dt = dalt.GetList(" p_no='" + _no + "' and p_rzfid=" + txtorder.SelectedValue).Tables[0]; DataTable dt = dalt.GetList(" p_no='" + _no + "' and p_rzfid=" + provider).Tables[0]; if (dt.Rows.Count == 0) { MessageBox.Show("该订单所属商家下无此商品"); return; } txttyid.Text = dt.Rows[0]["p_id"].ToString(); reStr = dt.Rows.Count > 0 ? dt.Rows[0]["p_name"].ToString() : ""; txtname.Text = reStr; } }
private void bindData(string where) { DataSet ds = dal.GetList(String.IsNullOrEmpty(where) ? " " : where); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[1].HeaderText = "商品编号"; dataGridView1.Columns[2].HeaderText = "商品名称"; dataGridView1.Columns[3].Visible = false; dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; dataGridView1.Columns[6].Visible = false; dataGridView1.Columns[7].Visible = false; dataGridView1.Columns[8].Visible = false; dataGridView1.Columns[9].HeaderText = "预警上限"; dataGridView1.Columns[10].HeaderText = "预警下限"; dataGridView1.Columns[11].Visible = false; dataGridView1.Columns[12].Visible = false; dataGridView1.Columns[13].Visible = false; dataGridView1.Columns[14].Visible = false; dataGridView1.Columns[15].Visible = false; dataGridView1.Columns[16].Visible = false; }