public void BinData(string strWhere)
{
try
{
DATA0038BLL bll = new DATA0038BLL(Frm.DBConnection);
string s_SQL;
DataTable tb_GridView1;
tb_GridView1 = new DataTable();
tb_GridView1.Columns.Add("rkey");
tb_GridView1.Columns.Add("制程");
tb_GridView1.Columns.Add("部门代码");
tb_GridView1.Columns.Add("部门名称");
tb_GridView1.Columns.Add("权重");
tb_GridView1.Columns.Add("多重单位");
tb_GridView1.Columns.Add("事务处理");
s_SQL = @"
select data0038.rkey,
data0038.STEP_NUMBER as 制程,
data0034.DEPT_CODE as 部门代码,
data0034.DEPT_NAME as 部门名称,
cast(data0038.PERCENT_COMPLETE as numeric(14,2)) as 权重,
case when data0038.UNIT_FLAG = 'Y' then '是' else '否' end as 多重单位,
'否' as 事务处理
from data0038 with (nolock)
left join data0034 with (nolock) on data0034.rkey = data0038.DEPT_PTR
where data0038.TTYPE = " + Frm.ReceiveValue.Trim().Split('|')[1] + @"
AND data0038.STEP_NUMBER > 0
AND (" + strWhere + @")
AND DATA0038.SOURCE_PTR = " + Frm.ReceiveValue.Trim().Split('|')[0] + @"
order by data0038.STEP_NUMBER
";
tb_GridView1 = bll.getDataSet(s_SQL);
tb_GridView1 = tb_GridView1.DefaultView.ToTable();
//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;
Frm.dataGridView1.Columns[4].HeaderText += "%";
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
/// <summary>
/// 加载流程列表
/// </summary>
/// <param name="TTYPE"></param>
/// <param name="SOURCE_PTR"></param>
private void BindData(decimal SOURCE_PTR)
{
DBHelper dbhelper = new DBHelper(frm);
DATA0038BLL d38bll = new DATA0038BLL(dbhelper);
DataTable dt_38list = d38bll.GetRouteList(2, SOURCE_PTR);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dt_38list;
}
