예제 #1
0
        private void GVBind()
        {
            comment_class1 cc1 = new comment_class1();

            GridView1.DataSource = cc1.QueryDataTable("select t1.cprj,t1.line,t1.nopr,t1.nloc,t1.emno,t2.t_name,t1.apdt from (ecsfc929_memb as t1 left join ecpsl010 as t2 on t1.emno=t2.t_empl) left join ecsfc000_emplrole as t3 on t1.emno=t3.empl where  t1.code is" + Session["mod"] + " null and pfc!='是' and t1.cprj like '%" + Global.gcprj + "%' and t1.line like '%" + Global.gline + "%' and t1.nloc like '%" + Global.gnopr + "%' " + Global.d1 + " order by t1.cprj,t1.nopr asc");
            GridView1.DataBind();
        }