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 = true;
this.newcontrol.Visible = true;
//this.copycontrol.Visible = false; //流程模块暂时都不能复制
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
}
}
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 = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
}
}
//如果非流程(每个人管理自己的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1")
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
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 = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
}
}
//得到当前页号
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_curclrid = this.Session["hyuid"].ToString();
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
dt = Hyoa_flowmain.GetflowmainsByIf_db(); //输出当前处理人是自己的dt
//if (dttable.Rows[0]["hy_ifflowdoc"].ToString()=="是")
//{
// //this.Response.Write("<script>alert('" + dttable.Rows[0]["hy_ispuballByflowYB"].ToString() + "')</script>");
// //dt = Hyoa_flowmain.GetflowmainsByIf(); //输出流程的dt
// if (dttable.Rows[0]["hy_ispuballByflowYB"].ToString() == "是")
// {
// dt = Hyoa_flowmain.GetflowmainsByIf_jsDisplayAll(); //输出流程的dt
// }
// else
// {
// 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
if (lsgetputfiled == "1900-1-1")
lsgetputfiled = "";
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();
}
public void GetSearchTableHtml()
{
//输出查询字段的表格（查询输入框） start
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dtlistsearch = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.txtmudelid.Value, this.txttableid.Value);
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
//DataTable dtgetsqlfield;
string lssearchdispaly = ""; //返回值
//输出外框（开始）
lssearchdispaly +="<tr height=40px>";
lssearchdispaly +="<td valign=\"top\" >";
lssearchdispaly +="<table width=\"100%\" border=0>";
lssearchdispaly +="<tr>";
lssearchdispaly +="<td align=\"center\" valign=\"top\">";
lssearchdispaly +="<table width=\"100%\" height=\"5\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
lssearchdispaly +="<tr>";
lssearchdispaly +="<td></td>";
lssearchdispaly +="</tr>";
lssearchdispaly +="</table>";
lssearchdispaly +="<table width=\"98%\" border=0 cellpadding=0 cellspacing=1 class=\"tb1-main\">";
HyoaClass.DAO db = new HyoaClass.DAO();
string lsflag = "0"; //1表示有</tr>,则最后不用输出，否则循环完后，要输出一个</tr>
for (int t = 0; t < dtlistsearch.Rows.Count; t++)
{
if (t % 2 == 0)
{
lssearchdispaly += "<tr>";
lsflag = "0";
}
//得到hyt_listsearchfield表中的hy_fieldid，
string lslistsearch = dtlistsearch.Rows[t]["hy_fieldid"].ToString();
//根据字段英文名得到数据库中对应的字段名，ztmztm
DataTable dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lslistsearch, this.txttableid.Value); //得到与SQL表对应的字段名
lssearchdispaly += "<td width=\"15%\" height=\"30\" align=\"center\" class=\"Tdcellleft\">";
lssearchdispaly += dtlistsearch.Rows[t]["hy_field"].ToString();
lssearchdispaly += "</td>";
lssearchdispaly += " <td width=\"35%\" align=\"left\" class=\"Tdcellright\">";
//调用公用函数，输出txt查询框
lssearchdispaly += GetFieldHtml(this.txtmudelid.Value, dtgetsqlfield.Rows[0]["hy_fieldid"].ToString(), "0", this.txttableid.Value, "1");
lssearchdispaly += "</td>";
if ((t + 1) % 2 == 0)
{
lssearchdispaly += "</tr>";
lsflag = "1";
}
dtgetsqlfield.Clear();
}
//如果上面</tr>没有输出过，则要输出一个</tr>，保证html的完整性
if (lsflag != "1")
{
for (int t = 0; t < (4 - dtlistsearch.Rows.Count % 2 * 2); t++)
{
//如果行不足四列，则要补满四列
lssearchdispaly += " <td align=\"left\" class=\"Tdcellright\">";
lssearchdispaly += " ";
lssearchdispaly += "</td>";
}
lssearchdispaly += "</tr>";
}
//输出外框（结束）
lssearchdispaly += "<tr>";
lssearchdispaly += "<td height=\"30\" align=\"right\" class=\"Tdcellright\" colspan=4>";
lssearchdispaly += "<input type=\"button\" onclick=\"jssearch();\" value=\" 查 询\" class=btn7 name=\"Button_Return\" /> ";
lssearchdispaly += "</td>";
lssearchdispaly += "</tr>";
lssearchdispaly += "</table>";
lssearchdispaly += "</td>";
lssearchdispaly += "</tr>";
lssearchdispaly += "</table>";
lssearchdispaly += "</td>";
lssearchdispaly += "</tr>";
this.lbsearchidspaly.Text = lssearchdispaly;
//输出查询字段的表格 end
}
public string hyjs()
{
//输出查询字段的JS start
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dtlistsearch = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.txtmudelid.Value,this.txttableid.Value);
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtgetsqlfield;
string ls_return = "";
string fieldfz = "";//对应域JS域值
ls_return += "<script>function jssearch()"; //js生成
ls_return += "{fm = document.forms[0];";//js生成
for (int t = 0; t < dtlistsearch.Rows.Count; t++)
{
//根据模块ID和当前域名和表名id得到SQL字段 ztmztm
dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, dtlistsearch.Rows[t]["hy_fieldid"].ToString(), this.txttableid.Value);
fieldfz = "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + ".value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_1.value;";
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString()=="数值")
{
fieldfz = "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1.value;";
fieldfz += "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1.value;";
}
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "日期")
{
fieldfz = "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1.value;";
fieldfz += "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end.value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1.value;";
}
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "对话框列表")
{
//document.forms[0].fNumber（域名）.options[document.forms[0].fNumber（域名）.selectedIndex].text
fieldfz += "fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + ".value = fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_1.options[fm." + dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString() + "_1.selectedIndex].text;";
}
ls_return += fieldfz;
dtgetsqlfield.Clear();
}
ls_return += "fm.btnsearch.click();";//js生成
ls_return += "}</script>";//js生成
return ls_return;
}
private void DataPlay(int PageNo)
{
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
//---查询条件---结束
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (this.txtfieldid.Value != "" && this.txtfieldsort.Value != "")
{
cmdStr_SearchSort = " order by hyc_" + this.txtfieldid.Value + " " + this.txtfieldsort.Value + " ";
}
if (cmdStr_SearchSort == "")
{
//没有配置，则默认按登记日期
cmdStr_SearchSort = " order by hy_djsj desc ";
}
//---排序---结束
//--根据查询条件得到返回数据集--s
DataTable dt = new DataTable(); //单页数据集
DataTable dt_total = new DataTable(); //数据总条数，返回总条数值
DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc
string cmdStr = "";
string ls_from = "";
ls_from = " hyc_" + this.txttableid.Value + " where 1=1 and hy_djrbmid='" + Session["hydeptid"].ToString() + "' " + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select top " + PageSize.Text + " * from " + ls_from;
cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr = " select * from ( ";
cmdStr += " select my_table.*, rownum as my_rownum from ";
cmdStr += " ( ";
cmdStr += " select * from hyc_" + this.txttableid.Value + " where 1=1 and hy_djrbmid='" + Session["hydeptid"].ToString() + "' " + cmdStr_Search + cmdStr_SearchSort;
cmdStr += " ) my_table ";
cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString();
cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString();
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
//--根据查询条件得到返回数据集--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;
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 = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
//输出主表所有字段,start
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//输出主表所有字段,end
//////开始得到列的值
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);
if (i % System.Int32.Parse(PageSize.Text) == 0)
this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" title=\"点击可排序\" onclick=\"fun_sort('" + lvcolnameid[m] + "');\">" + lvcolname[m] + "</a></p></td>";
//根据字段英文名，得到数据库中对应的字段
string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString();
//根据数据库中对应的字段，得到输出字段的值start (日期型根据格式进行了转换)
string lsgetputfiled = "";
if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
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() != "")
{
//是否包含小数点，包含的话，取小数点后两位
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();
}
}
else
{
lsgetputfiled = "0";
}
//lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
else
{
lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
}
if (lsgetputfiled == "")
lsgetputfiled = " ";
//根据得到的SQL字段，得到输出字段的值end
if (dtgetsqlfield.Rows[0]["hy_ifdbsybt"].ToString() == "是")
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\"><a href=\"#\" onclick=\"var ss='main.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.location=ss;\">" + lsgetputfiled + "</a></td>";
}
else
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>";
}
}
//如果是流程表单，则最后追加两列（当前环节和当前处理人）
//表头
if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null && i == 0)
{
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 = int.Parse(dt_total.Rows[0][0].ToString());
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();
//列表中的一些特殊处理，都放在这个函数内
DataPlay_Tscl();
}
//得到某一个字段的HTML
//pi_flag 0:不赋值 1：需赋值
//ifsearch:是否查询时使用 0:非查询时使用 1:查询时使用
public string GetFieldHtml(string hy_mudelid, string hy_fieldid, string pi_flag, string hy_tableid, string ifsearch)
{
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(hy_mudelid, hy_fieldid, hy_tableid);
HyoaClass.DAO db = new HyoaClass.DAO();
string lsField = "";
string field_css = "";
string field_value = "";
string field_functionhy_onclick = "";
string field_functionhy_ondblclick = "";
string field_functionhy_onchange = "";
string field_functionhy_onkeydown = "";
string field_functionhy_onkeyup = "";
if (dtfield.Rows.Count > 0)
{
//得到该字段的样式start
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
if (ifsearch == "0")
field_css += " readonly ";
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
field_css += " class='" + dtfield.Rows[0]["hy_class"].ToString() + "' ";
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
field_css += " style='width:" + dtfield.Rows[0]["hy_width"].ToString() + ";";
}
else
{
field_css += " style='";
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
field_css += " height:" + dtfield.Rows[0]["hy_height"].ToString() + "'";
}
else
{
field_css += "'";
}
//默认值
//默认值取值的方式,查询时不使用默认值
if (ifsearch == "0")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "0")
field_value += dtfield.Rows[0]["hy_defaultvalue"].ToString();
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "1")
{
DataTable dtdefault = db.GetDataTable(dtfield.Rows[0]["hy_defaultvalue"].ToString());
if (dtdefault.Rows.Count > 0)
field_value += dtdefault.Rows[0][0].ToString();
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "2")
{
field_value += Session[dtfield.Rows[0]["hy_defaultvalue"].ToString()].ToString();
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "3")
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
field_value += System.DateTime.Now.ToShortDateString();
else
field_value += System.DateTime.Now.ToString();
}
}
}
//事件
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
field_functionhy_onclick += " onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
field_functionhy_ondblclick += " ondblclick=\"" + dtfield.Rows[0]["hy_ondblclick"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
field_functionhy_onchange += " onchange=\"" + dtfield.Rows[0]["hy_onchange"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
field_functionhy_onkeydown += " onkeydown=\"" + dtfield.Rows[0]["hy_onkeydown"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
field_functionhy_onkeyup += " onkeyup=\"" + dtfield.Rows[0]["hy_onkeyup"].ToString() + "\" ";
}
//得到该字段的样式end
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString();
//单行文本
if (field_type == "文本")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">";
}
//多行文本
if (field_type == "多行文本")
{
lsField = "<textarea name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_css + " >" + field_value + "</textarea>";
}
//日期
if (field_type == "日期")
{
if (ifsearch == "0")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + field_value + "\">";
}
else
{
field_css = " style='width:47%;'";
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" " + "onclick=\"WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1')})\"" +field_css + " value=\"" + field_value + "\">至";
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" " +"onclick=\"WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1')})\"" +field_css + " value=\"" + field_value + "\">";
}
}
//数值
if (field_type == "数值")
{
if (ifsearch == "0")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">";
}
else
{
field_css = " style='width:47%;'";
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">到";
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + " value=\"" + field_value + "\">";
}
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
lsField = "<select name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onchange + field_css + "> ";
//有哪些选项
lsField += "<option value=''></option>";
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
lsField += "<option value='" + lv_options[ii].ToString() + "'>" + lv_options[ii].ToString() + "</option>";
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
lsField += "<option value='" + dtoptions.Rows[ii][0].ToString() + "'>" + dtoptions.Rows[ii][0].ToString() + "</option>";
}
}
}
lsField += "</select>";
}
//复选框
if (field_type == "复选框")
{
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (field_value == lv_options[ii].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (field_value == dtoptions.Rows[ii][0].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
}
}
}
//单选框
if (field_type == "单选框")
{
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (field_value == lv_options[ii].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (field_value == dtoptions.Rows[ii][0].ToString())
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + (ii.ToString()) + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
}
}
}
//口令
if (field_type == "口令")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=password id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + " value=\"" + field_value + "\">";
}
//附件组件
if (field_type == "附件组件")
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_css + " value=\"" + "\"><input type=button id=\"uploadfile1\" text='附件' class=\"text1\" onclick=\"window.open('/ggdy/uploadfile.aspx?id=" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "');\" ";
}
//说明文字
if (field_type == "说明文字")
{
lsField = "<span id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\">" + field_value + "</span>";
}
//编辑器文本
//if (field_type.Equals("ewebeditor"))
//{
// tfile.setField(field_name, field_value);
//}
db.Close();
}
return lsField;
}
//输出一个字段
//li_tdnums_onerow：当前行已输出了几列
//li_colnums_show：每行显示几列（标准情况下）
//pi_isnewdoc 0:新文档 1：旧文档
//ifhavarole：表单上是否有权限 0：lable输出 1：input输出
//ifflowdoc：是否流程表单 0：非流程 1：流程
//curtacheid:当前环节ID,用于判断字段是否在当前环节有权限
public int GetFieldHtml(TableRow tRow, int li_tdnums_onerow, int li_colnums_show, string hy_fieldid, string pi_isnewdoc, string ifhavarole, string ifflowdoc, string curtacheid)
{
int li_return = li_tdnums_onerow;
string ls_laborinput = "0"; //输出LABLE还是INPUT 0：LABLE 1：INPUT
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.hy_mudelid.Text, hy_fieldid, this.hy_tableid.Text);
int li_left = 30;
int li_right = 70;
if (dtfield.Rows.Count > 0)
{
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString(); //字段类型
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "5") //如果设置了不显示左侧说明文字，则不加载左侧列
{
li_return += 1;
//插入单元格（左侧）
TableCell tCell = new TableCell();
tRow.Cells.Add(tCell);
tCell.Width = Unit.Percentage((li_left / li_colnums_show));
tCell.Height = Unit.Pixel(30);
tCell.CssClass = "Tdcellleft";
tCell.HorizontalAlign = HorizontalAlign.Center;
tCell.Controls.Add(new LiteralControl(dtfield.Rows[0]["hy_fieldname"].ToString()));
}
else
{
li_left = 50;
li_right = 50;
}
//插入单元格（右侧）
TableCell tCell2 = new TableCell();
tRow.Cells.Add(tCell2);
tCell2.Width = Unit.Percentage((li_right / li_colnums_show));
tCell2.Height = Unit.Pixel(30);
tCell2.CssClass = "Tdcellright";
if (dtfield.Rows[0]["hy_align"].ToString() == "left")
{
tCell2.HorizontalAlign = HorizontalAlign.Left;
}
if (dtfield.Rows[0]["hy_align"].ToString() == "center")
{
tCell2.HorizontalAlign = HorizontalAlign.Center;
}
if (dtfield.Rows[0]["hy_align"].ToString() == "right")
{
tCell2.HorizontalAlign = HorizontalAlign.Right;
}
tCell2.ColumnSpan = int.Parse(dtfield.Rows[0]["hy_tdnums"].ToString());
li_return += int.Parse(dtfield.Rows[0]["hy_tdnums"].ToString());
//赋值（新文档取配置的默认值，旧文档取数据库表中的值）
string field_docvalue = "";
if (pi_isnewdoc == "0") //新文档
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "-1")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "0")
{
field_docvalue = dtfield.Rows[0]["hy_defaultvalue"].ToString(); //手工配置
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "1")
{
DataTable dt_getfieldvalue = Hyoa_global.GetDataTable(dtfield.Rows[0]["hy_defaultvalue"].ToString());
field_docvalue = dt_getfieldvalue.Rows[0][0].ToString(); //SQL语句
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "2")
{
field_docvalue = Session[dtfield.Rows[0]["hy_defaultvalue"].ToString()].ToString(); //SESSION
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "3")
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
field_docvalue = System.DateTime.Now.ToString("yyyy-MM-dd"); //当前时间
else
field_docvalue = System.DateTime.Now.ToString("yyyy-MM-dd HH:MM:ss"); //当前时间
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "4")
{
//自动生成
if (dtfield.Rows[0]["hy_fieldtype"].ToString() == "数值")
{
//得到目前最大的数值，然后+1，未找到则赋值为1
DataTable dt_autovalue = Hyoa_global.GetDataTable("select max(hyc_" + hy_fieldid + ") maxint from hyc_" + this.hy_tableid.Text);
if (dt_autovalue.Rows[0]["maxint"].ToString() == null || dt_autovalue.Rows[0]["maxint"].ToString() == "")
field_docvalue += "1";
else
field_docvalue += (System.Int32.Parse(dt_autovalue.Rows[0]["maxint"].ToString()) + 1).ToString();
}
else
{
field_docvalue += System.Guid.NewGuid().ToString();
}
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "5")
{
field_docvalue += dtfield.Rows[0]["hy_defaultvalue"].ToString();
}
}
}
else
{
if (field_type == "文本" || field_type == "多行文本" || field_type == "多行文本_TEXT" || field_type == "文本加按钮" || field_type == "多行文本加按钮" || field_type == "日期" || field_type == "数值" || field_type == "对话框列表" || field_type == "复选框" || field_type == "单选框" || field_type == "口令" || field_type == "编辑器")
{
string ls_sql = "select hyc_" + hy_fieldid + " from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "'";
DataTable dt_getdocvalue = Hyoa_global.GetDataTable(ls_sql);
if (dt_getdocvalue.Rows.Count > 0)
{
field_docvalue = dt_getdocvalue.Rows[0][0].ToString();
if (field_type == "日期")
{
if (field_docvalue.Length > 8)
{
if (field_docvalue.Substring(0, 8) == "1900-1-1")
{
field_docvalue = " ";
}
else
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
field_docvalue = System.DateTime.Parse(field_docvalue).ToString("yyyy-MM-dd");
}
}
}
}
}
}
if (field_type == "说明文字")
{
field_docvalue += dtfield.Rows[0]["hy_defaultvalue"].ToString();
}
}
//判断是输出LABL还是INPUT
if (pi_isnewdoc == "0") //新文档
{
if (ifflowdoc == "0") //非流程
{
if (ifhavarole == "1") //有权限
{
ls_laborinput = "1";
}
}
else
{
if (ifhavarole == "1") //有权限
{
//有流程(判断当前环节这个字段是否有权限)
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
ls_laborinput = Hyoa_flowtachefield.IfHaveRolebyflowidandtacheidandfieldid(hy_flowid.Text, curtacheid, hy_fieldid);
if (ls_laborinput == "0")
{
field_docvalue = "";
}
}
else
{
field_docvalue = "";
}
}
}
else //旧文档
{
if (ifflowdoc == "0") //非流程
{
if (ifhavarole == "1") //有权限
{
ls_laborinput = "1";
//如果文档已经确认，则输出lable
string ls_sql = "select hy_ifconfirm from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "'";
DataTable dt_getifconfirm = Hyoa_global.GetDataTable(ls_sql);
if (dt_getifconfirm.Rows.Count > 0)
{
if (dt_getifconfirm.Rows[0]["hy_ifconfirm"].ToString() == "1")
ls_laborinput = "0";
}
}
}
else
{
if (ifhavarole == "1") //有权限
{
//有流程(判断当前环节这个字段是否有权限)
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
ls_laborinput = Hyoa_flowtachefield.IfHaveRolebyflowidandtacheidandfieldid(hy_flowid.Text, curtacheid, hy_fieldid);
//如果流程结束了，则输出lable
if (hy_curtacheid.Text == "**")
{
ls_laborinput = "0";
}
}
}
}
//如果是输出LABLE，值为空则赋为 不为空时需要转换回车和空格
if (ls_laborinput == "0")
{
if (field_docvalue == "")
{
field_docvalue = " ";
}
else
{
if (field_type != "编辑器")
{
field_docvalue = RtfToText(field_docvalue);
}
}
}
//单行文本
if (field_type == "文本")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//多行文本
if (field_type == "多行文本")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//多行文本_TEXT
if (field_type == "多行文本_TEXT")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//按钮
if (field_type == "按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = " ";
tCell2.Controls.Add(txtTextBox);
}
else
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value='" + dtfield.Rows[0]["hy_fieldname"].ToString() + "' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//一直显示的按钮
if (field_type == "一直显示的按钮")
{
//-----开始输出字段------
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value='" + dtfield.Rows[0]["hy_fieldname"].ToString() + "' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
//日期
if (field_type == "日期")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//文本加按钮
if (field_type == "文本加按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("60%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
Label txtTextBox2 = new Label();
txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//多行文本加按钮
if (field_type == "多行文本加按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
Label txtTextBox2 = new Label();
txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//意见加按钮
if (field_type == "意见加按钮")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
//txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
Label txtTextBox2 = new Label();
txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" /><input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_cz' value=' 重 置 ' class=btn3 onclick=\"document.getElementById('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "').value='';\" />";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//数值
if (field_type == "数值")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
DropDownList ddlDropDownList = new DropDownList();
ddlDropDownList.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
ddlDropDownList.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
ddlDropDownList.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
ddlDropDownList.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
ddlDropDownList.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
//如果SQL语句中含有特殊标示，则需要替换
string ls_sql = dtfield.Rows[0]["hy_options"].ToString();
if (ls_sql.Contains("用户ID"))
{
ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'");
}
if (ls_sql.Contains("用户名"))
{
ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'");
}
if (ls_sql.Contains("部门ID"))
{
ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'");
}
if (ls_sql.Contains("部门名"))
{
ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'");
}
DataTable dt_options = Hyoa_global.GetDataTable(ls_sql);
ddlDropDownList.DataSource = dt_options;
ddlDropDownList.DataTextField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataValueField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataBind();
}
}
ddlDropDownList.Items.Insert(0, new ListItem("--请选择--", ""));
ddlDropDownList.SelectedValue = field_docvalue;
tCell2.Controls.Add(ddlDropDownList);
}
}
//复选框(查询时直接显示文本框)
if (field_type == "复选框")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
CheckBoxList txtTextBox = new CheckBoxList();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
txtTextBox.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
//如果SQL语句中含有特殊标示，则需要替换
string ls_sql = dtfield.Rows[0]["hy_options"].ToString();
if (ls_sql.Contains("用户ID"))
{
ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'");
}
if (ls_sql.Contains("用户名"))
{
ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'");
}
if (ls_sql.Contains("部门ID"))
{
ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'");
}
if (ls_sql.Contains("部门名"))
{
ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'");
}
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
DataTable dt_options = Hyoa_global.GetDataTable(ls_sql);
txtTextBox.DataSource = dt_options;
txtTextBox.DataTextField = dt_options.Columns[0].ColumnName;
txtTextBox.DataValueField = dt_options.Columns[0].ColumnName;
txtTextBox.DataBind();
}
}
if (field_docvalue != "")
{
field_docvalue = "," + field_docvalue + ",";
foreach (ListItem li in txtTextBox.Items)
{
if (field_docvalue.Contains(li.Value))
li.Selected = true;
}
}
tCell2.Controls.Add(txtTextBox);
}
}
//单选框(查询时直接显示文本框)
if (field_type == "单选框")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
RadioButtonList txtTextBox = new RadioButtonList();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
txtTextBox.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
//如果SQL语句中含有特殊标示，则需要替换
string ls_sql = dtfield.Rows[0]["hy_options"].ToString();
if (ls_sql.Contains("用户ID"))
{
ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'");
}
if (ls_sql.Contains("用户名"))
{
ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'");
}
if (ls_sql.Contains("部门ID"))
{
ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'");
}
if (ls_sql.Contains("部门名"))
{
ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'");
}
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
DataTable dt_options = Hyoa_global.GetDataTable(ls_sql);
txtTextBox.DataSource = dt_options;
txtTextBox.DataTextField = dt_options.Columns[0].ColumnName;
txtTextBox.DataValueField = dt_options.Columns[0].ColumnName;
txtTextBox.DataBind();
}
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//口令
if (field_type == "口令")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = " ";
tCell2.Controls.Add(txtTextBox);
}
else
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.Password;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//附件组件
if (field_type == "附件组件")
{
//读取附件内容
HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt();
DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatheridandFatherfield(this.txtdocid.Value, hy_fieldid);
field_docvalue = "";
if (dt_fileatt.Rows.Count > 0)
{
for (var ii = 0; ii < dt_fileatt.Rows.Count; ii++)
{
field_docvalue += (ii + 1).ToString() + "、<a href=\"" + dt_fileatt.Rows[ii]["hy_filepath"].ToString() + "\" target=_blank>" + dt_fileatt.Rows[ii]["hy_filename"].ToString() + "</a><br />";
}
}
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (field_docvalue == "")
{
field_docvalue = " ";
}
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue += "<input type=button id='uploadfile1' value='附件管理' class=btn3 onclick=\"window.open('ggdy/main_fileatt.aspx?fatherid=" + this.txtdocid.Value + "&fatherfield=" + hy_fieldid + "','filewindow','height=350,width=600,top=100,left=200,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no');\" />";
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//说明文字
if (field_type == "说明文字")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//编辑器
if (field_type == "编辑器")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
//隐藏文本框
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
txtTextBox.Style.Value = "display:none";
tCell2.Controls.Add(txtTextBox);
//编辑器
Label txtTextBox2 = new Label();
txtTextBox2.ID = "eWebEditor" + dtfield.Rows[0]["hy_fieldid"].ToString();
field_docvalue = "<iframe ID=\"eWebEditor" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"system/eWebEditor/ewebeditor.htm?id=" + dtfield.Rows[0]["hy_fieldid"].ToString() + "&style=Portal\" frameborder=0 scrolling=no width=" + dtfield.Rows[0]["hy_width"].ToString() + " height=" + dtfield.Rows[0]["hy_height"].ToString() + "></iframe>";
txtTextBox2.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox2);
}
}
//痕迹保留
if (field_type == "痕迹保留")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/readoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
//如果是流程模块，则根据环节判断一下
if (ifflowdoc == "1")
{
//判断是否为第一环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, "*");
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == this.hy_curtacheid.Text)
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
}
else
{
//判断是否为最后一个环节
dtflowwork.Clear();
dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
}
else
{
field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> ";
}
}
}
}
}
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//IFRAME列表
if (field_type == "IFRAME列表")
{
//-----开始输出字段------
if (ls_laborinput == "0") //输出LABLE
{
field_docvalue = "<iframe id=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" name=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"" + dtfield.Rows[0]["hy_defaultvalue"].ToString() + "&motherid=" + this.txtdocid.Value + "&ishaverole=0\" frameborder=\"0\" scrolling=\"yes\" height=\"80px\" width=\"98%\"></iframe>";
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
else
{
field_docvalue = "<iframe id=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" name=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"" + dtfield.Rows[0]["hy_defaultvalue"].ToString() + "&motherid=" + this.txtdocid.Value + "&ishaverole=1\" frameborder=\"0\" scrolling=\"yes\" height=\"80px\" width=\"98%\"></iframe>";
Label txtTextBox = new Label();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
txtTextBox.Text = field_docvalue;
tCell2.Controls.Add(txtTextBox);
}
}
//子表信息带链接
//子表信息不带链接
}
return li_return;
}
//输出一个字段
public void GetFieldHtml(TableRow tRow, int li_colnums_show, string hy_fieldid)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
//得到字段属性
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, hy_fieldid, this.txttableid.Value);
if (dtfield.Rows.Count > 0)
{
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString();
//插入单元格（左侧）
TableCell tCell = new TableCell();
tRow.Cells.Add(tCell);
tCell.Width = Unit.Percentage((30 / li_colnums_show));
tCell.Height = Unit.Pixel(30);
tCell.CssClass = "Tdcellleft";
tCell.HorizontalAlign = HorizontalAlign.Center;
tCell.Controls.Add(new LiteralControl(dtfield.Rows[0]["hy_fieldname"].ToString()));
//插入单元格（右侧）
TableCell tCell2 = new TableCell();
tRow.Cells.Add(tCell2);
tCell2.Width = Unit.Percentage((70 / li_colnums_show));
tCell2.Height = Unit.Pixel(30);
tCell2.CssClass = "Tdcellright";
tCell2.HorizontalAlign = HorizontalAlign.Left;
//单行文本
if (field_type == "文本")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//多行文本
if (field_type == "多行文本")
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString());
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//日期
if (field_type == "日期")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_s";
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox.Attributes.Add("onclick", "WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_s" + "')})");
tCell2.Controls.Add(txtTextBox);
tCell2.Controls.Add(new LiteralControl("至"));
TextBox txtTextBox2 = new TextBox();
txtTextBox2.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_e";
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
txtTextBox2.ReadOnly = true;
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox2.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox2.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox2.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
txtTextBox2.Attributes.Add("onclick", "WdatePicker({el:$dp.$('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_e" + "')})");
tCell2.Controls.Add(txtTextBox2);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_s", "1");
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_e", "2");
}
//文本加按钮
if (field_type == "文本加按钮")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("60%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
Button btnButton = new Button();
btnButton.ID = "btn_" + dtfield.Rows[0]["hy_fieldid"].ToString();
btnButton.CssClass = "btn3";
btnButton.Text = " 选 择 ";
btnButton.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
tCell2.Controls.Add(btnButton);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//多行文本加按钮
if (field_type == "多行文本加按钮")
{
TextBox txtTextBox = new TextBox();
txtTextBox.TextMode = TextBoxMode.MultiLine;
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
//if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
//{
// txtTextBox.ReadOnly = true;
//}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("60%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
Button btnButton = new Button();
btnButton.ID = "btn_" + dtfield.Rows[0]["hy_fieldid"].ToString();
btnButton.CssClass = "btn3";
btnButton.Text = " 选 择 ";
btnButton.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString());
tCell2.Controls.Add(btnButton);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//数值
if (field_type == "数值")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_s";
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
tCell2.Controls.Add(new LiteralControl("至"));
TextBox txtTextBox2 = new TextBox();
txtTextBox2.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_e";
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox2.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
txtTextBox2.Width = Unit.Parse("45%");
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox2.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox2);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_s", "3");
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString() + "_e", "4");
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
DropDownList ddlDropDownList = new DropDownList();
ddlDropDownList.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
ddlDropDownList.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
ddlDropDownList.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
ddlDropDownList.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString());
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
//手工配置
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (int i = 0; i < lv_options.Length; i++)
{
ddlDropDownList.Items.Add(lv_options[i].ToString());
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
//SQL语句
if (dtfield.Rows[0]["hy_options"].ToString() != "")
{
DataTable dt_options = Hyoa_global.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
ddlDropDownList.DataSource = dt_options;
ddlDropDownList.DataTextField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataValueField = dt_options.Columns[0].ColumnName;
ddlDropDownList.DataBind();
}
}
ddlDropDownList.Items.Insert(0, new ListItem("--请选择--", ""));
tCell2.Controls.Add(ddlDropDownList);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//复选框(查询时直接显示文本框)
if (field_type == "复选框")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
//单选框(查询时直接显示文本框)
if (field_type == "单选框")
{
TextBox txtTextBox = new TextBox();
txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString();
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString();
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString());
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString());
}
tCell2.Controls.Add(txtTextBox);
//插入字段：共有哪几个查询条件
addsearchfields(dtfield.Rows[0]["hy_fieldid"].ToString(), "0");
}
}
}
private void DataPlay()
{
//是否启用
this.ddlifsearch.Items.Insert(0, "是");
this.ddlifsearch.Items.Insert(1, "否");
this.ddlifflowdoc.Items.Insert(0, "是");
this.ddlifflowdoc.Items.Insert(1, "否");
this.ddlifshowsearch.Items.Insert(0, "是");
this.ddlifshowsearch.Items.Insert(1, "否");
//模块编号
//加载模块信息
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudels();
if (dtmudel.Rows.Count > 0)
{
this.ddlmudelid.DataSource = dtmudel;
this.ddlmudelid.DataTextField = "hy_mudelname";
this.ddlmudelid.DataValueField = "hy_mudelid";
this.ddlmudelid.DataBind();
this.ddlmudelid.Items.Insert(0, new ListItem("请选择", "请选择"));
this.ddlmudelid.SelectedIndex = 0;
}
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//判断当前用户是否有保存的权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.btn_submit.Visible = true; //保存
}
else
{
this.btn_submit.Visible = false; //保存
}
//旧文档
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["id"] != null)
{
//根据id得到信息
this.txtdocid.Value = this.Request.QueryString["id"].ToString();
DataTable dt = Hyoa_listconfig.Getlistconfig(this.txtdocid.Value);
if (dt.Rows.Count > 0)
{
this.txtsort.Text = dt.Rows[0]["hy_sort"].ToString();
if (dt.Rows[0]["hy_ifsearch"].ToString() == "是")
{
this.ddlifsearch.SelectedIndex = 0;
}
else
{
this.ddlifsearch.SelectedIndex = 1;
}
if (dt.Rows[0]["hy_ifshowsearch"].ToString() != "否")
{
this.ddlifshowsearch.SelectedIndex = 0;
}
else
{
this.ddlifshowsearch.SelectedIndex = 1;
}
this.ddlmudelid.SelectedValue = dt.Rows[0]["hy_mudelid"].ToString();
if (dt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
this.ddlifflowdoc.SelectedIndex = 0;
}
else
{
this.ddlifflowdoc.SelectedIndex = 1;
}
this.txthy_listname.Text = dt.Rows[0]["hy_listname"].ToString();
this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();
//加载所有列信息
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield;
//dtflowfield = Hyoa_flowfield.Getflowfields();
dtflowfield = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dtflowfield.Rows.Count > 0)
{
this.ddlcolumnshow.DataSource = dtflowfield;
this.ddlcolumnshow.DataTextField = "hy_fieldname";
this.ddlcolumnshow.DataValueField = "hy_fieldid";
this.ddlcolumnshow.DataBind();
this.ddlcolumnshow.SelectedIndex = 0;
}
dtflowfield.Clear();
//将列都列出来
string[] lv_columnshowselect;
string[] lv_columnshowselectid;
lv_columnshowselect = dt.Rows[0]["hy_columnshow"].ToString().Split(',');
lv_columnshowselectid = dt.Rows[0]["hy_columnshowid"].ToString().Split(',');
for (int j = 0; j < lv_columnshowselect.Length; j++)
{
this.ddlcolumnshowselect.Items.Insert(j, new ListItem(lv_columnshowselect[j], lv_columnshowselectid[j]));
}
//根据模块信息得到对应的选择表单值
if (dt.Rows[0]["hy_tableid"] != "" && dt.Rows[0]["hy_tableid"] != null)
{
this.ddltableid.Items.Clear();
//根据模块ID得到表单ID
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dtgettableid = Hyoa_tableconfig.GetTablesbymudelid(dt.Rows[0]["hy_mudelid"].ToString());
if (dtgettableid.Rows.Count > 0)
{
for (var i = 0; i < dtgettableid.Rows.Count; i++)
{
this.ddltableid.Items.Insert(i, new ListItem(dtgettableid.Rows[i]["hy_name"].ToString(), dtgettableid.Rows[i]["ID"].ToString()));
}
this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
this.ddltableid.Attributes.Add("onchange ", "mudelidonchang() ");
//定位
this.ddltableid.SelectedValue = dt.Rows[0]["hy_tableid"].ToString();
}
}
//排序的字段
//根据模块ID+表单ID+字段ID得到字段中文名
DataTable dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield1"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dt_flowfield.Rows.Count > 0)
{
this.searchsort1.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield1"].ToString()));
}
this.ddlsorttype1.SelectedValue = dt.Rows[0]["hy_sorttype1"].ToString();
dt_flowfield.Clear();
dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield2"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dt_flowfield.Rows.Count > 0)
{
this.searchsort2.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield2"].ToString()));
}
this.ddlsorttype2.SelectedValue = dt.Rows[0]["hy_sorttype2"].ToString();
dt_flowfield.Clear();
dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield3"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
if (dt_flowfield.Rows.Count > 0)
{
this.searchsort3.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield3"].ToString()));
}
this.ddlsorttype3.SelectedValue = dt.Rows[0]["hy_sorttype3"].ToString();
dt_flowfield.Clear();
//分类的字段
this.txthy_field_fl1.Text = dt.Rows[0]["hy_sql_fl1"].ToString();
if (dt.Rows[0]["hy_fieldid_fl1"].ToString() != "")
{
this.flfield1.Items.Insert(0, new ListItem(dt.Rows[0]["hy_fieldname_fl1"].ToString(), dt.Rows[0]["hy_fieldid_fl1"].ToString()));
}
this.txthy_field_fl2.Text = dt.Rows[0]["hy_sql_fl2"].ToString();
if (dt.Rows[0]["hy_fieldid_fl2"].ToString() != "")
{
this.flfield2.Items.Insert(0, new ListItem(dt.Rows[0]["hy_fieldname_fl2"].ToString(), dt.Rows[0]["hy_fieldid_fl2"].ToString()));
}
this.txthy_field_fl3.Text = dt.Rows[0]["hy_sql_fl3"].ToString();
if (dt.Rows[0]["hy_fieldid_fl3"].ToString() != "")
{
this.flfield3.Items.Insert(0, new ListItem(dt.Rows[0]["hy_fieldname_fl3"].ToString(), dt.Rows[0]["hy_fieldid_fl3"].ToString()));
}
}
dt.Clear();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
DataTable dt5 = Hyoa_listsearchfield.Getlistsearchfieldsbylistid(this.txtdocid.Value);
if (dt5.Rows.Count > 0)
{
for (int m = 0; m < dt5.Rows.Count; m++)
{
this.searchselect.Items.Insert(m, new ListItem(dt5.Rows[m]["hy_field"].ToString(), dt5.Rows[m]["hy_fieldid"].ToString()));
}
}
}
}
else
{
//自动获取最大排序号，然后+2
DataTable dt_maxsort = Hyoa_listconfig.GetMaxlistconfigsort();
if (dt_maxsort.Rows.Count > 0)
txtsort.Text = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString();
else
txtsort.Text = "1";
}
}
}
//得到某一个字段的HTML Written by xf 20110515
//pi_flag 0:不赋值 1：需赋值
//ifsearch:是否查询时使用 0:非查询时使用 1:查询时使用
//docid:旧文档使用时，文档ID,新文档则为空就可以
//ifhavarole：是否有权限 0：lable输出 1：input输出
public string GetFieldHtml(string hy_mudelid, string hy_fieldid, string pi_flag, string hy_tableid, string ifsearch, string docid, string ifhavarole)
{
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(hy_mudelid, hy_fieldid, hy_tableid);
HyoaClass.DAO db = new HyoaClass.DAO();
string lsField = "";
string field_css = "";
string field_value = "";
string field_functionhy_onclick = "";
string field_functionhy_ondblclick = "";
string field_functionhy_onchange = "";
string field_functionhy_onkeydown = "";
string field_functionhy_onkeyup = "";
string field_wordlimit = "";
if (dtfield.Rows.Count > 0)
{
//得到该字段的样式start
if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是")
{
if (ifsearch == "0")
field_css += " readonly ";
}
if (dtfield.Rows[0]["hy_class"].ToString() != "")
{
field_css += " class='" + dtfield.Rows[0]["hy_class"].ToString() + "' ";
}
if (dtfield.Rows[0]["hy_width"].ToString() != "")
{
field_css += " style='width:" + dtfield.Rows[0]["hy_width"].ToString() + ";";
}
else
{
field_css += " style='";
}
if (dtfield.Rows[0]["hy_height"].ToString() != "")
{
field_css += " height:" + dtfield.Rows[0]["hy_height"].ToString() + "'";
}
else
{
field_css += "'";
}
//得到字数限制
if (dtfield.Rows[0]["hy_wordlimit"].ToString() != "")
{
field_wordlimit += " maxlength='" + dtfield.Rows[0]["hy_wordlimit"].ToString() + "' ";
}
//默认值
//默认值取值的方式,查询时不使用默认值
if (ifsearch == "0")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "")
{
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "0")
field_value += dtfield.Rows[0]["hy_defaultvalue"].ToString();
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "1")
{
DataTable dtdefault = db.GetDataTable(dtfield.Rows[0]["hy_defaultvalue"].ToString());
if (dtdefault.Rows.Count > 0)
field_value += dtdefault.Rows[0][0].ToString();
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "2")
{
field_value += Session[dtfield.Rows[0]["hy_defaultvalue"].ToString()].ToString();
}
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "3")
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
field_value += System.DateTime.Now.ToShortDateString();
else
field_value += System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
//自动生成值的情况 Added by xf 20110719
if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "4")
{
if (dtfield.Rows[0]["hy_fieldtype"].ToString() == "数值")
{
//得到目前最大的数值，然后+1，未找到则赋值为1
HyoaClass.DAO db_autovalue = new HyoaClass.DAO();
DataTable dt_autovalue = db_autovalue.GetDataTable("select max(hy_field36) as maxint from hyp_flowmain where hy_tableid='" + dtfield.Rows[0]["hy_tableid"].ToString() + "'");
if (dt_autovalue.Rows[0]["maxint"].ToString() == null || dt_autovalue.Rows[0]["maxint"].ToString() == "")
field_value += "1";
else
field_value += (System.Int32.Parse(dt_autovalue.Rows[0]["maxint"].ToString()) + 1).ToString();
}
else
{
field_value += System.Guid.NewGuid().ToString();
}
}
}
}
//事件
if (dtfield.Rows[0]["hy_onclick"].ToString() != "")
{
field_functionhy_onclick += " onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "")
{
field_functionhy_ondblclick += " ondblclick=\"" + dtfield.Rows[0]["hy_ondblclick"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onchange"].ToString() != "")
{
field_functionhy_onchange += " onchange=\"" + dtfield.Rows[0]["hy_onchange"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "")
{
field_functionhy_onkeydown += " onkeydown=\"" + dtfield.Rows[0]["hy_onkeydown"].ToString() + "\" ";
}
if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "")
{
field_functionhy_onkeyup += " onkeyup=\"" + dtfield.Rows[0]["hy_onkeyup"].ToString() + "\" ";
}
//得到该字段的样式end
string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString();
//是否需要赋值,如果需要赋值，得到当前字段对应的值(日期型需要根据格式进行转换)
string field_docvalue = "";
//this.Response.Write("<script>alert('" + pi_flag + "');</script>");
if (pi_flag == "1")
{
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt_flowmain = Hyoa_flowmain.Getflowmain(docid);
if (dt_flowmain.Rows.Count > 0)
{
if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
field_docvalue = System.DateTime.Parse(dt_flowmain.Rows[0][dtfield.Rows[0]["hy_sqlfield"].ToString()].ToString()).ToShortDateString();
}
else
{
//如果SQL为数值的字段部分，则需要截取小数点后边两位
if (dtfield.Rows[0]["hy_fieldtype"].ToString() == "数值")
{
if (dt_flowmain.Rows[0][dtfield.Rows[0]["hy_sqlfield"].ToString()].ToString().Contains(".") == true)
field_docvalue = float.Parse(dt_flowmain.Rows[0][dtfield.Rows[0]["hy_sqlfield"].ToString()].ToString()).ToString("F2");
else
field_docvalue = dt_flowmain.Rows[0][dtfield.Rows[0]["hy_sqlfield"].ToString()].ToString();
}
else
{
field_docvalue = dt_flowmain.Rows[0][dtfield.Rows[0]["hy_sqlfield"].ToString()].ToString();
}
}
}
}
//如果没有权限，直接输出lable
//this.Response.Write("<script>alert('" + ifhavarole + "');</script>");
if (ifhavarole == "0")
{
//痕迹保留
if (field_type == "痕迹保留")
{
lsField += "<input type=button id=\"btn_zwxg\" value='正 文' class=btn3 onclick=\"window.open('ntko/readoffice.aspx?newofficetype=1&fatherid=" + docid + "&tacheByhj=1&jsxd=1','newwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" ";
}
else
{
//附件组件
if (field_type == "附件组件")
{
//根据docid得到目前已上传的附件信息
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt();
DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatherid(docid);
if (dt_fileatt.Rows.Count > 0)
{
for (var ii = 0; ii < dt_fileatt.Rows.Count; ii++)
{
string ls_name = "";
DataTable dt_user = Hyoa_user.Getuser(dt_fileatt.Rows[ii]["hy_userid"].ToString());
if (dt_user.Rows.Count > 0)
{
ls_name = dt_user.Rows[0]["hy_username"].ToString();
}
lsField += (ii + 1).ToString() + "、<a href=\"" + dt_fileatt.Rows[ii]["hy_filepath"].ToString() + "\" target=_blank>" + dt_fileatt.Rows[ii]["hy_filename"].ToString() + " " + ls_name + " [" + dt_fileatt.Rows[ii]["hy_djsj"].ToString() + "]" + "</a><br />";
}
}
else
{
lsField += " ";
}
}
else
{
//ztmztmztm2start
if (field_docvalue.Length > 8)
{
if (field_docvalue.Substring(0, 8) == "1900-1-1")
{
field_docvalue = " ";
}
}
//ztmztmztm2end
lsField = field_docvalue + " ";
}
}
}
else
{
//单行文本
if (field_type == "文本")
{
if (pi_flag == "0")
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_value + "\">";
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_docvalue + "\">";
}
//多行文本
if (field_type == "多行文本")
{
//格式化内容，将<br>转为/n
if (field_docvalue.Contains("<br>"))
field_docvalue = field_docvalue.Replace("<br>", "\n");
if (pi_flag == "0")
lsField = "<textarea name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_css + field_wordlimit + " >" + field_value + "</textarea>";
else
lsField = "<textarea name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_css + field_wordlimit + " >" + field_docvalue + "</textarea>";
}
//日期
if (field_type == "日期")
{
//this.Response.Write("<script>alert('aaaaaa');</script>");
//this.Response.Write("<script>alert('" + pi_flag + "');</script>");
if (ifsearch == "0")
{
if (pi_flag == "0")
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + field_wordlimit + " value=\"" + field_value + "\">";
else
{
//add ztm3 start
if (field_docvalue.Length > 7)
{
if (field_docvalue.Substring(0, 8) == "1900-1-1")
{
field_docvalue = "";
}
}
//add ztm3 end
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + field_wordlimit + " value=\"" + field_docvalue + "\">";
}
}
else
{
//this.Response.Write("<script>alert('aaaa');</script>");
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" " + field_functionhy_onclick + field_css + field_wordlimit + " value=\"" + field_value + "\">至";
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" " + field_functionhy_onclick + field_css + field_wordlimit + " value=\"" + field_value + "\">";
}
}
//文本加按钮
if (field_type == "文本加按钮")
{
if (pi_flag == "0")
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_value + "\"> <input type=button id=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" name=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" value=" + dtfield.Rows[0]["hy_fieldname"].ToString() + " class=btn3 " + field_functionhy_onclick + " >";
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_docvalue + "\"> <input type=button id=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" name=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" value=" + dtfield.Rows[0]["hy_fieldname"].ToString() + " class=btn3 " + field_functionhy_onclick + " >";
}
//多行文本加按钮
if (field_type == "多行文本加按钮")
{
//格式化内容，将<br>转为/n
if (field_docvalue.Contains("<br>"))
field_docvalue = field_docvalue.Replace("<br>", "\n");
if (pi_flag == "0")
lsField = "<textarea name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_wordlimit + " " + field_css + " >" + field_value + "</textarea> <input type=button id=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" name=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" value=" + dtfield.Rows[0]["hy_fieldname"].ToString() + " class=btn3 " + field_functionhy_onclick + " >";
else
lsField = "<textarea name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_wordlimit + " " + field_css + " >" + field_docvalue + "</textarea> <input type=button id=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" name=\"btn_" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "\" value=" + dtfield.Rows[0]["hy_fieldname"].ToString() + " class=btn3 " + field_functionhy_onclick + " >";
}
//数值
if (field_type == "数值")
{
if (ifsearch == "0")
{
if (pi_flag == "0")
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_value + "\">";
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_docvalue + "\">";
}
else
{
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_start_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_value + "\">到";
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" type=text id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_end_1\" " + field_functionhy_onclick + field_functionhy_ondblclick + field_functionhy_onkeydown + field_functionhy_onkeyup + field_css + field_wordlimit + " value=\"" + field_value + "\">";
}
}
//对话框列表（下拉框
if (field_type == "对话框列表")
{
lsField = "<select name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onchange + field_css + "> ";
//第一项：请选择
lsField += "<option value=''>--请选择--</option>";
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (pi_flag == "0")
{
lsField += "<option value='" + lv_options[ii].ToString() + "'>" + lv_options[ii].ToString() + "</option>";
}
else
{
if (field_docvalue == lv_options[ii].ToString())
lsField += "<option value='" + lv_options[ii].ToString() + "' selected>" + lv_options[ii].ToString() + "</option>";
else
lsField += "<option value='" + lv_options[ii].ToString() + "'>" + lv_options[ii].ToString() + "</option>";
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (pi_flag == "0")
{
lsField += "<option value='" + dtoptions.Rows[ii][0].ToString() + "'>" + dtoptions.Rows[ii][0].ToString() + "</option>";
}
else
{
if (field_docvalue == dtoptions.Rows[ii][0].ToString())
lsField += "<option value='" + dtoptions.Rows[ii][0].ToString() + "' selected>" + dtoptions.Rows[ii][0].ToString() + "</option>";
else
lsField += "<option value='" + dtoptions.Rows[ii][0].ToString() + "'>" + dtoptions.Rows[ii][0].ToString() + "</option>";
}
}
}
}
lsField += "</select>";
}
//复选框
if (field_type == "复选框")
{
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (pi_flag == "0")
{
if (field_value == lv_options[ii].ToString())
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
else
{
if (field_docvalue.Contains(lv_options[ii].ToString()))
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (pi_flag == "0")
{
if (field_value == dtoptions.Rows[ii][0].ToString())
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
else
{
if (field_docvalue.Contains(dtoptions.Rows[ii][0].ToString()))
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=checkbox id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
}
}
}
}
//单选框
if (field_type == "单选框")
{
//有哪些选项
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0")
{
string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#');
for (var ii = 0; ii < lv_options.Length; ii++)
{
if (pi_flag == "0")
{
if (field_value == lv_options[ii].ToString())
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
else
{
if (field_docvalue == lv_options[ii].ToString())
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + lv_options[ii].ToString() + "\" />" + lv_options[ii].ToString();
}
}
}
if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1")
{
DataTable dtoptions = db.GetDataTable(dtfield.Rows[0]["hy_options"].ToString());
if (dtoptions.Rows.Count > 0)
{
for (var ii = 0; ii < dtoptions.Rows.Count; ii++)
{
if (pi_flag == "0")
{
if (field_value == dtoptions.Rows[ii][0].ToString())
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
else
{
if (field_docvalue == dtoptions.Rows[ii][0].ToString())
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio checked=true id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
else
lsField += "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=radio id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1_" + ii.ToString() + "\" " + field_functionhy_onclick + " value=\"" + dtoptions.Rows[ii][0].ToString() + "\" />" + dtoptions.Rows[ii][0].ToString();
}
}
}
}
}
//口令
if (field_type == "口令")
{
if (pi_flag == "0")
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=password id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + field_wordlimit + " value=\"" + field_value + "\">";
else
lsField = "<input name=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" type=password id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\" " + field_functionhy_onclick + field_css + field_wordlimit + " value=\"" + field_docvalue + "\">";
}
//附件组件
if (field_type == "附件组件")
{
lsField = "";
//根据docid得到目前已上传的附件信息
HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt();
DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatherid(docid);
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
if (dt_fileatt.Rows.Count > 0)
{
for (var ii = 0; ii < dt_fileatt.Rows.Count; ii++)
{
string ls_name = "";
DataTable dt_user = Hyoa_user.Getuser(dt_fileatt.Rows[ii]["hy_userid"].ToString());
if (dt_user.Rows.Count > 0)
{
ls_name = dt_user.Rows[0]["hy_username"].ToString();
}
lsField += (ii + 1).ToString() + "、<a href=\"" + dt_fileatt.Rows[ii]["hy_filepath"].ToString() + "\" target=_blank>" + dt_fileatt.Rows[ii]["hy_filename"].ToString() + "</a> " + ls_name + " [" + dt_fileatt.Rows[ii]["hy_djsj"].ToString() + "]" + "<br />";
}
}
lsField += "<input type=button id=\"uploadfile1\" value='附件管理' class=btn3 onclick=\"window.open('/ggdy/main_fileatt.aspx?fatherid=" + docid + "','newwindow','height=350,width=600,top=100,left=200,toolbar=no,menubar=no,scrollbars=yes, resizable=no,location=no, status=no');\" ";
}
//说明文字
if (field_type == "说明文字")
{
lsField = "<span id=\"" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "_1\">" + field_value + "</span>";
}
//编辑器
if (field_type == "编辑器")
{
//lsField = "<textarea name=\"hy_content1_1\" id=\"hy_content1_1\" style=\"display:none\" runat="server">" + field_docvalue + "</textarea>";
lsField += "<iframe ID=\"eWebEditor1\" src=\"system/eWebEditor/ewebeditor.htm?id=" + dtfield.Rows[0]["hy_sqlfield"].ToString() + "&style=Portal\" frameborder=\"0\" scrolling=\"no\" width=\"100%\" height=\"350\"></iframe>";
}
//痕迹保留
//this.Response.Write("<script>alert('" + field_type + "');</script>");
if (field_type == "痕迹保留")
{
//判断是否为第一环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, "*");
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == this.hy_curtacheid.Text)
{
lsField += "<input type=button id=\"btn_zwxg\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + docid + "&tacheByhj=1&jsxd=0','newwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" ";
}
else
{
//判断是否为最后一个环节
dtflowwork.Clear();
dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
{
lsField += "<input type=button id=\"btn_zwxg\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + docid + "&tacheByhj=0&jsxd=1','newwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" ";
}
else
{
lsField += "<input type=button id=\"btn_zwxg\" value='正 文' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + docid + "&tacheByhj=0&jsxd=0','newwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" ";
}
}
}
}
}
}
db.Close();
}
return lsField;
}
//需要导出的内容
private string getExcelContent()
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
#region ---查询条件---
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
#endregion ---查询条件---
#region ---排序---
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (cmdStr_SearchSort == "")
{
//没有配置，则默认按登记日期
cmdStr_SearchSort = " order by hy_djsj desc ";
}
#endregion ---排序---
#region --根据查询条件得到返回数据集--
DataTable dt = new DataTable(); //单页数据集
DataTable dt_total = new DataTable(); //数据总条数，返回总条数值
DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc
string cmdStr = "";
if (dttable.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
if (dttable.Rows[0]["hy_ispuballByflowYB"].ToString() == "是")
{
string ls_from = "";
if (Session["conntype"].ToString() == "SQL")
{
ls_from = " hyc_" + this.txttableid.Value + " a,hyp_flowhistoryinfo_cl b where a.DOCID=b.DOCID and (','+b.hy_clrid+',' like '%," + Session["hyuid"].ToString() + ",%' or ','+b.hy_cyrid+',' like '%," + Session["hyuid"].ToString() + ",%' or a.hy_curtacheid='**') and b.hy_ifth!='是' " + cmdStr_Search;
//cmdStr = "select distinct top 10 a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj,a.hy_readuserlist,a.hy_readdatelist,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from;
//cmdStr += " and a.DOCID not in (select top " + ((PageNo - 1) * 10).ToString() + " a.DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
cmdStr = "select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,";
cmdStr += "a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,";
cmdStr += "a.hy_zhtxsj,a.hy_readuserlist,a.hy_readdatelist,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from + cmdStr_SearchSort;
}
dt = Hyoa_global.GetDataTable(cmdStr);
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select count(*) from (select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj,a.hy_readuserlist,a.hy_readdatelist,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from + " ) f";
}
dt_total = Hyoa_global.GetDataTable(cmdStr);
//dt = Hyoa_flowmain.GetflowmainsByIf_jsDisplayAll(); //输出流程的dt
}
else
{
string ls_from = "";
if (Session["conntype"].ToString() == "SQL")
{
ls_from = " hyc_" + this.txttableid.Value + " a,hyp_flowhistoryinfo_cl b where a.DOCID=b.DOCID and (','+b.hy_clrid+',' like '%," + Session["hyuid"].ToString() + ",%' or ','+b.hy_cyrid+',' like '%," + Session["hyuid"].ToString() + ",%') and b.hy_ifth!='是' " + cmdStr_Search;
//cmdStr = "select distinct top 10 a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj,a.hy_readuserlist,a.hy_readdatelist,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from;
//cmdStr += " and a.DOCID not in (select top " + ((PageNo - 1) * 10).ToString() + " a.DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
cmdStr = "select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,";
cmdStr += "a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,";
cmdStr += "a.hy_zhtxsj,a.hy_readuserlist,a.hy_readdatelist,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from + cmdStr_SearchSort;
}
dt = Hyoa_global.GetDataTable(cmdStr);
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select count(*) from (select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj,a.hy_readuserlist,a.hy_readdatelist,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from + " ) f";
}
dt_total = Hyoa_global.GetDataTable(cmdStr);
//dt = Hyoa_flowmain.GetflowmainsByIf(); //输出流程的dt
}
}
else
{
if (dttable.Rows[0]["hy_ifdisplayall"].ToString() == "是")
{
string ls_from = "";
ls_from = " hyc_" + this.txttableid.Value + " where 1=1 " + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select * from " + ls_from + cmdStr_SearchSort;
//cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * 10).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
}
else
{
string ls_from = "";
//ls_from = " hyc_" + this.txttableid.Value + " where hy_djrid='" + Session["hyuid"].ToString() + "' " + cmdStr_Search;
ls_from = " hyc_" + this.txttableid.Value + " where 1=1 " + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select * from " + ls_from + cmdStr_SearchSort;
//cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * 10).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
}
}
#endregion --根据查询条件得到返回数据集--
//开始输出----整合成HTML为数据行
StringBuilder sb = new StringBuilder();
string lscolname = "";
string lscolnameid = "";
string lscolwidth = "";
string[] lvcolname;
string[] lvcolnameid;
string[] lvcolwidth;
string lscolwidthper;
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(',');
string ls_colspan = (lvcolname.Length + 1).ToString();
sb.Append("<table border='1'>");
sb.Append("<thead><tr><th colSpan='" + ls_colspan + "' class='ztitle'>" + this.lblcurtachenameshow.Text + "</th></tr>");
sb.Append("<tr><th colSpan='" + ls_colspan + "' class='tdheight20'></th></tr>");
sb.Append("<tr>");
sb.Append("<th style='width:70px;' class='tdcenter'>序号</th>");
//如果没有数据则输出表头
for (int n = 0; n < lvcolname.Length; n++)
{
if (n >= lvcolwidth.Length)
{
//此判断是为了防止对应宽度没有输入时，会溢出报错。
lscolwidthper = "100";
}
else
{
lscolwidthper = (int.Parse(lvcolwidth[n]) * 20).ToString();
}
sb.Append("<th style='width:" + lscolwidthper + "px;' class='tdcenter'>" + lvcolname[n] + "</th>");
}
sb.Append("</tr></thead>");
if (dt.Rows.Count <= 0)
{
sb.Append("</table>");
}
else
{
//如果有数据，则输出数据
sb.Append("<tbody>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td class='tdcenter'>" + (i + 1).ToString() + "</td>"); //序号
//////开始得到列的值
DataTable dtgetsqlfield;
for (int m = 0; m < lvcolname.Length; m++)
{
//根据字段英文名，得到数据库中对应的字段
dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lvcolnameid[m], this.txttableid.Value);
string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString();
//根据数据库中对应的字段，得到输出字段的值start (日期型根据格式进行了转换)
string lsgetputfiled = "";
if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
lsgetputfiled = System.DateTime.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString("yyyy-MM-dd");
}
else
{
//解决Float小数点后面出现N位小数乱码的问题
if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "数值")
{
if (dt.Rows[i][lsgetsqlfield].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();
}
}
else
{
lsgetputfiled = "0";
}
//lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
else
{
lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
}
if (lsgetputfiled == "")
lsgetputfiled = " ";
sb.Append("<td class='tdcenter'>" + lsgetputfiled + "</td>");
}
sb.Append("</tr>");
}
sb.Append("</tbody></table>");
}
return sb.ToString();
}
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_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//如果非流程(授权用户统一管理)
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 = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
}
}
//如果非流程(每个人管理自己的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1")
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
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 = true;
this.delcontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
//---查询条件---结束
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (this.txtfieldid.Value != "" && this.txtfieldsort.Value != "")
{
cmdStr_SearchSort = " order by hyc_" + this.txtfieldid.Value + " " + this.txtfieldsort.Value + " ";
}
if (cmdStr_SearchSort == "")
{
//没有配置，则默认按登记日期
cmdStr_SearchSort = " order by hy_djsj desc ";
}
//---排序---结束
//通过URL传过来的分类选择值 added by xf 2012-02-11
string ls_key = "";
string ls_subkey = "";
string ls_threekey = "";
if (Request.QueryString["key"] != null)
{
ls_key = Request.QueryString["key"].ToString();
}
if (Request.QueryString["subkey"] != null)
{
ls_subkey = Request.QueryString["subkey"].ToString();
}
if (Request.QueryString["threekey"] != null)
{
ls_threekey = Request.QueryString["threekey"].ToString();
}
//显示分类列表中的分类字段1 added by xf 2012-02-11
if (dtlist.Rows[0]["hy_sql_fl1"].ToString() != "")
{
int li_i = 0; //默认值
//如果配置中包含了#，则手工配置型，否则执行SQL语句
this.ddlflfield.Items.Insert(0, new ListItem("--请选择--", ""));
if (dtlist.Rows[0]["hy_sql_fl1"].ToString().Contains("#"))
{
string[] lv_temp = dtlist.Rows[0]["hy_sql_fl1"].ToString().Split('#');
for (var i = 0; i < lv_temp.Length; i++)
{
this.ddlflfield.Items.Insert(i + 1, new ListItem(lv_temp[i], lv_temp[i]));
//默认值
if (lv_temp[i] == ls_key)
li_i = i + 1;
}
}
else
{
string hy_sql_fl1 = dtlist.Rows[0]["hy_sql_fl1"].ToString();
if (hy_sql_fl1.Contains("当前用户ID"))
hy_sql_fl1 = hy_sql_fl1.Replace("当前用户ID", "'" + Session["hyuid"].ToString() + "'");
DataTable dt_flxx = Hyoa_global.GetDataTable(hy_sql_fl1);
if (dt_flxx.Rows.Count > 0)
{
for (var i = 0; i < dt_flxx.Rows.Count; i++)
{
this.ddlflfield.Items.Insert(i + 1, new ListItem(dt_flxx.Rows[i][0].ToString(), dt_flxx.Rows[i][0].ToString()));
//默认值
if (dt_flxx.Rows[i][0].ToString() == ls_key)
li_i = i + 1;
}
}
}
ddlflfield.SelectedIndex = li_i;
}
//显示分类列表中的分类字段2 added by xf 2012-02-11
if (dtlist.Rows[0]["hy_sql_fl2"].ToString() != "")
{
int li_i = 0; //默认值
//如果配置中包含了#，则手工配置型，否则执行SQL语句
this.ddlflfield.Items.Insert(0, new ListItem("--请选择--", ""));
if (dtlist.Rows[0]["hy_sql_fl2"].ToString().Contains("#"))
{
string[] lv_temp = dtlist.Rows[0]["hy_sql_fl2"].ToString().Split('#');
for (var i = 0; i < lv_temp.Length; i++)
{
this.ddlflfield2.Items.Insert(i + 1, new ListItem(lv_temp[i], lv_temp[i]));
//默认值
if (lv_temp[i] == ls_subkey)
li_i = i + 1;
}
}
else
{
string hy_sql_fl2 = dtlist.Rows[0]["hy_sql_fl2"].ToString();
if (hy_sql_fl2.Contains("当前用户ID"))
hy_sql_fl2 = hy_sql_fl2.Replace("当前用户ID", "'" + Session["hyuid"].ToString() + "'");
DataTable dt_flxx = Hyoa_global.GetDataTable(hy_sql_fl2);
if (dt_flxx.Rows.Count > 0)
{
for (var i = 0; i < dt_flxx.Rows.Count; i++)
{
this.ddlflfield2.Items.Insert(i + 1, new ListItem(dt_flxx.Rows[i][0].ToString(), dt_flxx.Rows[i][0].ToString()));
//默认值
if (dt_flxx.Rows[i][0].ToString() == ls_subkey)
li_i = i + 1;
}
}
}
ddlflfield2.SelectedIndex = li_i;
}
//显示分类列表中的分类字段3 added by xf 2012-02-11
if (dtlist.Rows[0]["hy_sql_fl3"].ToString() != "")
{
int li_i = 0; //默认值
//如果配置中包含了#，则手工配置型，否则执行SQL语句
this.ddlflfield3.Items.Insert(0, new ListItem("--请选择--", ""));
if (dtlist.Rows[0]["hy_sql_fl3"].ToString().Contains("#"))
{
string[] lv_temp = dtlist.Rows[0]["hy_sql_fl3"].ToString().Split('#');
for (var i = 0; i < lv_temp.Length; i++)
{
this.ddlflfield3.Items.Insert(i + 1, new ListItem(lv_temp[i], lv_temp[i]));
//默认值
if (lv_temp[i] == ls_threekey)
li_i = i + 1;
}
}
else
{
string hy_sql_fl3 = dtlist.Rows[0]["hy_sql_fl3"].ToString();
if (hy_sql_fl3.Contains("当前用户ID"))
hy_sql_fl3 = hy_sql_fl3.Replace("当前用户ID", "'" + Session["hyuid"].ToString() + "'");
DataTable dt_flxx = Hyoa_global.GetDataTable(hy_sql_fl3);
if (dt_flxx.Rows.Count > 0)
{
for (var i = 0; i < dt_flxx.Rows.Count; i++)
{
this.ddlflfield3.Items.Insert(i + 1, new ListItem(dt_flxx.Rows[i][0].ToString(), dt_flxx.Rows[i][0].ToString()));
//默认值
if (dt_flxx.Rows[i][0].ToString() == ls_threekey)
li_i = i + 1;
}
}
}
ddlflfield3.SelectedIndex = li_i;
}
//通过选择的分类值，自动添加分类的查询值 added by xf 2012-02-11
string ls_sqlfl = "";
if (dtlist.Rows[0]["hy_fieldid_fl1"].ToString() != "")
{
if (ls_key != "")
{
hy_fieldid_fl1.Text = dtlist.Rows[0]["hy_fieldid_fl1"].ToString();
ls_sqlfl += " and hyc_" + hy_fieldid_fl1.Text + "='" + ls_key + "' ";
}
}
else
{
ddlflfield.Visible = false;
}
if (dtlist.Rows[0]["hy_fieldid_fl2"].ToString() != "")
{
if (ls_subkey != "")
{
hy_fieldid_fl2.Text = dtlist.Rows[0]["hy_fieldid_fl2"].ToString();
ls_sqlfl += " and hyc_" + hy_fieldid_fl2.Text + "='" + ls_subkey + "' ";
}
}
else
{
ddlflfield2.Visible = false;
}
if (dtlist.Rows[0]["hy_fieldid_fl3"].ToString() != "")
{
if (ls_threekey != "")
{
hy_fieldid_fl3.Text = dtlist.Rows[0]["hy_fieldid_fl3"].ToString();
ls_sqlfl += " and hyc_" + hy_fieldid_fl3.Text + "='" + ls_threekey + "' ";
}
}
else
{
ddlflfield3.Visible = false;
}
//--根据查询条件得到返回数据集--s
DataTable dt = new DataTable(); //单页数据集
DataTable dt_total = new DataTable(); //数据总条数，返回总条数值
DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc
string cmdStr = "";
if (dttable.Rows[0]["hy_ifdisplayall"].ToString() == "是")
{
string ls_from = "";
ls_from = " hyc_" + this.txttableid.Value + " where 1=1 " + ls_sqlfl + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select top " + PageSize.Text + " * from " + ls_from;
cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr = " select * from ( ";
cmdStr += " select my_table.*, rownum as my_rownum from ";
cmdStr += " ( ";
cmdStr += " select * from hyc_" + this.txttableid.Value + " where 1=1 " + ls_sqlfl + cmdStr_Search + cmdStr_SearchSort;
cmdStr += " ) my_table ";
cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString();
cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString();
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
}
else
{
string ls_from = "";
ls_from = " hyc_" + this.txttableid.Value + " where hy_djrid='" + Session["hyuid"].ToString() + "' " + ls_sqlfl + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select top " + PageSize.Text + " * from " + ls_from;
cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr = " select * from ( ";
cmdStr += " select my_table.*, rownum as my_rownum from ";
cmdStr += " ( ";
cmdStr += " select * from hyc_" + this.txttableid.Value + " where hy_djrid='" + Session["hyuid"].ToString() + "' " + ls_sqlfl + cmdStr_Search + cmdStr_SearchSort;
cmdStr += " ) my_table ";
cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString();
cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString();
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
}
//--根据查询条件得到返回数据集--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;
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 = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
//输出主表所有字段,start
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//输出主表所有字段,end
//////开始得到列的值
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);
if (i % System.Int32.Parse(PageSize.Text) == 0)
this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" title=\"点击可排序\" onclick=\"fun_sort('" + lvcolnameid[m] + "');\">" + lvcolname[m] + "</a></p></td>";
//根据字段英文名，得到数据库中对应的字段
string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString();
//根据数据库中对应的字段，得到输出字段的值start (日期型根据格式进行了转换)
string lsgetputfiled = "";
if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
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() != "")
{
//是否包含小数点，包含的话，取小数点后两位
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();
}
}
else
{
lsgetputfiled = "0";
}
//lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
else
{
lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
}
if (lsgetputfiled == "")
lsgetputfiled = " ";
//根据得到的SQL字段，得到输出字段的值end
if (dtgetsqlfield.Rows[0]["hy_ifdbsybt"].ToString() == "是")
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\"><a href=\"#\" onclick=\"var ss='main.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.location=ss;\">" + lsgetputfiled + "</a></td>";
}
else
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>";
}
}
dr["displaycol"] = ls_col; //将新值赋给相应的列 add
ls_col = "";
tempTable.Rows.Add(dr);
}
int TotalRecord = int.Parse(dt_total.Rows[0][0].ToString());
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();
}
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_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//如果非流程(授权用户可新建信息、可删除所有信息)
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 = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
}
}
//如果非流程(每个人管理自己的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1")
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
//如果非流程(每个人管理自己的信息、授权用户可管理所有信息)
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 = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
}
//如果非流程(授权用户可新建、只能删自己新建的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "3")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_sq.Visible = true;
//this.copycontrol.Visible = true;
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
if (ls_searchtext.Contains(","))
{
string[] lv_searchfieldSplit = ls_searchtext.Split(',');
for (int n = 0; n < lv_searchfieldSplit.Length; n++)
{
if (n == 0)
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + lv_searchfieldSplit[n] + "%' ";
}
else
{
cmdStr_Search += " or hyc_" + ls_fieldid + " like '%" + lv_searchfieldSplit[n] + "%' ";
}
}
}
else
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
//---查询条件---结束
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (this.txtfieldid.Value != "" && this.txtfieldsort.Value != "")
{
cmdStr_SearchSort = " order by hyc_" + this.txtfieldid.Value + " " + this.txtfieldsort.Value + " ";
}
if (cmdStr_SearchSort == "")
{
//没有配置，则默认按登记日期
cmdStr_SearchSort = " order by hy_djsj desc ";
}
//---排序---结束
//--根据查询条件得到返回数据集--s
DataTable dt = new DataTable(); //单页数据集
DataTable dt_total = new DataTable(); //数据总条数，返回总条数值
DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc
string cmdStr = "";
if (dttable.Rows[0]["hy_ifdisplayall"].ToString() == "是")
{
string ls_from = "";
ls_from = " hyc_" + this.txttableid.Value + " where 1=1 " + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select top " + PageSize.Text + " * from " + ls_from;
cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr = " select * from ( ";
cmdStr += " select my_table.*, rownum as my_rownum from ";
cmdStr += " ( ";
cmdStr += " select * from hyc_" + this.txttableid.Value + " where 1=1 " + cmdStr_Search + cmdStr_SearchSort;
cmdStr += " ) my_table ";
cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString();
cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString();
}
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
}
else
{
string ls_from = " hyc_" + this.txttableid.Value + " where 1=1 ";
# region 客户管理、商机管理
string ls_mids4 = ",Mudelkhda,Mudelsjgl,";
if (ls_mids4.IndexOf("," + this.txtmudelid.Value + ",") >= 0)
{
//if (this.txtmudelid.Value == "Mudelkhda")
//{
this.newcontrol.Visible = false;
this.delcontrol_my.Visible = false;
if (Hyoa_global.isHaveRole("Rolekhgl001", this.Session["hyuid"].ToString()))
{
//查看所有
}
else if (Hyoa_global.isHaveRole("Rolekhgl002", this.Session["hyuid"].ToString()))
{
//查看本部
if (this.Session["hyuid"].ToString() == "008")
{
//业务一部 酒店、综合
ls_from += " and SUBSTRING(hy_djrbmid, 0, 4)='005' ";
}
if (this.Session["hyuid"].ToString() == "009")
{
//业务二部 金融、政府
ls_from += " and SUBSTRING(hy_djrbmid, 0, 4)='006' ";
}
}
//else if (Hyoa_global.isHaveRole("Rolekhgl003", this.Session["hyuid"].ToString()))
//{
// //查看本组
// ls_from += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'";
//}
else
{
////自己看自己
//ls_from += " and hy_djrid='" + Session["hyuid"].ToString() + "' ";
//同组可以查看
ls_from += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'";
}
}
# endregion
# region 合同管理
string ls_mids = ",Mudelsyyhfwxy,Mudeljdhazfwht,MudelVODfwxy,Mudelffpdfwht,MudelDVBazfwdght,Mudeljwdsjsxy,Mudeljwdscsxy,Mudelkdjrht,Mudelsjcsfwht,Mudelsjgdcsfwht,Mudelsjtxyyhzxy,Mudelzdyht,Mudelqtht,Mudelgxhzhht,";
if (ls_mids.IndexOf("," + this.txtmudelid.Value + ",") >= 0)
{
if (Hyoa_global.isHaveRole("Rolehtgl001", this.Session["hyuid"].ToString()))
{
//查看所有
}
else if (Hyoa_global.isHaveRole("Rolehtgl002", this.Session["hyuid"].ToString()))
{
//查看本部
if (this.Session["hyuid"].ToString() == "008")
{
//业务一部 酒店、综合
ls_from += " and SUBSTRING(hy_djrbmid, 0, 4)='005' ";
}
if (this.Session["hyuid"].ToString() == "009")
{
//业务二部 金融、政府
ls_from += " and SUBSTRING(hy_djrbmid, 0, 4)='006' ";
}
}
//else if (Hyoa_global.isHaveRole("Rolehtgl003", this.Session["hyuid"].ToString()))
//{
// //查看本组
// ls_from += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'";
//}
else
{
//同组可以查看
ls_from += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'";
}
}
# endregion
# region 数据管理--指标管理
if (this.txtmudelid.Value == "Mudelzbsrwh")
{
if (Hyoa_global.isHaveRole("Rolesjglzbgl001", this.Session["hyuid"].ToString()))
{
//查看所有
}
else if (Hyoa_global.isHaveRole("Rolesjglzbgl002", this.Session["hyuid"].ToString()))
{
//查看本部
if (this.Session["hyuid"].ToString() == "008")
{
//业务一部 酒店、综合
ls_from += " and SUBSTRING(hyc_szzid2, 0, 4)='005' ";
}
if (this.Session["hyuid"].ToString() == "009")
{
//业务二部 金融、政府
ls_from += " and SUBSTRING(hyc_szzid2, 0, 4)='006' ";
}
}
//else if (Hyoa_global.isHaveRole("Rolesjglzbgl003", this.Session["hyuid"].ToString()))
//{
// //查看本组
// ls_from += " and hyc_szzid2='" + Session["hydeptid"].ToString() + "'";
//}
else
{
// //自己看自己
// ls_from += " and hyc_khjlid2='" + Session["hyuid"].ToString() + "' ";
ls_from += " and hyc_szzid2='" + Session["hydeptid"].ToString() + "'";
}
}
# endregion
# region 日常管理
string ls_mids2 = ",Mudelxjsq,Mudelshd,Mudelszds,Mudelywsl,Mudelzbgl,";
if (ls_mids2.IndexOf("," + this.txtmudelid.Value + ",") >= 0)
{
if (Hyoa_global.isHaveRole("Rolercgl001", this.Session["hyuid"].ToString()))
{
//查看所有
}
else if (Hyoa_global.isHaveRole("Rolercgl002", this.Session["hyuid"].ToString()))
{
//查看本部
if (this.Session["hyuid"].ToString() == "008")
{
//业务一部 酒店、综合
ls_from += " and SUBSTRING(hy_djrbmid, 0, 4)='005' ";
}
if (this.Session["hyuid"].ToString() == "009")
{
//业务二部 金融、政府
ls_from += " and SUBSTRING(hy_djrbmid, 0, 4)='006' ";
}
}
else if (Hyoa_global.isHaveRole("Rolercgl003", this.Session["hyuid"].ToString()))
{
//查看本组
ls_from += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'";
}
else
{
//自己看自己
ls_from += " and hy_djrid='" + Session["hyuid"].ToString() + "' ";
}
}
# endregion
ls_from += " " + cmdStr_Search;
if (Session["conntype"].ToString() == "SQL")
{
cmdStr = "select top " + PageSize.Text + " * from " + ls_from;
cmdStr += " and DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort;
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr = " select * from ( ";
cmdStr += " select my_table.*, rownum as my_rownum from ";
cmdStr += " ( ";
cmdStr += " select * from hyc_" + this.txttableid.Value + " where hy_djrid='" + Session["hyuid"].ToString() + "' " + cmdStr_Search + cmdStr_SearchSort;
cmdStr += " ) my_table ";
cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString();
cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString();
}
this.strSQL.Value = cmdStr;
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from " + ls_from;
dt_total = Hyoa_global.GetDataTable(cmdStr);
}
//--根据查询条件得到返回数据集--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;
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 = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
//输出主表所有字段,start
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//输出主表所有字段,end
//////开始得到列的值
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);
if (i % System.Int32.Parse(PageSize.Text) == 0)
this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" title=\"点击可排序\" onclick=\"fun_sort('" + lvcolnameid[m] + "');\">" + lvcolname[m] + "</a></p></td>";
//根据字段英文名，得到数据库中对应的字段
string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString();
//根据数据库中对应的字段，得到输出字段的值start (日期型根据格式进行了转换)
string lsgetputfiled = "";
if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
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() != "")
{
//是否包含小数点，包含的话，取小数点后两位
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();
}
}
else
{
lsgetputfiled = "0";
}
//lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
else
{
lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
}
if (lsgetputfiled == "")
lsgetputfiled = " ";
//根据得到的SQL字段，得到输出字段的值end
if (dtgetsqlfield.Rows[0]["hy_ifdbsybt"].ToString() == "是")
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\"><a href=\"#\" onclick=\"var ss='main_flc.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.location=ss;\">" + lsgetputfiled + "</a></td>";
}
else
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>";
}
}
dr["displaycol"] = ls_col; //将新值赋给相应的列 add
ls_col = "";
tempTable.Rows.Add(dr);
}
int TotalRecord = int.Parse(dt_total.Rows[0][0].ToString());
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();
//列表中的一些特殊处理，都放在这个函数内
DataPlay_Tscl();
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//判断是否已存在该字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
Hyoa_flowfield.hy_tableid = this.txttableid.Text;
Hyoa_flowfield.hy_mudelid = this.txtmudelid.Text;
Hyoa_flowfield.hy_flowid = this.txtflowid.Text;
Hyoa_flowfield.hy_fieldid = this.txtfieldid.Text;
Hyoa_flowfield.hy_fieldname = this.txtfieldname.Text;
Hyoa_flowfield.hy_fieldtype = this.ddlfieldtype.SelectedValue;
Hyoa_flowfield.hy_ifreadonly = this.ddlifreadonly.SelectedValue;
Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(this.ddldefaultvaluetype.SelectedValue);
Hyoa_flowfield.hy_defaultvalue = this.txtdefaultvalue.Text;
Hyoa_flowfield.hy_optiontype = System.Int32.Parse(this.ddloptiontype.SelectedValue);
Hyoa_flowfield.hy_options = this.txtoptions.Text;
Hyoa_flowfield.hy_onclick = this.txtonclick.Text;
Hyoa_flowfield.hy_ondblclick = this.txtondblclick.Text;
Hyoa_flowfield.hy_onchange = this.txtonchange.Text;
Hyoa_flowfield.hy_onkeydown = this.txtonkeydown.Text;
Hyoa_flowfield.hy_onkeyup = this.txtonkeyup.Text;
Hyoa_flowfield.hy_onfocus = this.txtonfocus.Text;
Hyoa_flowfield.hy_onblur = this.txtonblur.Text;
Hyoa_flowfield.hy_sqlfield = "";
Hyoa_flowfield.hy_class = this.txtclass.Text;
Hyoa_flowfield.hy_width = this.txtwidth.Text;
Hyoa_flowfield.hy_height = this.txtheight.Text;
Hyoa_flowfield.hy_tdnums = System.Int32.Parse(this.ddltdnums.SelectedValue);
Hyoa_flowfield.hy_config = "";
Hyoa_flowfield.hy_sort = float.Parse(this.txtsort.Text);
Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(this.txtwordlimit.Text);
Hyoa_flowfield.hy_required = this.ddlrequired.SelectedValue;
Hyoa_flowfield.hy_align = this.ddlalign.SelectedValue;
Hyoa_flowfield.hy_ifhiddle = this.ddlifhiddle.SelectedValue;
Hyoa_flowfield.hy_ifdbsybt = this.ddlifdbsybt.SelectedValue;
Hyoa_flowfield.hy_field1 = "";
Hyoa_flowfield.hy_field2 = "";
Hyoa_flowfield.hy_field3 = "";
Hyoa_flowfield.hy_field4 = "";
Hyoa_flowfield.hy_field5 = "";
//新文档时
if (this.txtop.Value == "add")
{
DataTable dt = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Text, this.txtfieldid.Text, this.txttableid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该字段ID在当前表单中已存在，请重新输入！');</script>");
return;
}
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.Insert();
CreateSQLField();
}
else
{
Hyoa_flowfield.ID = this.txtdocid.Value;
Hyoa_flowfield.Update();
EditSQLField();
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
private void DataPlay(int PageNo)
{
//得到当前模块对应的全权用户组
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)
{
if (dt_mudel.Rows[0]["hy_qqroleid"] == null)
{
return;
}
else
{
if (dt_mudel.Rows[0]["hy_qqroleid"] == "")
{
return;
}
else
{
ls_role = dt_mudel.Rows[0]["hy_qqroleid"].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 (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
}
else
{
this.isrole.Value = "0";
Response.Write("<script>alert('您无权访问此页面的数据！');self.close();</script>");
return;
}
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (cmdStr_SearchSort == "")
{
//没有配置，则默认按登记日期
cmdStr_SearchSort = " order by hy_djsj desc ";
}
//---排序---结束
//--根据查询条件得到返回数据集--s
DataTable dt = new DataTable(); //单页数据集
DataTable dt_total = new DataTable(); //数据总条数，返回总条数值
DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc
string cmdStr = "";
cmdStr = "select * from hyc_" + this.txttableid.Value + " " + cmdStr_SearchSort;
dt = Hyoa_global.GetDataTable(cmdStr);
cmdStr = "select count(*) from hyc_" + this.txttableid.Value;
dt_total = Hyoa_global.GetDataTable(cmdStr);
//--根据查询条件得到返回数据集--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;
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 = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
//输出主表所有字段,start
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
//输出主表所有字段,end
//////开始得到列的值
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);
//输出第一行的同时顺便把头部输出
if (i == 0)
{
this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[m] + "</td>";
}
//根据字段英文名，得到数据库中对应的字段
string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString();
//根据数据库中对应的字段，得到输出字段的值start (日期型根据格式进行了转换)
string lsgetputfiled = "";
if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
if (dt.Rows[i][lsgetsqlfield].ToString() != "")
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() != "")
{
//是否包含小数点，包含的话，取小数点后两位
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();
}
}
else
{
lsgetputfiled = "0";
}
//lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
else
{
lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString();
}
}
if (lsgetputfiled == "")
lsgetputfiled = " ";
//根据得到的SQL字段，得到输出字段的值end
if (dtgetsqlfield.Rows[0]["hy_ifdbsybt"].ToString() == "是")
{
ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\"><a href=\"#\" onclick=\"var ss='main.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.location=ss;\">" + lsgetputfiled + "</a></td>";
}
else
{
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);
}
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
