private void DataPlay(int PageNo) { //得到当前模块对应的role HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value); string ls_role = "Role9999"; if (dt_mudel.Rows.Count > 0) ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString(); //根据表ID和模块ID得到当前传进来的模块是否有流程 HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value); //判断当前用户是否有删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (dttableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //如果有流程的话,新建按钮就一直显示,不用作判断的,只要判断删除按钮就行。 if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.delcontrol.Visible = false; this.newcontrol.Visible = false; this.copycontrol.Visible = false; //流程模块暂时都不能复制 } else { this.isrole.Value = "0"; this.newcontrol.Visible = false; } } else { //如果非流程(授权用户统一管理) if(dttableconfig.Rows[0]["hy_tablerole"].ToString() == "0") { if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.newcontrol.Visible = false; this.delcontrol.Visible = false; this.copycontrol.Visible = false; } else { this.isrole.Value = "0"; } } //如果非流程(每个人管理自己的信息) if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1") { this.isrole.Value = "1"; this.newcontrol.Visible = false; this.delcontrol_my.Visible = false; this.copycontrol.Visible = false; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "2") { if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.newcontrol.Visible = false; this.delcontrol.Visible = false; this.copycontrol.Visible = false; } else { this.isrole.Value = "0"; this.newcontrol.Visible = false; this.delcontrol_my.Visible = false; this.copycontrol.Visible = false; } } } //得到当前页号 this.lbdisplaytitle.Text = ""; this.curpage.Text = PageNo.ToString(); //---查询条件---开始 HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); Hyoa_flowmain.hy_mudelid = this.txtmudelid.Value; Hyoa_flowmain.hy_tableid = this.txttableid.Value; Hyoa_flowmain.hy_bt = this.hy_bt.Text; Hyoa_flowmain.hy_djrname = this.hy_djrname.Text; Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text; Hyoa_flowmain.hy_djsj_start = this.hy_djsj_start.Text; Hyoa_flowmain.hy_djsj_end = this.hy_djsj_end.Text; Hyoa_flowmain.hy_bt = this.hy_bt.Text; Hyoa_flowmain.hy_content1 = this.hy_content1.Text; Hyoa_flowmain.hy_content2 = this.hy_content2.Text; Hyoa_flowmain.hy_content3 = this.hy_content3.Text; Hyoa_flowmain.hy_content4 = this.hy_content4.Text; Hyoa_flowmain.hy_content5 = this.hy_content5.Text; Hyoa_flowmain.hy_field1 = this.hy_field1.Text; Hyoa_flowmain.hy_field2 = this.hy_field2.Text; Hyoa_flowmain.hy_field3 = this.hy_field3.Text; Hyoa_flowmain.hy_field4 = this.hy_field4.Text; Hyoa_flowmain.hy_field5 = this.hy_field5.Text; Hyoa_flowmain.hy_field6 = this.hy_field6.Text; Hyoa_flowmain.hy_field7 = this.hy_field7.Text; Hyoa_flowmain.hy_field8 = this.hy_field8.Text; Hyoa_flowmain.hy_field9 = this.hy_field9.Text; Hyoa_flowmain.hy_field10 = this.hy_field10.Text; Hyoa_flowmain.hy_field11 = this.hy_field11.Text; Hyoa_flowmain.hy_field12 = this.hy_field12.Text; Hyoa_flowmain.hy_field13 = this.hy_field13.Text; Hyoa_flowmain.hy_field14 = this.hy_field14.Text; Hyoa_flowmain.hy_field15 = this.hy_field15.Text; Hyoa_flowmain.hy_field16 = this.hy_field16.Text; Hyoa_flowmain.hy_field17 = this.hy_field17.Text; Hyoa_flowmain.hy_field18 = this.hy_field18.Text; Hyoa_flowmain.hy_field19 = this.hy_field19.Text; Hyoa_flowmain.hy_field20 = this.hy_field20.Text; Hyoa_flowmain.hy_field21 = this.hy_field21.Text; Hyoa_flowmain.hy_field22 = this.hy_field22.Text; Hyoa_flowmain.hy_field23 = this.hy_field23.Text; Hyoa_flowmain.hy_field24 = this.hy_field24.Text; Hyoa_flowmain.hy_field25 = this.hy_field25.Text; Hyoa_flowmain.hy_field26 = this.hy_field26.Text; Hyoa_flowmain.hy_field27 = this.hy_field27.Text; Hyoa_flowmain.hy_field28 = this.hy_field28.Text; Hyoa_flowmain.hy_field29 = this.hy_field29.Text; Hyoa_flowmain.hy_field30 = this.hy_field30.Text; Hyoa_flowmain.hy_field31_start = this.hy_field31_start.Text; Hyoa_flowmain.hy_field32_start = this.hy_field32_start.Text; Hyoa_flowmain.hy_field33_start = this.hy_field33_start.Text; Hyoa_flowmain.hy_field34_start = this.hy_field34_start.Text; Hyoa_flowmain.hy_field35_start = this.hy_field35_start.Text; Hyoa_flowmain.hy_field31_end = this.hy_field31_end.Text; Hyoa_flowmain.hy_field32_end = this.hy_field32_end.Text; Hyoa_flowmain.hy_field33_end = this.hy_field33_end.Text; Hyoa_flowmain.hy_field34_end = this.hy_field34_end.Text; Hyoa_flowmain.hy_field35_end = this.hy_field35_end.Text; if (this.hy_field36_start.Text == "") { this.hy_field36_start.Text = "0"; } if (this.hy_field37_start.Text == "") { this.hy_field37_start.Text = "0"; } if (this.hy_field38_start.Text == "") { this.hy_field38_start.Text = "0"; } if (this.hy_field39_start.Text == "") { this.hy_field39_start.Text = "0"; } if (this.hy_field40_start.Text == "") { this.hy_field40_start.Text = "0"; } if (this.hy_field36_end.Text == "") { this.hy_field36_end.Text = "0"; } if (this.hy_field37_end.Text == "") { this.hy_field37_end.Text = "0"; } if (this.hy_field38_end.Text == "") { this.hy_field38_end.Text = "0"; } if (this.hy_field39_end.Text == "") { this.hy_field39_end.Text = "0"; } if (this.hy_field40_end.Text == "") { this.hy_field40_end.Text = "0"; } Hyoa_flowmain.hy_field36_start = float.Parse(this.hy_field36_start.Text); Hyoa_flowmain.hy_field37_start = float.Parse(this.hy_field37_start.Text); Hyoa_flowmain.hy_field38_start = float.Parse(this.hy_field38_start.Text); Hyoa_flowmain.hy_field39_start = float.Parse(this.hy_field39_start.Text); Hyoa_flowmain.hy_field40_start = float.Parse(this.hy_field40_start.Text); Hyoa_flowmain.hy_field36_end = float.Parse(this.hy_field36_end.Text); Hyoa_flowmain.hy_field37_end = float.Parse(this.hy_field37_end.Text); Hyoa_flowmain.hy_field38_end = float.Parse(this.hy_field38_end.Text); Hyoa_flowmain.hy_field39_end = float.Parse(this.hy_field39_end.Text); Hyoa_flowmain.hy_field40_end = float.Parse(this.hy_field40_end.Text); Hyoa_flowmain.hy_field41 = this.hy_field41.Text; Hyoa_flowmain.hy_field42 = this.hy_field42.Text; Hyoa_flowmain.hy_field43 = this.hy_field43.Text; Hyoa_flowmain.hy_field44 = this.hy_field44.Text; Hyoa_flowmain.hy_field45 = this.hy_field45.Text; Hyoa_flowmain.hy_field46 = this.hy_field46.Text; Hyoa_flowmain.hy_field47 = this.hy_field47.Text; Hyoa_flowmain.hy_field48 = this.hy_field48.Text; Hyoa_flowmain.hy_field49 = this.hy_field49.Text; Hyoa_flowmain.hy_field50 = this.hy_field50.Text; Hyoa_flowmain.hy_field51 = this.hy_field51.Text; Hyoa_flowmain.hy_field52 = this.hy_field52.Text; Hyoa_flowmain.hy_field53 = this.hy_field53.Text; Hyoa_flowmain.hy_field54 = this.hy_field54.Text; Hyoa_flowmain.hy_field55 = this.hy_field55.Text; Hyoa_flowmain.hy_field56 = this.hy_field56.Text; Hyoa_flowmain.hy_field57 = this.hy_field57.Text; Hyoa_flowmain.hy_field58 = this.hy_field58.Text; Hyoa_flowmain.hy_field59 = this.hy_field59.Text; Hyoa_flowmain.hy_field60 = this.hy_field60.Text; Hyoa_flowmain.hy_field61_start = this.hy_field61_start.Text; Hyoa_flowmain.hy_field62_start = this.hy_field62_start.Text; Hyoa_flowmain.hy_field63_start = this.hy_field63_start.Text; Hyoa_flowmain.hy_field64_start = this.hy_field64_start.Text; Hyoa_flowmain.hy_field65_start = this.hy_field65_start.Text; Hyoa_flowmain.hy_field66_start = this.hy_field66_start.Text; Hyoa_flowmain.hy_field67_start = this.hy_field67_start.Text; Hyoa_flowmain.hy_field68_start = this.hy_field68_start.Text; Hyoa_flowmain.hy_field69_start = this.hy_field69_start.Text; Hyoa_flowmain.hy_field70_start = this.hy_field70_start.Text; Hyoa_flowmain.hy_field61_end = this.hy_field61_end.Text; Hyoa_flowmain.hy_field62_end = this.hy_field62_end.Text; Hyoa_flowmain.hy_field63_end = this.hy_field63_end.Text; Hyoa_flowmain.hy_field64_end = this.hy_field64_end.Text; Hyoa_flowmain.hy_field65_end = this.hy_field65_end.Text; Hyoa_flowmain.hy_field66_end = this.hy_field66_end.Text; Hyoa_flowmain.hy_field67_end = this.hy_field67_end.Text; Hyoa_flowmain.hy_field68_end = this.hy_field68_end.Text; Hyoa_flowmain.hy_field69_end = this.hy_field69_end.Text; Hyoa_flowmain.hy_field70_end = this.hy_field70_end.Text; if (this.hy_field71_start.Text == "") { this.hy_field71_start.Text = "0"; } if (this.hy_field72_start.Text == "") { this.hy_field72_start.Text = "0"; } if (this.hy_field73_start.Text == "") { this.hy_field73_start.Text = "0"; } if (this.hy_field74_start.Text == "") { this.hy_field74_start.Text = "0"; } if (this.hy_field75_start.Text == "") { this.hy_field75_start.Text = "0"; } if (this.hy_field76_start.Text == "") { this.hy_field76_start.Text = "0"; } if (this.hy_field77_start.Text == "") { this.hy_field77_start.Text = "0"; } if (this.hy_field78_start.Text == "") { this.hy_field78_start.Text = "0"; } if (this.hy_field79_start.Text == "") { this.hy_field79_start.Text = "0"; } if (this.hy_field80_start.Text == "") { this.hy_field80_start.Text = "0"; } if (this.hy_field71_end.Text == "") { this.hy_field71_end.Text = "0"; } if (this.hy_field72_end.Text == "") { this.hy_field72_end.Text = "0"; } if (this.hy_field73_end.Text == "") { this.hy_field73_end.Text = "0"; } if (this.hy_field74_end.Text == "") { this.hy_field74_end.Text = "0"; } if (this.hy_field75_end.Text == "") { this.hy_field75_end.Text = "0"; } if (this.hy_field76_end.Text == "") { this.hy_field76_end.Text = "0"; } if (this.hy_field77_end.Text == "") { this.hy_field77_end.Text = "0"; } if (this.hy_field78_end.Text == "") { this.hy_field78_end.Text = "0"; } if (this.hy_field79_end.Text == "") { this.hy_field79_end.Text = "0"; } if (this.hy_field80_end.Text == "") { this.hy_field80_end.Text = "0"; } if (this.hy_field81_start.Text == "") { this.hy_field81_start.Text = "0"; } if (this.hy_field82_start.Text == "") { this.hy_field82_start.Text = "0"; } if (this.hy_field83_start.Text == "") { this.hy_field83_start.Text = "0"; } if (this.hy_field84_start.Text == "") { this.hy_field84_start.Text = "0"; } if (this.hy_field85_start.Text == "") { this.hy_field85_start.Text = "0"; } if (this.hy_field86_start.Text == "") { this.hy_field86_start.Text = "0"; } if (this.hy_field87_start.Text == "") { this.hy_field87_start.Text = "0"; } if (this.hy_field88_start.Text == "") { this.hy_field88_start.Text = "0"; } if (this.hy_field89_start.Text == "") { this.hy_field89_start.Text = "0"; } if (this.hy_field90_start.Text == "") { this.hy_field90_start.Text = "0"; } if (this.hy_field81_end.Text == "") { this.hy_field81_end.Text = "0"; } if (this.hy_field82_end.Text == "") { this.hy_field82_end.Text = "0"; } if (this.hy_field83_end.Text == "") { this.hy_field83_end.Text = "0"; } if (this.hy_field84_end.Text == "") { this.hy_field84_end.Text = "0"; } if (this.hy_field85_end.Text == "") { this.hy_field85_end.Text = "0"; } if (this.hy_field86_end.Text == "") { this.hy_field86_end.Text = "0"; } if (this.hy_field87_end.Text == "") { this.hy_field87_end.Text = "0"; } if (this.hy_field88_end.Text == "") { this.hy_field88_end.Text = "0"; } if (this.hy_field89_end.Text == "") { this.hy_field89_end.Text = "0"; } if (this.hy_field90_end.Text == "") { this.hy_field90_end.Text = "0"; } //ztm if (this.hy_field91_start.Text == "") { this.hy_field91_start.Text = "0"; } if (this.hy_field92_start.Text == "") { this.hy_field92_start.Text = "0"; } if (this.hy_field93_start.Text == "") { this.hy_field93_start.Text = "0"; } if (this.hy_field94_start.Text == "") { this.hy_field94_start.Text = "0"; } if (this.hy_field95_start.Text == "") { this.hy_field95_start.Text = "0"; } if (this.hy_field96_start.Text == "") { this.hy_field96_start.Text = "0"; } if (this.hy_field97_start.Text == "") { this.hy_field97_start.Text = "0"; } if (this.hy_field98_start.Text == "") { this.hy_field98_start.Text = "0"; } if (this.hy_field99_start.Text == "") { this.hy_field99_start.Text = "0"; } if (this.hy_field100_start.Text == "") { this.hy_field100_start.Text = "0"; } if (this.hy_field91_end.Text == "") { this.hy_field91_end.Text = "0"; } if (this.hy_field92_end.Text == "") { this.hy_field92_end.Text = "0"; } if (this.hy_field93_end.Text == "") { this.hy_field93_end.Text = "0"; } if (this.hy_field94_end.Text == "") { this.hy_field94_end.Text = "0"; } if (this.hy_field95_end.Text == "") { this.hy_field95_end.Text = "0"; } if (this.hy_field96_end.Text == "") { this.hy_field96_end.Text = "0"; } if (this.hy_field97_end.Text == "") { this.hy_field97_end.Text = "0"; } if (this.hy_field98_end.Text == "") { this.hy_field98_end.Text = "0"; } if (this.hy_field99_end.Text == "") { this.hy_field99_end.Text = "0"; } if (this.hy_field100_end.Text == "") { this.hy_field100_end.Text = "0"; } Hyoa_flowmain.hy_field71_start = float.Parse(this.hy_field71_start.Text); Hyoa_flowmain.hy_field72_start = float.Parse(this.hy_field72_start.Text); Hyoa_flowmain.hy_field73_start = float.Parse(this.hy_field73_start.Text); Hyoa_flowmain.hy_field74_start = float.Parse(this.hy_field74_start.Text); Hyoa_flowmain.hy_field75_start = float.Parse(this.hy_field75_start.Text); Hyoa_flowmain.hy_field76_start = float.Parse(this.hy_field76_start.Text); Hyoa_flowmain.hy_field77_start = float.Parse(this.hy_field77_start.Text); Hyoa_flowmain.hy_field78_start = float.Parse(this.hy_field78_start.Text); Hyoa_flowmain.hy_field79_start = float.Parse(this.hy_field79_start.Text); Hyoa_flowmain.hy_field80_start = float.Parse(this.hy_field80_start.Text); Hyoa_flowmain.hy_field71_end = float.Parse(this.hy_field71_end.Text); Hyoa_flowmain.hy_field72_end = float.Parse(this.hy_field72_end.Text); Hyoa_flowmain.hy_field73_end = float.Parse(this.hy_field73_end.Text); Hyoa_flowmain.hy_field74_end = float.Parse(this.hy_field74_end.Text); Hyoa_flowmain.hy_field75_end = float.Parse(this.hy_field75_end.Text); Hyoa_flowmain.hy_field76_end = float.Parse(this.hy_field76_end.Text); Hyoa_flowmain.hy_field77_end = float.Parse(this.hy_field77_end.Text); Hyoa_flowmain.hy_field78_end = float.Parse(this.hy_field78_end.Text); Hyoa_flowmain.hy_field79_end = float.Parse(this.hy_field79_end.Text); Hyoa_flowmain.hy_field80_end = float.Parse(this.hy_field80_end.Text); Hyoa_flowmain.hy_field81_start = float.Parse(this.hy_field81_start.Text); Hyoa_flowmain.hy_field82_start = float.Parse(this.hy_field82_start.Text); Hyoa_flowmain.hy_field83_start = float.Parse(this.hy_field83_start.Text); Hyoa_flowmain.hy_field84_start = float.Parse(this.hy_field84_start.Text); Hyoa_flowmain.hy_field85_start = float.Parse(this.hy_field85_start.Text); Hyoa_flowmain.hy_field86_start = float.Parse(this.hy_field86_start.Text); Hyoa_flowmain.hy_field87_start = float.Parse(this.hy_field87_start.Text); Hyoa_flowmain.hy_field88_start = float.Parse(this.hy_field88_start.Text); Hyoa_flowmain.hy_field89_start = float.Parse(this.hy_field89_start.Text); Hyoa_flowmain.hy_field90_start = float.Parse(this.hy_field90_start.Text); Hyoa_flowmain.hy_field81_end = float.Parse(this.hy_field81_end.Text); Hyoa_flowmain.hy_field82_end = float.Parse(this.hy_field82_end.Text); Hyoa_flowmain.hy_field83_end = float.Parse(this.hy_field83_end.Text); Hyoa_flowmain.hy_field84_end = float.Parse(this.hy_field84_end.Text); Hyoa_flowmain.hy_field85_end = float.Parse(this.hy_field85_end.Text); Hyoa_flowmain.hy_field86_end = float.Parse(this.hy_field86_end.Text); Hyoa_flowmain.hy_field87_end = float.Parse(this.hy_field87_end.Text); Hyoa_flowmain.hy_field88_end = float.Parse(this.hy_field88_end.Text); Hyoa_flowmain.hy_field89_end = float.Parse(this.hy_field89_end.Text); Hyoa_flowmain.hy_field90_end = float.Parse(this.hy_field90_end.Text); Hyoa_flowmain.hy_field91_start = float.Parse(this.hy_field91_start.Text); Hyoa_flowmain.hy_field92_start = float.Parse(this.hy_field92_start.Text); Hyoa_flowmain.hy_field93_start = float.Parse(this.hy_field93_start.Text); Hyoa_flowmain.hy_field94_start = float.Parse(this.hy_field94_start.Text); Hyoa_flowmain.hy_field95_start = float.Parse(this.hy_field95_start.Text); Hyoa_flowmain.hy_field96_start = float.Parse(this.hy_field96_start.Text); Hyoa_flowmain.hy_field97_start = float.Parse(this.hy_field97_start.Text); Hyoa_flowmain.hy_field98_start = float.Parse(this.hy_field98_start.Text); Hyoa_flowmain.hy_field99_start = float.Parse(this.hy_field99_start.Text); Hyoa_flowmain.hy_field100_start = float.Parse(this.hy_field100_start.Text); Hyoa_flowmain.hy_field91_end = float.Parse(this.hy_field91_end.Text); Hyoa_flowmain.hy_field92_end = float.Parse(this.hy_field92_end.Text); Hyoa_flowmain.hy_field93_end = float.Parse(this.hy_field93_end.Text); Hyoa_flowmain.hy_field94_end = float.Parse(this.hy_field94_end.Text); Hyoa_flowmain.hy_field95_end = float.Parse(this.hy_field95_end.Text); Hyoa_flowmain.hy_field96_end = float.Parse(this.hy_field96_end.Text); Hyoa_flowmain.hy_field97_end = float.Parse(this.hy_field97_end.Text); Hyoa_flowmain.hy_field98_end = float.Parse(this.hy_field98_end.Text); Hyoa_flowmain.hy_field99_end = float.Parse(this.hy_field99_end.Text); Hyoa_flowmain.hy_field100_end = float.Parse(this.hy_field100_end.Text); Hyoa_flowmain.hy_curuserid = this.Session["hyuid"].ToString(); //排序 HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig(); DataTable dt_listconfig = Hyoa_listconfig.GetlistconfigByTableid(this.txttableid.Value); if (dt_listconfig.Rows.Count > 0) { Hyoa_flowmain.hy_sorttype = dt_listconfig.Rows[0]["hy_sortfield"].ToString() + " " + dt_listconfig.Rows[0]["hy_sorttype"].ToString(); } //---查询条件---结束 //--根据查询条件得到返回数据集--s DataTable dt; DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc if (dttable.Rows[0]["hy_ifflowdoc"].ToString()=="是") { dt = Hyoa_flowmain.GetflowmainsByIf(); //输出流程的dt } else { //if (dttable.Rows[0]["hy_ifdisplayall"].ToString() == "是") //{ dt = Hyoa_flowmain.GetAllflowmainsByNoFlows();//输出所有的dt //} //else //{ // dt = Hyoa_flowmain.GetPersonerflowmainsByNoFlows();//输出自己的dt //} } //--根据查询条件得到返回数据集--e //开始输出----整合成HTML为数据行 DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("displaycol", typeof(String)); //定义新的一列 add tempTable.Columns.Add(col); //追加一列 add string lscolname = ""; string lscolnameid = ""; string lscolwidth = ""; string ls_col = ""; string[] lvcolname; string[] lvcolnameid; string[] lvcolwidth; string lscolwidthper; //HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig(); DataTable dtlist = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(this.txtmudelid.Value,this.txttableid.Value); lscolname = dtlist.Rows[0]["hy_columnshow"].ToString(); //要显示的列名:附件,标题,收文来源 lscolnameid = dtlist.Rows[0]["hy_columnshowid"].ToString(); //要显示的列名id:uploadfile1,Hy_bt,Hy_swly lscolwidth = dtlist.Rows[0]["hy_width"].ToString(); //要显示的列名id:10,20,30 lvcolname = lscolname.Split(','); lvcolnameid = lscolnameid.Split(','); lvcolwidth = lscolwidth.Split(','); if (dt.Rows.Count <= 0) { //如果没有数据则输出表头 for (int n = 0; n < lvcolname.Length; n++) { if (n >= lvcolwidth.Length) { lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时,会溢出报错。 else { lscolwidthper = lvcolwidth[n]; } this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[n] + "</td>"; } } for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++) { if (i > dt.Rows.Count - 1) break; DataRow dr = tempTable.NewRow(); //输出主表所有字段,start for (int j = 0; j < dt.Columns.Count; j++) { dr[dt.Columns[j].ColumnName] = dt.Rows[i][j]; } //输出主表所有字段,end //////开始得到列的值 HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); DataTable dtgetsqlfield; for (int m = 0; m < lvcolname.Length; m++) { //如果有数据,则输出数据 if (m >= lvcolwidth.Length) { lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时,会溢出报错。 else { lscolwidthper = lvcolwidth[m]; } dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lvcolnameid[m],this.txttableid.Value); //ztm if (i % System.Int32.Parse(PageSize.Text) == 0) this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[m] + "</td>"; //根据字段英文名,得到数据库中对应的字段 string lsgetsqlfield = dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString(); //根据数据库中对应的字段,得到输出字段的值start (日期型根据格式进行了转换) string lsgetputfiled=""; if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd") { lsgetputfiled = System.DateTime.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToShortDateString(); } else { //解决Float小数点后面出现N位小数乱码的问题 if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "数值") { //是否包含小数点,包含的话,取小数点后两位 if (dt.Rows[i][lsgetsqlfield].ToString().Contains(".") == true) { lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString("F2"); } else { lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString(); } //lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString(); }else { lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString(); } } if (lsgetputfiled == "") lsgetputfiled = " "; //根据得到的SQL字段,得到输出字段的值end ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>"; } //如果是流程表单,则最后追加两列(当前环节和当前处理人) //表头 if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null && i == (PageNo - 1) * System.Int32.Parse(PageSize.Text)) { this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前环节</td>"; this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前处理人</td>"; } //数据 if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null) { ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curtachename"].ToString() + " </td>"; ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curclrname"].ToString() + " </td>"; } dr["displaycol"] = ls_col; //将新值赋给相应的列 add ls_col = ""; tempTable.Rows.Add(dr); } int TotalRecord = dt.Rows.Count; this.sumts.Text = TotalRecord.ToString(); this.sumts2.Text = TotalRecord.ToString(); this.ShowTotalRecord.Text = TotalRecord.ToString(); //计算及显示总页数 int TotalPage; if (TotalRecord < System.Int32.Parse(PageSize.Text)) { TotalPage = 1; } else { if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0) { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1; } else { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text); } } this.ShowTotalPage.Text = TotalPage.ToString(); this.rptlist.DataSource = tempTable; this.rptlist.DataBind(); dt.Clear(); }