public List <inputData> getConfirmData(string str_id)
{
List <inputData> insList = new List <inputData>();
string sql = @"SELECT goods_tmp.goods_name, pre_str_out_bill_detail.qty, pre_str_out_bill_detail.hwh
FROM pre_str_out_bill_detail INNER JOIN
goods_tmp ON pre_str_out_bill_detail.goods_id = goods_tmp.goods_id INNER JOIN
pre_str_out_bill ON
pre_str_out_bill_detail.str_out_bill_id = pre_str_out_bill.str_out_bill_id
WHERE (pre_str_out_bill.str_out_bill_id = '" + str_id + "')";
DataTable dt = new SelectCommandBuilder(constr, "").ExecuteDataTable(sql);
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
inputData indata = new inputData()
{
goods_name = dt.Rows[i]["goods_name"].ToString(),
Qty = Convert.ToInt32(dt.Rows[i]["qty"]),
goodsPost = dt.Rows[i]["hwh"].ToString()
};
insList.Add(indata);
}
}
return(insList);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string msg = inputValidate();
if (msg != "")
{
Response.Write("<script>alert('" + msg + "')</script>");
return;
}
SelectCommandBuilder select = new SelectCommandBuilder(constr, "goods_tmp");
select.SelectColumn("Count(*)");
select.ConditionsColumn("goods_name", goods_name.Value.Trim().ToUpper());
select.getSelectCommand();
int count = Convert.ToInt32(select.ExecuteScalar());
if (count == 0)
{
Response.Write("<script>alert('部番不存在')</script>");
return;
}
inputData indata = new inputData()
{
goods_name = goods_name.Value.Trim().ToUpper(),
Qty = int.Parse(qty.Value.Trim()),
unit = "pcs",
goodsPost = hwh.Value.Trim().ToUpper(),
batch = pch.Value.Trim().ToUpper()
};
insList.Add(indata);
gvData.DataSource = insList;
gvData.DataBind();
clearText();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string msg = inputValidate();
if (msg != "")
{
Response.Write("<script>alert('" + msg + "')</script>");
return;
}
SelectCommandBuilder select = new SelectCommandBuilder(constr, "goods_tmp");
select.SelectColumn("goods_id");
select.ConditionsColumn("goods_name", txtGoodsName.Text.Trim().ToUpper());
select.getSelectCommand();
DataTable dt = select.ExecuteDataTable();
string goods_id = "";
if (dt == null || dt.Rows.Count == 0)
{
Response.Write("<script>alert('部番不存在')</script>");
return;
}
else
{
goods_id = dt.Rows[0][0].ToString();
}
string sql = "SELECT sum( stock_remain.qty) as qty FROM batch INNER JOIN stock_remain ON batch.batch_id = stock_remain.batch_id where (batch.hwh = '" + hwh.Value.Trim().ToUpper() + "') AND (stock_remain.goods_id = '" + goods_id + "') group by stock_remain.goods_id,batch.hwh";
DataTable ddt = new SelectCommandBuilder(constr, "").ExecuteDataTable(sql);
if (ddt == null || ddt.Rows.Count == 0)
{
Response.Write("<script>alert('仓位错误')</script>");
hwh.Focus();
return;
}
else
{
if (Convert.ToInt32(qty.Value) > Convert.ToInt32(ddt.Rows[0]["qty"]))
{
Response.Write("<script>alert('仓位数量不足')</script>");
qty.Focus();
return;
}
}
inputData indata = new inputData()
{
goods_name = txtGoodsName.Text.Trim().ToUpper(),
Qty = int.Parse(qty.Value.Trim()),
unit = "pcs",
goodsPost = hwh.Value.Trim().ToUpper(),
};
insList.Add(indata);
gvData.DataSource = insList;
gvData.DataBind();
clearText();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string msg = inputValidate();
if (msg != "")
{
Response.Write("<script>alert('" + msg + "')</script>");
return;
}
inputData indata = new inputData()
{
goods_name = lblgoodsName.Text.Trim().ToUpper(),
Qty = int.Parse(qty.Value.Trim()),
unit = "pcs",
goodsPost = hwh.Value.Trim().ToUpper(),
batch = pch.Value.Trim().ToUpper()
};
insList.Add(indata);
gvData.DataSource = insList;
gvData.DataBind();
clearText();
}
