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