protected void BindData()
{
DBHelper dbhelper = new DBHelper(0);
DATA0002BLL bll = new DATA0002BLL(dbhelper);
string sqlwhere = " (UNIT_CODE like '%" + txt_code.Text + "%' or UNIT_NAME like '%" + txt_code.Text + "%')";
if (iswhere != "")
{
sqlwhere = iswhere + " and " + sqlwhere;
}
d02list = bll.FindBySql(sqlwhere);
dataGridView1.DataSource = d02list;
}
public void BinData(string strWhere)
{
try
{
DATA0002BLL bll = new DATA0002BLL(Frm.DBConnection);
IList <DATA0002> IL_DATA0002;
DataTable tb_GridView1;
DataRow dr;
tb_GridView1 = new DataTable();
tb_GridView1.Columns.Add("rkey");
tb_GridView1.Columns.Add("序");
tb_GridView1.Columns.Add("单位代码");
tb_GridView1.Columns.Add("单位名称");
IL_DATA0002 = bll.FindBySql("(" + strWhere + ") and ACTIVE_FLAG = 0");
for (int i = 0; i < IL_DATA0002.Count; i++)
{
dr = tb_GridView1.NewRow();
dr[0] = IL_DATA0002[i].RKEY.ToString();
dr[2] = IL_DATA0002[i].UNIT_CODE.Trim();
dr[3] = IL_DATA0002[i].UNIT_NAME.Trim();
tb_GridView1.Rows.Add(dr);
}
tb_GridView1.DefaultView.Sort = "单位代码 ASC";
tb_GridView1 = tb_GridView1.DefaultView.ToTable();
for (int i = 0; i < tb_GridView1.Rows.Count; i++)
{
tb_GridView1.Rows[i][1] = (i + 1).ToString("0000");
}
//dataGridView1.Columns.Clear();
Frm.dataGridView1.DataSource = tb_GridView1;
Frm.dataGridView1.Columns[0].Visible = false;
Frm.dataGridView1.Columns[1].Width = 50;
Frm.dataGridView1.Columns[1].ReadOnly = true;
Frm.dataGridView1.Columns[2].Width = 80;
Frm.dataGridView1.Columns[2].ReadOnly = true;
Frm.dataGridView1.Columns[3].Width = 270;
Frm.dataGridView1.Columns[3].ReadOnly = true;
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
public void BinData(string strWhere)
{
try
{
DATA0017BLL bll = new DATA0017BLL(Frm.DBConnection);
DATA0002BLL bllD02 = new DATA0002BLL(Frm.DBConnection);
DATA0002 infoD02 = new DATA0002();
DataTable tb, tb2;
DataTable tb_GridView1;
DataRow dr;
string s_SQL;
tb_GridView1 = new DataTable();
tb_GridView1.Columns.Add("地点");
tb_GridView1.Columns.Add("可用库存");
tb_GridView1.Columns.Add("已分配库存");
tb = bll.getDataSet("select * from data0017 with (nolock) where rkey = " + Frm.id_rkey.ToString());
infoD02 = bllD02.getDATA0002ByRKEY(decimal.Parse(tb.Rows[0]["STOCK_UNIT_PTR"].ToString().Trim()));
Frm.textBoxInv_Part_Number.Text = tb.Rows[0]["inv_part_number"].ToString().Trim();
Frm.labelInv_Part_Desc.Text = tb.Rows[0]["INV_PART_DESCRIPTION"].ToString().Trim();
Frm.labelInv_Unit.Text = infoD02.UNIT_NAME.Trim();
s_SQL = @"
select data0016.CODE,
data0016.LOCATION,
data0019.QUAN_ON_HAND,
data0019.QUAN_ALLOCATED
from DATA0019 with (nolock),DATA0017 with (nolock),DATA0018 with (nolock),data0016 with (nolock)
where data0019.INVENTORY_PTR = data0017.RKEY
and data0019.INV_WHOUSE_PTR = data0018.RKEY
and data0019.LOCATION_PTR = data0016.RKEY
and data0017.rkey = " + Frm.id_rkey.ToString() + @"
order by data0016.CODE
";
tb = bll.getDataSet(s_SQL);
s_SQL = @"
SELECT (SUM(D467.QUAN_ORD) - SUM(D467.QUAN_RECD) + SUM(D467.QUAN_RETN) + SUM(D467.QUAN_IN_INSP)) AS ROQTY
FROM DATA0467 D467 WITH (NOLOCK) , DATA0466 D466 WITH (NOLOCK)
WHERE D467.RO_PTR = D466.RKEY
AND D467.INVT_PTR = " + Frm.id_rkey.ToString() + @"
AND (D467.QUAN_ORD) - (D467.QUAN_RECD) + (D467.QUAN_RETN) + (D467.QUAN_IN_INSP) > 0.0
AND D466.STATUS = 1
";
tb2 = bll.getDataSet(s_SQL);
for (int i = 0; i < tb.Rows.Count; i++)
{
dr = tb_GridView1.NewRow();
dr[0] = tb.Rows[i]["LOCATION"].ToString().Trim();
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_ON_HAND"].ToString().Trim()).ToString("#0.00");
dr[2] = decimal.Parse(tb.Rows[0]["QUAN_ALLOCATED"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
}
Frm.dataGridView1.DataSource = tb_GridView1;
Frm.dataGridView1.Columns[0].Width = 150;
Frm.dataGridView1.Columns[0].ReadOnly = true;
Frm.dataGridView1.Columns[1].Width = 150;
Frm.dataGridView1.Columns[1].ReadOnly = true;
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
public void BinData(string strWhere)
{
try
{
DATA0017BLL bll = new DATA0017BLL(Frm.DBConnection);
DATA0002BLL bllD02 = new DATA0002BLL(Frm.DBConnection);
DATA0002 infoD02 = new DATA0002();
DataTable tb, tb2;
DataTable tb_GridView1, tb_GridView2;
DataRow dr;
string s_SQL;
tb_GridView1 = new DataTable();
tb_GridView1.Columns.Add("名称");
tb_GridView1.Columns.Add("库存");
tb_GridView2 = new DataTable();
tb_GridView2.Columns.Add("名称");
tb_GridView2.Columns.Add("库存");
tb = bll.getDataSet("select * from data0017 with (nolock) where rkey = " + Frm.id_rkey.ToString());
infoD02 = bllD02.getDATA0002ByRKEY(decimal.Parse(tb.Rows[0]["STOCK_UNIT_PTR"].ToString().Trim()));
Frm.textBoxInv_Part_Number.Text = tb.Rows[0]["inv_part_number"].ToString().Trim();
Frm.labelInv_Part_Desc.Text = tb.Rows[0]["INV_PART_DESCRIPTION"].ToString().Trim();
Frm.labelInv_Unit.Text = infoD02.UNIT_NAME.Trim();
s_SQL = @"
SELECT isnull((SUM(D467.QUAN_ORD) - SUM(D467.QUAN_RECD) + SUM(D467.QUAN_RETN) + SUM(D467.QUAN_IN_INSP)),0) AS ROQTY
FROM DATA0467 D467 WITH (NOLOCK) , DATA0466 D466 WITH (NOLOCK)
WHERE D467.RO_PTR = D466.RKEY
AND D467.INVT_PTR = " + Frm.id_rkey.ToString() + @"
AND (D467.QUAN_ORD) - (D467.QUAN_RECD) + (D467.QUAN_RETN) + (D467.QUAN_IN_INSP) > 0.0
AND D466.STATUS = 1
";
tb2 = bll.getDataSet(s_SQL);
Frm.groupBox1.Text = "仓库总库存：" + decimal.Parse(tb.Rows[0]["QUAN_ON_HAND"].ToString()).ToString("#0.00");
Frm.groupBox2.Text = "寄售仓总库存：" + decimal.Parse(tb.Rows[0]["CONSIGN_ONHAND_QTY"].ToString()).ToString("#0.00");
#region 仓库
dr = tb_GridView1.NewRow();
dr[0] = "在途数量";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_IN_TRANSIT"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "在检数量";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_IN_INSP"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "待入库数量";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_BACKLOG"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "可用库存";
dr[1] = (decimal.Parse(tb.Rows[0]["QUAN_ON_HAND"].ToString().Trim()) - decimal.Parse(tb.Rows[0]["QUAN_ALLOCATED"].ToString().Trim())).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "已分配库存";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_ALLOCATED"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
#endregion
#region 寄售
dr = tb_GridView2.NewRow();
dr[0] = "待检数量";
dr[1] = decimal.Parse(tb.Rows[0]["CONSIGN_QTY_IN_INSP"].ToString().Trim()).ToString("#0.00");
tb_GridView2.Rows.Add(dr);
dr = tb_GridView2.NewRow();
dr[0] = "开立RO数量";
if (tb2.Rows.Count > 0)
{
dr[1] = decimal.Parse(tb2.Rows[0]["ROQTY"].ToString().Trim()).ToString("#0.00");
}
else
{
dr[1] = "0";
}
tb_GridView2.Rows.Add(dr);
#endregion
Frm.dataGridView1.DataSource = tb_GridView1;
Frm.dataGridView1.Columns[0].Width = 150;
Frm.dataGridView1.Columns[0].ReadOnly = true;
Frm.dataGridView1.Columns[1].Width = 150;
Frm.dataGridView1.Columns[1].ReadOnly = true;
Frm.dataGridView2.DataSource = tb_GridView2;
Frm.dataGridView2.Columns[0].Width = 150;
Frm.dataGridView2.Columns[0].ReadOnly = true;
Frm.dataGridView2.Columns[1].Width = 150;
Frm.dataGridView2.Columns[1].ReadOnly = true;
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
