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;
}