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();
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
txtsavefields.Text = "";
txtsavefields_sx.Text = "";
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
DataTable dt = Hyoa_global.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
UpdateReadFlag(); //打开时添加阅读情况
}
dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
this.lblcurtachenameshow.Text = "流程已结束";
}
//加载页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//非流程表单
this.td_browseflow.Visible = false;
//加载主表单页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");
//----加载评论页面 s add by xf 2011-11-19-----
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig_forpinglun.Rows.Count > 0)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
{
this.tb_nbsp.Visible = true;
this.tb_pltitle.Visible = true;
this.tb_plbody.Visible = true;
this.td_pinglun.Visible = true;
//得到已经评论的内容
HyoaClass.Hyoa_pinglun Hyoa_pinglun = new HyoaClass.Hyoa_pinglun();
DataTable dt_pinglun = Hyoa_pinglun.GetcommentByfatherid(this.txtdocid.Value);
if (dt_pinglun.Rows.Count > 0)
{
//输出评论记录
this.lblbody.Text = "";
for (var i = 0; i < dt_pinglun.Rows.Count; i++)
{
this.lblbody.Text += dt_pinglun.Rows[i]["hy_plbody"].ToString() + "<br> ";
this.lblbody.Text += "（评论人:" + dt_pinglun.Rows[i]["hy_plusername"].ToString() + " 所在部门:" + dt_pinglun.Rows[i]["hy_pldeptname"].ToString();
this.lblbody.Text += " 评论时间:" + dt_pinglun.Rows[i]["hy_pltime"].ToString() + " IP:" + dt_pinglun.Rows[i]["hy_plip"].ToString();
this.lblbody.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
}
}
}
//----加载评论页面 e-----
}
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
}
//这是主页面下面的按钮
if (this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tablelzsq"
|| this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds"
|| this.hy_tableid.Text == "Tableywsl" || (this.hy_tableid.Text == "Tablefybx") || (this.hy_tableid.Text == "Tablezbgl") || (this.hy_tableid.Text == "Tablefkd"))
{
this.td_ywdc.Visible = true;
}
if ((this.hy_tableid.Text == "Tablefpbd"))
{
this.td_ywdc.Visible = true;
}
if ((this.hy_tableid.Text == "TableVODfwxy") || (this.hy_tableid.Text == "Tableffpdfwht")
|| (this.hy_mudelid.Text == "Mudeljdhazfwht" && this.hy_tableid.Text == "Tablejdhazfwht") || (this.hy_mudelid.Text == "Mudelsyyhfwxy" && this.hy_tableid.Text == "Tablesyyhfwxy")
|| (this.hy_mudelid.Text == "MudelDVBazfwdght" && this.hy_tableid.Text == "TableDVBazfwdght") || (this.hy_mudelid.Text == "MudelDVBazfwdght" && this.hy_tableid.Text == "TableDVBazfwdght")
|| (this.hy_mudelid.Text == "Mudeljwdsjsxy" && this.hy_tableid.Text == "Tablejwdsjsxy") || (this.hy_mudelid.Text == "Mudeljwdscsxy" && this.hy_tableid.Text == "Tablejwdscsxy")
|| (this.hy_mudelid.Text == "Mudelkdjrht" && this.hy_tableid.Text == "Tablekdjrht") || (this.hy_mudelid.Text == "Mudelsjcsfwht" && this.hy_tableid.Text == "Tablesjcsfwht")
|| (this.hy_mudelid.Text == "Mudelsjgdcsfwht" && this.hy_tableid.Text == "Tablesjgdcsfwht") || (this.hy_mudelid.Text == "Mudelsjtxyyhzxy" && this.hy_tableid.Text == "Tablesjtxyyhzxy")
|| (this.hy_mudelid.Text == "Mudelzdyht" && this.hy_tableid.Text == "Tablezdyht"))
{
this.td_htdc.Visible = true;
}
if (this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_tableid.Text == "TableVODfwxy" || this.hy_tableid.Text == "Tableffpdfwht" || this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_tableid.Text == "Tablesjtxyyhzxy" || this.hy_tableid.Text == "Tablezdyht" || this.hy_tableid.Text == "Tablegxhzhht" || this.hy_tableid.Text == "Tableqtht" || this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string sql_wc = "";
DataTable dtwc;
sql_wc = "select top 1 * from hyt_blzt where DOCID='" + this.txtdocid.Value + "' and hy_state='未完成'";
dtwc = Hyoa_global.GetDataTable(sql_wc);
if (dtwc.Rows.Count > 0)
{
if (dtwc.Rows[0]["hy_state"].ToString() == "未完成")
{
this.td_wcan.Visible = true; //完成
}
}
}
//部门礼品卡 导出 小潘 2015-5-12
if (this.hy_tableid.Text == "Tablegslpk")
{
this.td_ywdc.Visible = true;
}
}
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();
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
txtsavefields.Text = "";
txtsavefields_sx.Text = "";
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
#region 新文档
if (this.Request.QueryString["op"] == "add")
{
this.td_ydry.Visible = false; //新文档时，“已读人员”按钮隐藏
this.txtiffirsttache.Value = "1"; //新文档时，“是否第一环节”置为1
//文档ID（保存POST到当前页面时，DOCID不重新加载）
if (!this.IsPostBack)
{
this.txtdocid.Value = Hyoa_global.GetRandom();
this.hy_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
if (dt.Rows.Count > 0)
{
//判断当前用户是否有登记权限
//得到第一环节ID
string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
{
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.hy_curclrid.Text = this.Session["hyuid"].ToString();
this.hy_curclrname.Text = this.Session["hyuname"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.txtSystemClRight.Value = "1";
//-------条件流程start-------
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
if (dt_firsttache.Rows.Count > 0)
{
if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
}
//-------条件流程end-------
}
else
{
if (this.txtifpop.Value == "")
{
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');window.location='" + this.txturl.Value + "';</script>");
return;
}
else
{
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');self.close();</script>");
return;
}
}
}
dt.Clear();
this.td_nextstep.Visible = true; //提交
}
}
//加载页面
if (this.hy_tableid.Text == "Tablefpbd")
{
this.td_dc.Visible = true;
}
GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.td_submit.Visible = true; //保存
hywebopen_newdoc(); //新文档OPEN时的特殊处理
}
#endregion
#region 旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
DataTable dt = Hyoa_global.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
if (!this.IsPostBack)
{
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
}
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
this.hy_clrylist.Text = dt.Rows[0]["hy_clrylist"].ToString();
this.hy_cyrylist.Text = dt.Rows[0]["hy_cyrylist"].ToString();
this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
UpdateReadFlag(); //打开时添加阅读情况
}
dt.Clear();
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
this.lblcurtachenameshow.Text = "流程已结束";
//20111216 add start
if (this.hy_mudelid.Text == "Mudelfwgl" || this.hy_mudelid.Text == "Mudelswgl")
{
//有发布权限
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
this.td_fabu.Visible = true; //收发文模块流程结束后显示发布按钮
//收发文流程结束后分发轮阅 20140809 hjadd start
this.td_ffly.Visible = true; //收发文模块流程结束后显示分发按钮
//收发文流程结束后分发轮阅 20140809 hjadd start
}
}
//20111216 add end
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
//判断是否历史处理人
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
}
else
{
//////////////流程未结束///////////////////////
//判断是否为当前处理人
if (("," + this.hy_curclrid.Text + ",").IndexOf(("," + this.Session["hyuid"].ToString() + ",")) >= 0)
{
this.txtSystemClRight.Value = "1";
this.td_submit.Visible = true; //保存
this.td_nextstep.Visible = true; //提交
if (this.hy_curtacheid.Text != "tache0001")
{
this.td_returnsumbit.Visible = true; //退回
}
//-------条件流程start-------
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dt_firsttache.Rows.Count > 0)
{
if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
ConditionFlow(this.hy_flowid.Text, this.hy_curtacheid.Text);
}
//-------条件流程end-------
}
else
{
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemYdRight.Value = "1";
}
//判断是否是上一环节处理人
if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtiflastclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_withdraw.Visible = true; //收回
this.td_press.Visible = true; //催办
}
else
{
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_press.Visible = true; //催办
}
}
}
//判断是否为第一个环节
HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl();
DataTable dt_flowhistoryinfo_cl = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value);
if (dt_flowhistoryinfo_cl.Rows.Count == 1)
{
this.txtiffirsttache.Value = "1"; //旧文档时，如果历史处理环节中只有一条记录，“是否第一环节”置为1
}
dt_flowhistoryinfo_cl.Clear();
//判断是否为最后一个环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
this.txtiflasttache.Value = "1";
}
dtflowwork.Clear();
//////////////流程未结束///////////////////////
}
//如果表单是流程后公开显示，则置为阅读权限
if (this.hy_curtacheid.Text == "**")
{
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString() == "是")
{
this.txtSystemYdRight.Value = "1";
}
}
}
//没有操作权限的用户，如果是全权用户，则置为阅读权限 ADD BY XF 2011-11-17
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
//得到当前模块对应的全权用户组
HyoaClass.Hyoa_mudel Hyoa_mudel_forqqyh = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel_forqqyh = Hyoa_mudel_forqqyh.Getmudel(this.hy_mudelid.Text);
if (dt_mudel_forqqyh.Rows.Count > 0)
{
if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != null)
{
if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != "")
{
string ls_role_forqqyh = dt_mudel_forqqyh.Rows[0]["hy_qqroleid"].ToString();
HyoaClass.Hyoa_global Hyoa_global_forqqyh = new HyoaClass.Hyoa_global();
if (Hyoa_global_forqqyh.isHaveRole(ls_role_forqqyh, this.Session["hyuid"].ToString()))
{
this.txtSystemYdRight.Value = "1"; //阅读权限
}
}
}
}
}
//指定的特殊模块，流转过程中，所有人员可以浏览该文档
hySetYdRight_TS();
//如果是“可修改所有文档的权限人员”，则可以修改所有的，可以把已办文件转在办
if (Hyoa_global.isHaveRole("Role9995", Session["hyuid"].ToString()))
{
this.txtSystemYdRight.Value = "1";
this.td_submit.Visible = true; //保存
if (this.hy_curtacheid.Text == "**")
this.td_ybtozb.Visible = true; //已办转在办
}
//既没有处理权限，又没有阅读权限的情况下
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
if (this.txtifpop.Value == "")
{
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');window.location='" + this.txturl.Value + "';</script>");
return;
}
else
{
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');self.close();</script>");
return;
}
}
//加载页面
if (this.hy_tableid.Text == "Tablefpbd")
{
this.td_dc.Visible = true;
}
GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
//----加载补充意见页面 s add by xf 2013-6-24-----
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forbcyj = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig_forbcyj = Hyoa_tableconfig_forbcyj.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig_forbcyj.Rows.Count > 0)
{
if (dt_tableconfig_forbcyj.Rows[0]["hy_ifcomment"] != null)
{
if (dt_tableconfig_forbcyj.Rows[0]["hy_ifcomment"].ToString() == "是")
{
this.tb_nbsp.Visible = true;
this.tb_bctitle.Visible = true;
this.tb_bcbody.Visible = true;
if (this.txtSystemClRight.Value == "0")
{
this.td_bcyj.Visible = true;
this.tr_bcyj.Visible = true;
}
//得到已经补充意见内容
HyoaClass.Hyoa_bcyj Hyoa_bcyj = new HyoaClass.Hyoa_bcyj();
DataTable dt_bcyj = Hyoa_bcyj.GetdocsByfatherid(this.txtdocid.Value);
if (dt_bcyj.Rows.Count > 0)
{
//输出补充意见记录
this.lblbody_bcyj.Text = "";
for (var i = 0; i < dt_bcyj.Rows.Count; i++)
{
this.lblbody_bcyj.Text += dt_bcyj.Rows[i]["hy_bcbody"].ToString() + "<br> ";
this.lblbody_bcyj.Text += "（补充意见人:" + dt_bcyj.Rows[i]["hy_bcusername"].ToString() + " 所在部门:" + dt_bcyj.Rows[i]["hy_bcdeptname"].ToString();
this.lblbody_bcyj.Text += " 补充时间:" + dt_bcyj.Rows[i]["hy_bctime"].ToString() + " IP:" + dt_bcyj.Rows[i]["hy_bcip"].ToString();
this.lblbody_bcyj.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
}
}
}
//----加载补充意见页面 e-----
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
#endregion
}
}
//加载当前表单执行的onload代码 Written by xf 20110621
public string onloadjs()
{
string ls_mid = "";
if (this.Request.QueryString["mid"] != null)
{
ls_mid = this.Request.QueryString["mid"].ToString();
if (ls_mid.Contains(","))
ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
}
string ls_tableid = "";
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
if (ls_tableid.Contains(","))
ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
}
string ls_return = "";
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt = Hyoa_tableconfig.GetTablesbymudelidandtableid(ls_mid, ls_tableid);
if (dt.Rows.Count > 0)
ls_return = dt.Rows[0]["hy_onload"].ToString();
return ls_return;
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//新文档
if (this.Request.QueryString["op"] == "add")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
this.txtdocid.Value = Hyoa_global.GetRandom();
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
this.hy_djsj.Text = System.DateTime.Now.ToString();
if (this.txtifhaveflow.Value == "是")
{
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
//Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>");
if (dt.Rows.Count > 0)
{
//判断当前用户是否有登记权限
//得到第一环节ID
string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
{
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.hy_curclrid.Text = this.Session["hyuid"].ToString();
this.hy_curclrname.Text = this.Session["hyuname"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.txtSystemClRight.Value = "1";
}
else
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');history.back();</script>");
}
}
dt.Clear();
this.td_nextstep.Visible = true; //提交
}
}
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.rptlist.DataBind();
this.td_submit.Visible = true; //保存
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//如果非流程(授权用户统一管理)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
this.txtSystemClRight.Value = "1";
}
if(this.txtSystemClRight.Value == "1")
this.td_submit.Visible = true; //保存
else
this.td_submit.Visible = false; //保存
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0", "");
this.rptlist.DataBind();
}
hywebopen_newdoc(); //新文档OPEN时的特殊处理
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = flowmain.Getflowmain(this.txtdocid.Value);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
this.hy_content1.Text = dt.Rows[0]["hy_content1"].ToString();
this.hy_content2.Text = dt.Rows[0]["hy_content2"].ToString();
this.hy_content3.Text = dt.Rows[0]["hy_content3"].ToString();
this.hy_content4.Text = dt.Rows[0]["hy_content4"].ToString();
this.hy_content5.Text = dt.Rows[0]["hy_content5"].ToString();
this.hy_content6.Text = dt.Rows[0]["hy_content6"].ToString();
this.hy_content7.Text = dt.Rows[0]["hy_content7"].ToString();
this.hy_content8.Text = dt.Rows[0]["hy_content8"].ToString();
this.hy_content9.Text = dt.Rows[0]["hy_content9"].ToString();
this.hy_content10.Text = dt.Rows[0]["hy_content10"].ToString();
this.hy_content11.Text = dt.Rows[0]["hy_content11"].ToString();
this.hy_content12.Text = dt.Rows[0]["hy_content12"].ToString();
this.hy_content13.Text = dt.Rows[0]["hy_content13"].ToString();
this.hy_content14.Text = dt.Rows[0]["hy_content14"].ToString();
this.hy_content15.Text = dt.Rows[0]["hy_content15"].ToString();
this.hy_field1.Text = dt.Rows[0]["hy_field1"].ToString();
this.hy_field2.Text = dt.Rows[0]["hy_field2"].ToString();
this.hy_field3.Text = dt.Rows[0]["hy_field3"].ToString();
this.hy_field4.Text = dt.Rows[0]["hy_field4"].ToString();
this.hy_field5.Text = dt.Rows[0]["hy_field5"].ToString();
this.hy_field6.Text = dt.Rows[0]["hy_field6"].ToString();
this.hy_field7.Text = dt.Rows[0]["hy_field7"].ToString();
this.hy_field8.Text = dt.Rows[0]["hy_field8"].ToString();
this.hy_field9.Text = dt.Rows[0]["hy_field9"].ToString();
this.hy_field10.Text = dt.Rows[0]["hy_field10"].ToString();
this.hy_field11.Text = dt.Rows[0]["hy_field11"].ToString();
this.hy_field12.Text = dt.Rows[0]["hy_field12"].ToString();
this.hy_field13.Text = dt.Rows[0]["hy_field13"].ToString();
this.hy_field14.Text = dt.Rows[0]["hy_field14"].ToString();
this.hy_field15.Text = dt.Rows[0]["hy_field15"].ToString();
this.hy_field16.Text = dt.Rows[0]["hy_field16"].ToString();
this.hy_field17.Text = dt.Rows[0]["hy_field17"].ToString();
this.hy_field18.Text = dt.Rows[0]["hy_field18"].ToString();
this.hy_field19.Text = dt.Rows[0]["hy_field19"].ToString();
this.hy_field20.Text = dt.Rows[0]["hy_field20"].ToString();
this.hy_field21.Text = dt.Rows[0]["hy_field21"].ToString();
this.hy_field22.Text = dt.Rows[0]["hy_field22"].ToString();
this.hy_field23.Text = dt.Rows[0]["hy_field23"].ToString();
this.hy_field24.Text = dt.Rows[0]["hy_field24"].ToString();
this.hy_field25.Text = dt.Rows[0]["hy_field25"].ToString();
this.hy_field26.Text = dt.Rows[0]["hy_field26"].ToString();
this.hy_field27.Text = dt.Rows[0]["hy_field27"].ToString();
this.hy_field28.Text = dt.Rows[0]["hy_field28"].ToString();
this.hy_field29.Text = dt.Rows[0]["hy_field29"].ToString();
this.hy_field30.Text = dt.Rows[0]["hy_field30"].ToString();
this.hy_field31.Text = dt.Rows[0]["hy_field31"].ToString();
this.hy_field32.Text = dt.Rows[0]["hy_field32"].ToString();
this.hy_field33.Text = dt.Rows[0]["hy_field33"].ToString();
this.hy_field34.Text = dt.Rows[0]["hy_field34"].ToString();
this.hy_field35.Text = dt.Rows[0]["hy_field35"].ToString();
this.hy_field36.Text = dt.Rows[0]["hy_field36"].ToString();
this.hy_field37.Text = dt.Rows[0]["hy_field37"].ToString();
this.hy_field38.Text = dt.Rows[0]["hy_field38"].ToString();
this.hy_field39.Text = dt.Rows[0]["hy_field39"].ToString();
this.hy_field40.Text = dt.Rows[0]["hy_field40"].ToString();
this.hy_field41.Text = dt.Rows[0]["hy_field41"].ToString();
this.hy_field42.Text = dt.Rows[0]["hy_field42"].ToString();
this.hy_field43.Text = dt.Rows[0]["hy_field43"].ToString();
this.hy_field44.Text = dt.Rows[0]["hy_field44"].ToString();
this.hy_field45.Text = dt.Rows[0]["hy_field45"].ToString();
this.hy_field46.Text = dt.Rows[0]["hy_field46"].ToString();
this.hy_field47.Text = dt.Rows[0]["hy_field47"].ToString();
this.hy_field48.Text = dt.Rows[0]["hy_field48"].ToString();
this.hy_field49.Text = dt.Rows[0]["hy_field49"].ToString();
this.hy_field50.Text = dt.Rows[0]["hy_field50"].ToString();
this.hy_field51.Text = dt.Rows[0]["hy_field51"].ToString();
this.hy_field52.Text = dt.Rows[0]["hy_field52"].ToString();
this.hy_field53.Text = dt.Rows[0]["hy_field53"].ToString();
this.hy_field54.Text = dt.Rows[0]["hy_field54"].ToString();
this.hy_field55.Text = dt.Rows[0]["hy_field55"].ToString();
this.hy_field56.Text = dt.Rows[0]["hy_field56"].ToString();
this.hy_field57.Text = dt.Rows[0]["hy_field57"].ToString();
this.hy_field58.Text = dt.Rows[0]["hy_field58"].ToString();
this.hy_field59.Text = dt.Rows[0]["hy_field59"].ToString();
this.hy_field60.Text = dt.Rows[0]["hy_field60"].ToString();
this.hy_field61.Text = dt.Rows[0]["hy_field61"].ToString();
this.hy_field62.Text = dt.Rows[0]["hy_field62"].ToString();
this.hy_field63.Text = dt.Rows[0]["hy_field63"].ToString();
this.hy_field64.Text = dt.Rows[0]["hy_field64"].ToString();
this.hy_field65.Text = dt.Rows[0]["hy_field65"].ToString();
this.hy_field66.Text = dt.Rows[0]["hy_field66"].ToString();
this.hy_field67.Text = dt.Rows[0]["hy_field67"].ToString();
this.hy_field68.Text = dt.Rows[0]["hy_field68"].ToString();
this.hy_field69.Text = dt.Rows[0]["hy_field69"].ToString();
this.hy_field70.Text = dt.Rows[0]["hy_field70"].ToString();
this.hy_field71.Text = dt.Rows[0]["hy_field71"].ToString();
this.hy_field72.Text = dt.Rows[0]["hy_field72"].ToString();
this.hy_field73.Text = dt.Rows[0]["hy_field73"].ToString();
this.hy_field74.Text = dt.Rows[0]["hy_field74"].ToString();
this.hy_field75.Text = dt.Rows[0]["hy_field75"].ToString();
this.hy_field76.Text = dt.Rows[0]["hy_field76"].ToString();
this.hy_field77.Text = dt.Rows[0]["hy_field77"].ToString();
this.hy_field78.Text = dt.Rows[0]["hy_field78"].ToString();
this.hy_field79.Text = dt.Rows[0]["hy_field79"].ToString();
this.hy_field80.Text = dt.Rows[0]["hy_field80"].ToString();
this.hy_field81.Text = dt.Rows[0]["hy_field81"].ToString();
this.hy_field82.Text = dt.Rows[0]["hy_field82"].ToString();
this.hy_field83.Text = dt.Rows[0]["hy_field83"].ToString();
this.hy_field84.Text = dt.Rows[0]["hy_field84"].ToString();
this.hy_field85.Text = dt.Rows[0]["hy_field85"].ToString();
this.hy_field86.Text = dt.Rows[0]["hy_field86"].ToString();
this.hy_field87.Text = dt.Rows[0]["hy_field87"].ToString();
this.hy_field88.Text = dt.Rows[0]["hy_field88"].ToString();
this.hy_field89.Text = dt.Rows[0]["hy_field89"].ToString();
this.hy_field90.Text = dt.Rows[0]["hy_field90"].ToString();
this.hy_field91.Text = dt.Rows[0]["hy_field91"].ToString();
this.hy_field92.Text = dt.Rows[0]["hy_field92"].ToString();
this.hy_field93.Text = dt.Rows[0]["hy_field93"].ToString();
this.hy_field94.Text = dt.Rows[0]["hy_field94"].ToString();
this.hy_field95.Text = dt.Rows[0]["hy_field95"].ToString();
this.hy_field96.Text = dt.Rows[0]["hy_field96"].ToString();
this.hy_field97.Text = dt.Rows[0]["hy_field97"].ToString();
this.hy_field98.Text = dt.Rows[0]["hy_field98"].ToString();
this.hy_field99.Text = dt.Rows[0]["hy_field99"].ToString();
this.hy_field100.Text = dt.Rows[0]["hy_field100"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
}
dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
//////////////流程已结束///////////////////////
this.lblcurtachenameshow.Text = "流程已结束";
UpdateReadFlag(); //打开时置为已读
//////////////流程已结束///////////////////////
}
else
{
//////////////流程未结束///////////////////////
//判断是否为当前处理人
if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0)
{
this.txtSystemClRight.Value = "1";
this.td_submit.Visible = true; //保存
this.td_nextstep.Visible = true; //提交
this.td_returnsumbit.Visible = true; //退回
}
else
{
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemYdRight.Value = "1";
}
//判断是否是上一环节处理人
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtiflastclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_withdraw.Visible = true; //收回
this.td_press.Visible = true; //催办
}
else
{
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_press.Visible = true; //催办
}
}
}
//判断是否为最后一个环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
this.txtiflasttache.Value = "1";
}
dtflowwork.Clear();
//既没有处理权限，又没有阅读权限的情况下
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');history.back();</script>");
}
//////////////流程未结束///////////////////////
}
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.rptlist.DataBind();
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//非流程表单
this.td_nextstep.Visible = false;
this.td_withdraw.Visible = false;
this.td_returnsumbit.Visible = false;
this.td_press.Visible = false;
this.td_browseflow.Visible = false;
////////////判断当前表单是否为只显示个人
//////////HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
//////////DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
//////////if (dt_tableconfig.Rows.Count > 0)
//////////{
////////// //不是流程文档，不显示所有记录
////////// if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "否" && dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString() == "否")
////////// {
////////// //判断是否为当前文档登记人
////////// if(this.hy_djrid.Text==Session["hyuid"].ToString())
////////// this.txtSystemClRight.Value = "1";
////////// }
////////// else
////////// {
////////// if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
////////// this.txtSystemClRight.Value = "1";
////////// }
//////////}
//如果非流程(授权用户统一管理)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
//判断是否为当前文档登记人
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
this.txtSystemClRight.Value = "1";
}
else
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
if (this.txtSystemClRight.Value == "1")
this.td_submit.Visible = true; //保存
else
this.td_submit.Visible = false; //保存
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0","");
this.rptlist.DataBind();
UpdateReadFlag(); //打开时置为已读
}
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
}
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//新文档
if (this.Request.QueryString["op"] == "add")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
this.txtdocid.Value = Hyoa_global.GetRandom();
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
this.hy_djsj.Text = System.DateTime.Now.ToString();
if (this.txtifhaveflow.Value == "是")
{
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
//Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>");
if (dt.Rows.Count > 0)
{
//判断当前用户是否有登记权限
//得到第一环节ID
string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
{
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.hy_curclrid.Text = this.Session["hyuid"].ToString();
this.hy_curclrname.Text = this.Session["hyuname"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.txtSystemClRight.Value = "1";
}
else
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');history.back();</script>");
}
}
dt.Clear();
this.td_nextstep.Visible = true; //提交
}
}
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.rptlist.DataBind();
this.td_submit.Visible = true; //保存
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//如果非流程(授权用户统一管理)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
this.txtSystemClRight.Value = "1";
}
if (this.txtSystemClRight.Value == "1")
this.td_submit.Visible = true; //保存
else
this.td_submit.Visible = false; //保存
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0", "");
this.rptlist.DataBind();
}
hywebopen_newdoc(); //新文档OPEN时的特殊处理
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = flowmain.Getflowmain(this.txtdocid.Value);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
this.hy_content1.Text = dt.Rows[0]["hy_content1"].ToString();
this.hy_content2.Text = dt.Rows[0]["hy_content2"].ToString();
this.hy_content3.Text = dt.Rows[0]["hy_content3"].ToString();
this.hy_content4.Text = dt.Rows[0]["hy_content4"].ToString();
this.hy_content5.Text = dt.Rows[0]["hy_content5"].ToString();
this.hy_content6.Text = dt.Rows[0]["hy_content6"].ToString();
this.hy_content7.Text = dt.Rows[0]["hy_content7"].ToString();
this.hy_content8.Text = dt.Rows[0]["hy_content8"].ToString();
this.hy_content9.Text = dt.Rows[0]["hy_content9"].ToString();
this.hy_content10.Text = dt.Rows[0]["hy_content10"].ToString();
this.hy_content11.Text = dt.Rows[0]["hy_content11"].ToString();
this.hy_content12.Text = dt.Rows[0]["hy_content12"].ToString();
this.hy_content13.Text = dt.Rows[0]["hy_content13"].ToString();
this.hy_content14.Text = dt.Rows[0]["hy_content14"].ToString();
this.hy_content15.Text = dt.Rows[0]["hy_content15"].ToString();
this.hy_field1.Text = dt.Rows[0]["hy_field1"].ToString();
this.hy_field2.Text = dt.Rows[0]["hy_field2"].ToString();
this.hy_field3.Text = dt.Rows[0]["hy_field3"].ToString();
this.hy_field4.Text = dt.Rows[0]["hy_field4"].ToString();
this.hy_field5.Text = dt.Rows[0]["hy_field5"].ToString();
this.hy_field6.Text = dt.Rows[0]["hy_field6"].ToString();
this.hy_field7.Text = dt.Rows[0]["hy_field7"].ToString();
this.hy_field8.Text = dt.Rows[0]["hy_field8"].ToString();
this.hy_field9.Text = dt.Rows[0]["hy_field9"].ToString();
this.hy_field10.Text = dt.Rows[0]["hy_field10"].ToString();
this.hy_field11.Text = dt.Rows[0]["hy_field11"].ToString();
this.hy_field12.Text = dt.Rows[0]["hy_field12"].ToString();
this.hy_field13.Text = dt.Rows[0]["hy_field13"].ToString();
this.hy_field14.Text = dt.Rows[0]["hy_field14"].ToString();
this.hy_field15.Text = dt.Rows[0]["hy_field15"].ToString();
this.hy_field16.Text = dt.Rows[0]["hy_field16"].ToString();
this.hy_field17.Text = dt.Rows[0]["hy_field17"].ToString();
this.hy_field18.Text = dt.Rows[0]["hy_field18"].ToString();
this.hy_field19.Text = dt.Rows[0]["hy_field19"].ToString();
this.hy_field20.Text = dt.Rows[0]["hy_field20"].ToString();
this.hy_field21.Text = dt.Rows[0]["hy_field21"].ToString();
this.hy_field22.Text = dt.Rows[0]["hy_field22"].ToString();
this.hy_field23.Text = dt.Rows[0]["hy_field23"].ToString();
this.hy_field24.Text = dt.Rows[0]["hy_field24"].ToString();
this.hy_field25.Text = dt.Rows[0]["hy_field25"].ToString();
this.hy_field26.Text = dt.Rows[0]["hy_field26"].ToString();
this.hy_field27.Text = dt.Rows[0]["hy_field27"].ToString();
this.hy_field28.Text = dt.Rows[0]["hy_field28"].ToString();
this.hy_field29.Text = dt.Rows[0]["hy_field29"].ToString();
this.hy_field30.Text = dt.Rows[0]["hy_field30"].ToString();
this.hy_field31.Text = dt.Rows[0]["hy_field31"].ToString();
this.hy_field32.Text = dt.Rows[0]["hy_field32"].ToString();
this.hy_field33.Text = dt.Rows[0]["hy_field33"].ToString();
this.hy_field34.Text = dt.Rows[0]["hy_field34"].ToString();
this.hy_field35.Text = dt.Rows[0]["hy_field35"].ToString();
this.hy_field36.Text = dt.Rows[0]["hy_field36"].ToString();
this.hy_field37.Text = dt.Rows[0]["hy_field37"].ToString();
this.hy_field38.Text = dt.Rows[0]["hy_field38"].ToString();
this.hy_field39.Text = dt.Rows[0]["hy_field39"].ToString();
this.hy_field40.Text = dt.Rows[0]["hy_field40"].ToString();
this.hy_field41.Text = dt.Rows[0]["hy_field41"].ToString();
this.hy_field42.Text = dt.Rows[0]["hy_field42"].ToString();
this.hy_field43.Text = dt.Rows[0]["hy_field43"].ToString();
this.hy_field44.Text = dt.Rows[0]["hy_field44"].ToString();
this.hy_field45.Text = dt.Rows[0]["hy_field45"].ToString();
this.hy_field46.Text = dt.Rows[0]["hy_field46"].ToString();
this.hy_field47.Text = dt.Rows[0]["hy_field47"].ToString();
this.hy_field48.Text = dt.Rows[0]["hy_field48"].ToString();
this.hy_field49.Text = dt.Rows[0]["hy_field49"].ToString();
this.hy_field50.Text = dt.Rows[0]["hy_field50"].ToString();
this.hy_field51.Text = dt.Rows[0]["hy_field51"].ToString();
this.hy_field52.Text = dt.Rows[0]["hy_field52"].ToString();
this.hy_field53.Text = dt.Rows[0]["hy_field53"].ToString();
this.hy_field54.Text = dt.Rows[0]["hy_field54"].ToString();
this.hy_field55.Text = dt.Rows[0]["hy_field55"].ToString();
this.hy_field56.Text = dt.Rows[0]["hy_field56"].ToString();
this.hy_field57.Text = dt.Rows[0]["hy_field57"].ToString();
this.hy_field58.Text = dt.Rows[0]["hy_field58"].ToString();
this.hy_field59.Text = dt.Rows[0]["hy_field59"].ToString();
this.hy_field60.Text = dt.Rows[0]["hy_field60"].ToString();
this.hy_field61.Text = dt.Rows[0]["hy_field61"].ToString();
this.hy_field62.Text = dt.Rows[0]["hy_field62"].ToString();
this.hy_field63.Text = dt.Rows[0]["hy_field63"].ToString();
this.hy_field64.Text = dt.Rows[0]["hy_field64"].ToString();
this.hy_field65.Text = dt.Rows[0]["hy_field65"].ToString();
this.hy_field66.Text = dt.Rows[0]["hy_field66"].ToString();
this.hy_field67.Text = dt.Rows[0]["hy_field67"].ToString();
this.hy_field68.Text = dt.Rows[0]["hy_field68"].ToString();
this.hy_field69.Text = dt.Rows[0]["hy_field69"].ToString();
this.hy_field70.Text = dt.Rows[0]["hy_field70"].ToString();
this.hy_field71.Text = dt.Rows[0]["hy_field71"].ToString();
this.hy_field72.Text = dt.Rows[0]["hy_field72"].ToString();
this.hy_field73.Text = dt.Rows[0]["hy_field73"].ToString();
this.hy_field74.Text = dt.Rows[0]["hy_field74"].ToString();
this.hy_field75.Text = dt.Rows[0]["hy_field75"].ToString();
this.hy_field76.Text = dt.Rows[0]["hy_field76"].ToString();
this.hy_field77.Text = dt.Rows[0]["hy_field77"].ToString();
this.hy_field78.Text = dt.Rows[0]["hy_field78"].ToString();
this.hy_field79.Text = dt.Rows[0]["hy_field79"].ToString();
this.hy_field80.Text = dt.Rows[0]["hy_field80"].ToString();
this.hy_field81.Text = dt.Rows[0]["hy_field81"].ToString();
this.hy_field82.Text = dt.Rows[0]["hy_field82"].ToString();
this.hy_field83.Text = dt.Rows[0]["hy_field83"].ToString();
this.hy_field84.Text = dt.Rows[0]["hy_field84"].ToString();
this.hy_field85.Text = dt.Rows[0]["hy_field85"].ToString();
this.hy_field86.Text = dt.Rows[0]["hy_field86"].ToString();
this.hy_field87.Text = dt.Rows[0]["hy_field87"].ToString();
this.hy_field88.Text = dt.Rows[0]["hy_field88"].ToString();
this.hy_field89.Text = dt.Rows[0]["hy_field89"].ToString();
this.hy_field90.Text = dt.Rows[0]["hy_field90"].ToString();
this.hy_field91.Text = dt.Rows[0]["hy_field91"].ToString();
this.hy_field92.Text = dt.Rows[0]["hy_field92"].ToString();
this.hy_field93.Text = dt.Rows[0]["hy_field93"].ToString();
this.hy_field94.Text = dt.Rows[0]["hy_field94"].ToString();
this.hy_field95.Text = dt.Rows[0]["hy_field95"].ToString();
this.hy_field96.Text = dt.Rows[0]["hy_field96"].ToString();
this.hy_field97.Text = dt.Rows[0]["hy_field97"].ToString();
this.hy_field98.Text = dt.Rows[0]["hy_field98"].ToString();
this.hy_field99.Text = dt.Rows[0]["hy_field99"].ToString();
this.hy_field100.Text = dt.Rows[0]["hy_field100"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
//信息管理市局录用记录 特殊显示取消按钮用于删除复制的这条数据
if (this.hy_mudelid.Text == "xxgl" && this.hy_tableid.Text == "f1265875-5494-465f-ac33-6fa43d208c8f" && this.hy_field100.Text == "1")
{
//this.td_qx.Visible = true;
this.td_return.Visible = false;
}
HyoaClass.DAO DAO = new HyoaClass.DAO();
string sql_SelectCount = "select count(*) as num from hyp_flowhistoryinfo_cl where docid='" + this.txtdocid.Value + "'";
DataTable dt_Count = DAO.GetDataTable(sql_SelectCount);
if (dt_Count.Rows.Count > 0)
{
this.txtclts.Value = dt_Count.Rows[0]["num"].ToString();
}
}
dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
//////////////流程已结束///////////////////////
this.lblcurtachenameshow.Text = "流程已结束";
UpdateReadFlag(); //打开时置为已读
//////////////流程已结束///////////////////////
}
else
{
//////////////流程未结束///////////////////////
//判断是否为当前处理人
if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0)
{
this.txtSystemClRight.Value = "1";
this.td_submit.Visible = true; //保存
this.td_nextstep.Visible = true; //提交
this.td_returnsumbit.Visible = true; //退回
}
else
{
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemYdRight.Value = "1";
}
//判断是否是上一环节处理人
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtiflastclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_withdraw.Visible = true; //收回
this.td_press.Visible = true; //催办
}
else
{
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_press.Visible = true; //催办
}
}
}
//判断是否为最后一个环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
this.txtiflasttache.Value = "1";
}
dtflowwork.Clear();
//既没有处理权限，又没有阅读权限的情况下
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');history.back();</script>");
}
//////////////流程未结束///////////////////////
}
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.rptlist.DataBind();
////////补充意见s 只要是旧文档，且有流程的模块就能填写轮阅意见
this.tb_bctitle.Visible = true;
this.tb_bcbody.Visible = true;
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
this.tr_bcyj.Visible = false;
}
else
{
this.tr_bcyj.Visible = true;
}
//得到已经补充意见内容
HyoaClass.Hyoa_bcyj Hyoa_bcyj = new HyoaClass.Hyoa_bcyj();
DataTable dt_bcyj = Hyoa_bcyj.GetdocsByfatherid(this.txtdocid.Value);
if (dt_bcyj.Rows.Count > 0)
{
//输出补充意见记录
this.lblbody_bcyj.Text = "";
for (var i = 0; i < dt_bcyj.Rows.Count; i++)
{
this.lblbody_bcyj.Text += dt_bcyj.Rows[i]["hy_bcbody"].ToString() + "<br> ";
this.lblbody_bcyj.Text += "（轮阅人:" + dt_bcyj.Rows[i]["hy_bcusername"].ToString() + " 所在部门:" + dt_bcyj.Rows[i]["hy_bcdeptname"].ToString();
this.lblbody_bcyj.Text += " 填写时间:" + dt_bcyj.Rows[i]["hy_bctime"].ToString();
//+ " IP:" + dt_bcyj.Rows[i]["hy_bcip"].ToString();
this.lblbody_bcyj.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
////////补充意见e
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//非流程表单
this.td_nextstep.Visible = false;
this.td_withdraw.Visible = false;
this.td_returnsumbit.Visible = false;
this.td_press.Visible = false;
this.td_browseflow.Visible = false;
////////////判断当前表单是否为只显示个人
//////////HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
//////////DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
//////////if (dt_tableconfig.Rows.Count > 0)
//////////{
////////// //不是流程文档，不显示所有记录
////////// if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "否" && dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString() == "否")
////////// {
////////// //判断是否为当前文档登记人
////////// if(this.hy_djrid.Text==Session["hyuid"].ToString())
////////// this.txtSystemClRight.Value = "1";
////////// }
////////// else
////////// {
////////// if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
////////// this.txtSystemClRight.Value = "1";
////////// }
//////////}
//如果非流程(授权用户统一管理)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
//判断是否为当前文档登记人
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
this.txtSystemClRight.Value = "1";
}
else
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
if (this.txtSystemClRight.Value == "1")
{
//只有登记人和管理员可以修改，有保存按钮
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (this.hy_djrid.Text == Session["hyuid"].ToString() || Hyoa_global.isHaveRole("Role9999", Session["hyuid"].ToString()))
{
this.td_submit.Visible = true; //保存
//信息管理市局录用记录
if (this.hy_mudelid.Text == "xxgl" && this.hy_tableid.Text == "f1265875-5494-465f-ac33-6fa43d208c8f")
{
this.td_sc.Visible = false; //删除
}
}
else
{
this.td_submit.Visible = false; //保存
}
}
else
{
this.td_submit.Visible = false; //保存
}
//加载页面
this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0", "");
this.rptlist.DataBind();
UpdateReadFlag(); //打开时置为已读
}
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
}
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
txtsavefields.Text = "";
txtsavefields_sx.Text = "";
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
#region 新文档
if (this.Request.QueryString["op"] == "add")
{
this.td_ydry.Visible = false; //新文档时，“已读人员”按钮隐藏
//文档ID（保存POST到当前页面时，DOCID不重新加载）
if (!this.IsPostBack)
{
this.txtdocid.Value = Hyoa_global.GetRandom();
this.hy_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//如果非流程(授权用户可新建信息、可删除所有信息)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
this.txtSystemClRight.Value = "1";
}
//如果非流程(授权用户可新建、只能删自己新建的信息)
if (this.txttablerole.Value == "3")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
if (this.txtSystemClRight.Value == "1")
{
this.td_submit.Visible = true; //保存
this.td_continue.Visible = true; //保存并继续新建
this.td_xyb.Visible = false; //下一步
if (this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_tableid.Text == "TableVODfwxy" || this.hy_tableid.Text == "Tableffpdfwht" || this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_tableid.Text == "Tablesjtxyyhzxy" || this.hy_tableid.Text == "Tablezdyht" || this.hy_tableid.Text == "Tablegxhzhht" || this.hy_tableid.Text == "Tableqtht" || this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds")
{
this.td_continue.Visible = false;
this.td_xyb.Visible = true;
}
if (this.hy_tableid.Text == "Tablefpbd")
{
this.btn_consubmit.Value = "付 款";
this.td_consubmit.Visible = true;//确认td_qxsubmit
}
}
else
{
this.td_submit.Visible = false; //保存
this.td_xyb.Visible = false; //下一步
this.td_continue.Visible = false; //保存并继续新建
}
//加载页面
GetMainTableHtml("0", this.txtSystemClRight.Value, "0", "");
hywebopen_newdoc(); //新文档OPEN时的特殊处理
}
#endregion
#region 旧文档
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
DataTable dt = Hyoa_global.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
if (!this.IsPostBack)
{
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
}
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
this.hy_clrylist.Text = dt.Rows[0]["hy_clrylist"].ToString();
this.hy_cyrylist.Text = dt.Rows[0]["hy_cyrylist"].ToString();
this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
// this.txt_slbh.Value=dt.Rows[0]["hyc_slbh"].ToString();
UpdateReadFlag(); //打开时添加阅读情况
}
dt.Clear();
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//如果非流程(授权用户统一管理)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
//判断是否为当前文档登记人
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
this.txtSystemClRight.Value = "1";
}
else
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
//如果非流程(授权用户可新建、只能删自己新建的信息)
if (this.txttablerole.Value == "3")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
if (this.txtSystemClRight.Value == "1")
{
this.td_submit.Visible = true; //保存
this.td_continue.Visible = false; //保存并继续新建
this.td_xyb.Visible = false; //下一步
if (this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_tableid.Text == "TableVODfwxy" || this.hy_tableid.Text == "Tableffpdfwht" || this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_tableid.Text == "Tablesjtxyyhzxy" || this.hy_tableid.Text == "Tablezdyht" || this.hy_tableid.Text == "Tablegxhzhht" || this.hy_tableid.Text == "Tableqtht" || this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds")
{
string sql_wc = "";
DataTable dtwc;
sql_wc = "select * from hyt_blzt where DOCID='" + this.txtdocid.Value + "' and hy_state='未完成'";
dtwc = Hyoa_global.GetDataTable(sql_wc);
if (dtwc.Rows.Count > 0)
{
if (dtwc.Rows[0]["hy_state"].ToString() == "未完成")
{
this.td_wcan.Visible = true; //完成
}
}
this.td_continue.Visible = false;
this.td_xyb.Visible = true;
}
if (this.hy_ifconfirm.Text != "1" && this.hy_tableid.Text == "Tablefpbd")
{
this.btn_consubmit.Value = "付款";
this.td_consubmit.Visible = true; //确认
}
}
else
{
this.td_submit.Visible = false; //保存
this.td_wcan.Visible = false; //完成
this.td_xyb.Visible = false; //下一步
this.td_continue.Visible = false; //保存并继续新建
}
//如果是超级管理员把取消按钮显示出来。用于用户确认后还要修改
//if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
//{
// this.td_qxsubmit.Visible = true; //取消按钮
//}
//加载主表单页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");
//----加载评论页面 s add by xf 2011-11-19-----
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig_forpinglun.Rows.Count > 0)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
{
this.tb_nbsp.Visible = true;
this.tb_pltitle.Visible = true;
this.tb_plbody.Visible = true;
this.td_pinglun.Visible = true;
//得到已经评论的内容
HyoaClass.Hyoa_pinglun Hyoa_pinglun = new HyoaClass.Hyoa_pinglun();
DataTable dt_pinglun = Hyoa_pinglun.GetcommentByfatherid(this.txtdocid.Value);
if (dt_pinglun.Rows.Count > 0)
{
//输出评论记录
this.lblbody.Text = "";
for (var i = 0; i < dt_pinglun.Rows.Count; i++)
{
this.lblbody.Text += dt_pinglun.Rows[i]["hy_plbody"].ToString() + "<br> ";
this.lblbody.Text += "（评论人:" + dt_pinglun.Rows[i]["hy_plusername"].ToString() + " 所在部门:" + dt_pinglun.Rows[i]["hy_pldeptname"].ToString();
this.lblbody.Text += " 评论时间:" + dt_pinglun.Rows[i]["hy_pltime"].ToString() + " IP:" + dt_pinglun.Rows[i]["hy_plip"].ToString();
this.lblbody.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
}
}
}
//----加载评论页面 e-----
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
#endregion
}
// 部门礼品卡 显示导出按键 小潘 2015-12
if (this.hy_tableid.Text == "Tablelpksqd")
{
//if (this.hy_curtacheid.Text == "tache0001" || this.hy_curtacheid.Text == "**")
//{
this.td_dc.Visible = true;
//}
}
}
//需要导出的内容
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();
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//新文档
if (this.Request.QueryString["op"] == "add")
{
//HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
this.txtdocid.Value = Hyoa_global.GetRandom();
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
this.hy_djsj.Text = System.DateTime.Now.ToString();
this.txthyc_nf.Text = System.DateTime.Now.ToString("yyyy");
this.txthyc_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
this.txthyc_lxks.Text = this.Session["hydeptname"].ToString();
this.txthyc_lxr.Text = this.Session["hyuname"].ToString();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
//Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>");
if (dt.Rows.Count > 0)
{
//判断当前用户是否有登记权限
//得到第一环节ID
string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
{
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.hy_curclrid.Text = this.Session["hyuid"].ToString();
this.hy_curclrname.Text = this.Session["hyuname"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.txtSystemClRight.Value = "1";
this.txtSystemYdRight.Value = "0";
}
else
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');</script>");
}
}
dt.Clear();
this.td_nextstep.Visible = true; //提交
this.td_submit.Visible = true; //保存
}
}
//加载页面
WebOpen(this.hy_mudelid.Text, this.hy_tableid.Text, this.hy_flowid.Text, this.hy_curtacheid.Text, this.txtSystemClRight.Value, this.txtSystemYdRight.Value, "0");
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
//HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain();
//DataTable dt = flowmain.Getflowmain(this.txtdocid.Value);
//HyoaClass.Hyoa_global Hyoa_global=new HyoaClass.Hyoa_global ();
string lssql = "select * from hyc_Tabledcxt where DOCID='" + this.txtdocid.Value + "'";
DataTable dt = Hyoa_global.GetDataTable(lssql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
string lssqlfield = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')";
DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield); //得到所有配置域
for (int ii = 0; ii < dtfield.Rows.Count; ii++)
{
if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "文本")
{
TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
txt1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
lbl1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
}
if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "多行文本")
{
TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
txt1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
lbl1.Text = RtfToText2(dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString());
}
if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "日期")
{
TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
if (dtfield.Rows[ii]["hy_defaultvalue"].ToString() == "yyyy-mm-dd")
{
txt1.Text = System.DateTime.Parse(dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString()).ToShortDateString();
lbl1.Text = System.DateTime.Parse(dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString()).ToShortDateString();
}
else
{
txt1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
lbl1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
}
}
if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "对话框列表")
{
DropDownList ddl1 = (DropDownList)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
ddl1.SelectedValue = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
lbl1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
}
//this.FindControl("11111"). = "1";
//this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()).value = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
//this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()).value = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString();
}
//this.txthyc_nf.Text = dt.Rows[0]["hyc_nf"].ToString();
//this.txthyc_bh.Text = dt.Rows[0]["hyc_bh"].ToString();
//this.txthyc_lb.SelectedValue = dt.Rows[0]["hyc_lb"].ToString();
//this.txthyc_hj.SelectedValue = dt.Rows[0]["hyc_hj"].ToString();
//this.txthyc_djsj.Text = dt.Rows[0]["hyc_djsj"].ToString();
//this.txthyc_cbdw.Text = dt.Rows[0]["hyc_cbdw"].ToString();
//this.txthyc_dcsx.Text = dt.Rows[0]["hyc_dcsx"].ToString();
//this.txthyc_blyq.Text = dt.Rows[0]["hyc_blyq"].ToString();
//this.txthyc_lxks.Text = dt.Rows[0]["hyc_lxks"].ToString();
//this.txthyc_lxr.Text = dt.Rows[0]["hyc_lxr"].ToString();
//this.txthyc_lxdh.Text = dt.Rows[0]["hyc_lxdh"].ToString();
//this.txthyc_cbqx.Text = dt.Rows[0]["hyc_cbqx"].ToString();
//this.lblhyc_nf.Text = dt.Rows[0]["hyc_nf"].ToString();
//this.lblhyc_bh.Text = dt.Rows[0]["hyc_bh"].ToString();
//this.lblhyc_lb.SelectedValue = dt.Rows[0]["hyc_lb"].ToString();
//this.lblhyc_hj.SelectedValue = dt.Rows[0]["hyc_hj"].ToString();
//this.lblhyc_djsj.Text = dt.Rows[0]["hyc_djsj"].ToString();
//this.lblhyc_cbdw.Text = dt.Rows[0]["hyc_cbdw"].ToString();
//this.lblhyc_dcsx.Text = dt.Rows[0]["hyc_dcsx"].ToString();
//this.lblhyc_blyq.Text = dt.Rows[0]["hyc_blyq"].ToString();
//this.lblhyc_lxks.Text = dt.Rows[0]["hyc_lxks"].ToString();
//this.lblhyc_lxr.Text = dt.Rows[0]["hyc_lxr"].ToString();
//this.lblhyc_lxdh.Text = dt.Rows[0]["hyc_lxdh"].ToString();
//this.lblhyc_cbqx.Text = dt.Rows[0]["hyc_cbqx"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
}
dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
//////////////流程已结束///////////////////////
this.lblcurtachenameshow.Text = "流程已结束";
//UpdateReadFlag(); //打开时置为已读
//////////////流程已结束///////////////////////
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
//判断是否历史处理人
//判断是否是历史处理人员
//HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
}
else
{
//////////////流程未结束///////////////////////
//判断是否为当前处理人
if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0)
{
this.txtSystemClRight.Value = "1";
this.txtSystemYdRight.Value = "0";
this.td_submit.Visible = true; //保存
this.td_nextstep.Visible = true; //提交
//this.td_returnsumbit.Visible = true; //退回
}
else
{
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
//判断是否是上一环节处理人
//HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtiflastclr.Value = "1";
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
//this.td_withdraw.Visible = true; //收回
//this.td_press.Visible = true; //催办
}
else
{
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
//this.td_press.Visible = true; //催办
}
}
}
//判断是否为最后一个环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
this.txtiflasttache.Value = "1";
}
dtflowwork.Clear();
//////////////流程未结束///////////////////////
}
//既没有处理权限，又没有阅读权限的情况下
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');</script>");
}
//加载页面
WebOpen(this.hy_mudelid.Text, this.hy_tableid.Text, this.hy_flowid.Text, this.hy_curtacheid.Text, this.txtSystemClRight.Value, this.txtSystemYdRight.Value, "1");
}
}
}
//隐藏、显示控制
string lssqlfield5 = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')";
DataTable dtfield5 = Hyoa_global.GetDataTable_BASE(lssqlfield5); //得到所有配置域
string lssqlflowtachefield = "";//流程环节对应的域
DataTable dtflowtachefield;
for (int ii = 0; ii < dtfield5.Rows.Count; ii++)
{
lssqlflowtachefield = "select * from hyt_flowtachefield where hy_flowid = '" + this.hy_flowid.Text + "' and hy_tacheid = '" + this.hy_curtacheid.Text + "' and hy_fieldid='" + dtfield5.Rows[ii]["hy_fieldid"].ToString() + "'";
dtflowtachefield = Hyoa_global.GetDataTable_BASE(lssqlflowtachefield);
if (dtflowtachefield.Rows.Count > 0)
{
this.FindControl("txthyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = true;
this.FindControl("lblhyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = false;
}
else
{
this.FindControl("txthyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = false;
this.FindControl("lblhyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = true;
}
}
}
}
//加载主表单 Written by xf 20110515
private void DataPlay()
{
txtsavefields.Text = "";
txtsavefields_sx.Text = "";
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//新文档
if (this.Request.QueryString["op"] == "add")
{
//文档ID（保存POST到当前页面时，DOCID不重新加载）
if (!this.IsPostBack)
{
this.txtdocid.Value = Hyoa_global.GetRandom();
}
this.hy_djrid.Text = this.Session["hyuid"].ToString();
this.hy_djrname.Text = this.Session["hyuname"].ToString();
this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();
this.hy_djsj.Text = System.DateTime.Now.ToString();
if (this.txtifhaveflow.Value == "是")
{
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
if (dt.Rows.Count > 0)
{
//判断当前用户是否有登记权限
//得到第一环节ID
string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
{
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
this.hy_curclrid.Text = this.Session["hyuid"].ToString();
this.hy_curclrname.Text = this.Session["hyuname"].ToString();
this.lblcurtachenameshow.Text = "当前环节：" + dt.Rows[0]["hy_nexttachename"].ToString();
this.txtSystemClRight.Value = "1";
//-------条件流程start-------
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
if (dt_firsttache.Rows.Count > 0)
{
if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
}
//-------条件流程end-------
}
else
{
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');window.location='" + this.txturl.Value + "';</script>");
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
return;
}
else
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');self.close();</script>");
return;
}
}
}
dt.Clear();
this.td_nextstep.Visible = true; //提交
}
}
//加载页面
GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
this.td_submit.Visible = true; //保存
}
else
{
//this.lblcurtachenameshow.Text = this.lbltablename.Text;
//如果非流程(授权用户可新建信息、可删除所有信息)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
this.txtSystemClRight.Value = "1";
}
//如果非流程(授权用户可新建、只能删自己新建的信息)
if (this.txttablerole.Value == "3")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
if (this.txtSystemClRight.Value == "1")
{
this.td_submit.Visible = true; //保存
}
else
{
this.td_submit.Visible = false; //保存
}
//加载页面
GetMainTableHtml("0", this.txtSystemClRight.Value, "0", "");
}
hywebopen_newdoc(); //新文档OPEN时的特殊处理
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
DataTable dt = Hyoa_global.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
UpdateReadFlag(); //打开时添加阅读情况
}
//dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
this.lblcurtachenameshow.Text = "当前环节：" + dt.Rows[0]["hy_curtachename"].ToString();
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
this.lblcurtachenameshow.Text = "当前环节：" + "流程已结束";
//20111216 add start
if (this.hy_mudelid.Text == "Mudelfwgl" || this.hy_mudelid.Text == "Mudelswgl")
{
//有发布权限
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.td_fabu.Visible = true; //收发文模块流程结束后显示发布按钮
}
//20111216 add end
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
//判断是否历史处理人
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemClRight.Value = "0";
this.txtSystemYdRight.Value = "1";
}
}
else
{
//////////////流程未结束///////////////////////
//判断是否为当前处理人
if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0)
{
this.txtSystemClRight.Value = "1";
this.td_submit.Visible = true; //保存
this.td_nextstep.Visible = true; //提交
this.td_returnsumbit.Visible = true; //退回
//-------条件流程start-------
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dt_firsttache.Rows.Count > 0)
{
if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
ConditionFlow(this.hy_flowid.Text, this.hy_curtacheid.Text);
}
//-------条件流程end-------
}
else
{
//判断是否为传阅人
HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy();
dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
if (dt.Rows.Count > 0)
{
this.txtSystemYdRight.Value = "1";
}
//判断是否是上一环节处理人
if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtiflastclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_withdraw.Visible = true; //收回
this.td_press.Visible = true; //催办
}
else
{
//判断是否是历史处理人员
if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString()))
{
this.txtifhistoryclr.Value = "1";
this.txtSystemYdRight.Value = "1";
this.td_press.Visible = true; //催办
}
}
}
//判断是否为最后一个环节
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text);
if (dtflowwork.Rows.Count > 0)
{
if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**")
this.txtiflasttache.Value = "1";
}
dtflowwork.Clear();
//////////////流程未结束///////////////////////
}
//如果表单是流程后公开显示，则置为阅读权限
if (this.hy_curtacheid.Text == "**")
{
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text);
if (dt_tableconfig.Rows.Count > 0)
{
if (dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString() == "是")
{
this.txtSystemYdRight.Value = "1";
}
}
}
//没有操作权限的用户，如果是全权用户，则置为阅读权限 ADD BY XF 2011-11-17
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
//得到当前模块对应的全权用户组
HyoaClass.Hyoa_mudel Hyoa_mudel_forqqyh = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel_forqqyh = Hyoa_mudel_forqqyh.Getmudel(this.hy_mudelid.Text);
if (dt_mudel_forqqyh.Rows.Count > 0)
{
if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != null)
{
if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != "")
{
string ls_role_forqqyh = dt_mudel_forqqyh.Rows[0]["hy_qqroleid"].ToString();
HyoaClass.Hyoa_global Hyoa_global_forqqyh = new HyoaClass.Hyoa_global();
if (Hyoa_global_forqqyh.isHaveRole(ls_role_forqqyh, this.Session["hyuid"].ToString()))
{
this.txtSystemYdRight.Value = "1"; //阅读权限
}
}
}
}
}
//指定的特殊模块，流转过程中，所有人员可以浏览该文档
hySetYdRight_TS();
//既没有处理权限，又没有阅读权限的情况下
if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0")
{
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');window.location='" + this.txturl.Value + "';</script>");
this.td_submit.Visible = false;
this.td_nextstep.Visible = false;
return;
}
else
{
Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');self.close();</script>");
return;
}
}
//加载页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
}
else
{
//this.lblcurtachenameshow.Text = this.lbltablename.Text;
//非流程表单
this.td_nextstep.Visible = false;
this.td_withdraw.Visible = false;
this.td_returnsumbit.Visible = false;
this.td_press.Visible = false;
this.td_browseflow.Visible = false;
////////////判断当前表单是否为只显示个人
//////////HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
//////////DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
//////////if (dt_tableconfig.Rows.Count > 0)
//////////{
////////// //不是流程文档，不显示所有记录
////////// if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "否" && dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString() == "否")
////////// {
////////// //判断是否为当前文档登记人
////////// if(this.hy_djrid.Text==Session["hyuid"].ToString())
////////// this.txtSystemClRight.Value = "1";
////////// }
////////// else
////////// {
////////// if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
////////// this.txtSystemClRight.Value = "1";
////////// }
//////////}
//如果非流程(授权用户统一管理)
if (this.txttablerole.Value == "0")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人管理自己的信息)
if (this.txttablerole.Value == "1")
{
//判断是否为当前文档登记人
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (this.txttablerole.Value == "2")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
this.txtSystemClRight.Value = "1";
}
else
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
//如果非流程(授权用户可新建、只能删自己新建的信息)
if (this.txttablerole.Value == "3")
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
if (this.txtSystemClRight.Value == "1")
{
this.td_submit.Visible = true; //保存
}
else
{
this.td_submit.Visible = false; //保存
}
//加载主表单页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");
}
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
}
}
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();
}