//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "复制成功！";
try
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
#region 生成权限
DataTable dt = Hyoa_role.Getrole("Role" + this.txtmudelid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该权限编号已存在，请重新填写！');history.back();</script>");
return;
}
else
{
Hyoa_role.hy_roleid = "Role" + this.txtmudelid.Text;
Hyoa_role.hy_rolename = this.txtmudelname.Text;
Hyoa_role.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_role.Insert();
}
#endregion
#region 生成模块
dt = Hyoa_mudel.Getmudel("Mudel" + this.txtmudelid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该模块编号已存在，请重新填写！');history.back();</script>");
return;
}
else
{
Hyoa_mudel.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_mudel.hy_mudelname = this.txtmudelname.Text;
Hyoa_mudel.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_mudel.hy_isenabled = "是";
Hyoa_mudel.hy_roleid = "Role" + this.txtmudelid.Text;
Hyoa_mudel.hy_qqroleid = "Role" + this.txtmudelid.Text;
Hyoa_mudel.Insert();
}
#endregion
#region 生成表单
DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
if (tableconfigdt.Rows.Count > 0)
{
Hyoa_tableconfig.ID = "Table" + this.txtmudelid.Text;
Hyoa_tableconfig.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_tableconfig.hy_name = this.txtmudelname.Text;
Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
Hyoa_tableconfig.hy_sort = float.Parse(this.txtno.Value);
Hyoa_tableconfig.hy_ifflowdoc = tableconfigdt.Rows[0]["hy_ifflowdoc"].ToString();
Hyoa_tableconfig.hy_ifdisplayall = tableconfigdt.Rows[0]["hy_ifdisplayall"].ToString();
Hyoa_tableconfig.hy_ispuballByflowYB = tableconfigdt.Rows[0]["hy_ispuballByflowYB"].ToString();
Hyoa_tableconfig.hy_tablerole = tableconfigdt.Rows[0]["hy_tablerole"].ToString();
Hyoa_tableconfig.hy_ifcomment = tableconfigdt.Rows[0]["hy_ifcomment"].ToString();
Hyoa_tableconfig.hy_colnum = float.Parse(tableconfigdt.Rows[0]["hy_colnum"].ToString());
Hyoa_tableconfig.hy_field1 = tableconfigdt.Rows[0]["hy_field1"].ToString();
Hyoa_tableconfig.hy_field2 = tableconfigdt.Rows[0]["hy_field2"].ToString();
Hyoa_tableconfig.hy_field3 = tableconfigdt.Rows[0]["hy_field3"].ToString();
Hyoa_tableconfig.hy_field4 = tableconfigdt.Rows[0]["hy_field4"].ToString();
Hyoa_tableconfig.hy_field5 = tableconfigdt.Rows[0]["hy_field5"].ToString();
Hyoa_tableconfig.Insert();
}
#endregion
#region 生成表单字段
int i;
DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.ddltableid.SelectedValue);
if (flowfielddt.Rows.Count > 0)
{
for (i = 0; i < flowfielddt.Rows.Count; i++)
{
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.hy_tableid = "Table" + this.txtmudelid.Text;
Hyoa_flowfield.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_flowfield.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowfield.hy_fieldid = flowfielddt.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowfield.hy_fieldname = flowfielddt.Rows[i]["hy_fieldname"].ToString();
Hyoa_flowfield.hy_fieldtype = flowfielddt.Rows[i]["hy_fieldtype"].ToString();
Hyoa_flowfield.hy_ifreadonly = flowfielddt.Rows[i]["hy_ifreadonly"].ToString();
Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(flowfielddt.Rows[i]["hy_defaultvaluetype"].ToString());
Hyoa_flowfield.hy_defaultvalue = flowfielddt.Rows[i]["hy_defaultvalue"].ToString();
Hyoa_flowfield.hy_optiontype = System.Int32.Parse(flowfielddt.Rows[i]["hy_optiontype"].ToString());
Hyoa_flowfield.hy_options = flowfielddt.Rows[i]["hy_options"].ToString();
Hyoa_flowfield.hy_onclick = flowfielddt.Rows[i]["hy_onclick"].ToString();
Hyoa_flowfield.hy_ondblclick = flowfielddt.Rows[i]["hy_ondblclick"].ToString();
Hyoa_flowfield.hy_onchange = flowfielddt.Rows[i]["hy_onchange"].ToString();
Hyoa_flowfield.hy_onkeydown = flowfielddt.Rows[i]["hy_onkeydown"].ToString();
Hyoa_flowfield.hy_onkeyup = flowfielddt.Rows[i]["hy_onkeyup"].ToString();
Hyoa_flowfield.hy_onfocus = flowfielddt.Rows[i]["hy_onfocus"].ToString();
Hyoa_flowfield.hy_onblur = flowfielddt.Rows[i]["hy_onblur"].ToString();
Hyoa_flowfield.hy_sqlfield = flowfielddt.Rows[i]["hy_sqlfield"].ToString();
Hyoa_flowfield.hy_class = flowfielddt.Rows[i]["hy_class"].ToString();
Hyoa_flowfield.hy_width = flowfielddt.Rows[i]["hy_width"].ToString();
Hyoa_flowfield.hy_height = flowfielddt.Rows[i]["hy_height"].ToString();
Hyoa_flowfield.hy_tdnums = System.Int32.Parse(flowfielddt.Rows[i]["hy_tdnums"].ToString());
Hyoa_flowfield.hy_config = flowfielddt.Rows[i]["hy_config"].ToString();
Hyoa_flowfield.hy_sort = float.Parse(flowfielddt.Rows[i]["hy_sort"].ToString());
Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(flowfielddt.Rows[i]["hy_wordlimit"].ToString());
Hyoa_flowfield.hy_required = flowfielddt.Rows[i]["hy_required"].ToString();
Hyoa_flowfield.hy_align = flowfielddt.Rows[i]["hy_align"].ToString();
Hyoa_flowfield.hy_ifhiddle = flowfielddt.Rows[i]["hy_ifhiddle"].ToString();
Hyoa_flowfield.hy_ifdbsybt = flowfielddt.Rows[i]["hy_ifdbsybt"].ToString();
Hyoa_flowfield.hy_field1 = flowfielddt.Rows[i]["hy_field1"].ToString();
Hyoa_flowfield.hy_field2 = flowfielddt.Rows[i]["hy_field2"].ToString();
Hyoa_flowfield.hy_field3 = flowfielddt.Rows[i]["hy_field3"].ToString();
Hyoa_flowfield.hy_field4 = flowfielddt.Rows[i]["hy_field4"].ToString();
Hyoa_flowfield.hy_field5 = flowfielddt.Rows[i]["hy_field5"].ToString();
Hyoa_flowfield.Insert();
}
}
#endregion
#region 生成SQL/ORACLE中的表
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * into hyc_Table" + this.txtmudelid.Text + " from hyc_" + this.ddltableid.SelectedValue + " where 1=0";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "create table hyc_Table" + this.txtmudelid.Text + " as select * from hyc_" + this.ddltableid.SelectedValue + " where 1=2";
}
Hyoa_global.ExcuteSQL(sql);
#endregion
#region 生成列表
DataTable listconfigdt = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(this.ddlmudelid.SelectedValue, this.ddltableid.SelectedValue);
//列表ID
string strListId = Hyoa_global.GetRandom();
if (listconfigdt.Rows.Count > 0)
{
Hyoa_listconfig.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_listconfig.hy_tableid = "Table" + this.txtmudelid.Text;
Hyoa_listconfig.hy_ifflowdoc = listconfigdt.Rows[0]["hy_ifflowdoc"].ToString();
Hyoa_listconfig.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_listconfig.hy_columnshowid = listconfigdt.Rows[0]["hy_columnshowid"].ToString();
Hyoa_listconfig.hy_columnshow = listconfigdt.Rows[0]["hy_columnshow"].ToString();
Hyoa_listconfig.hy_ifsearch = listconfigdt.Rows[0]["hy_ifsearch"].ToString();
Hyoa_listconfig.hy_ifshowsearch = listconfigdt.Rows[0]["hy_ifshowsearch"].ToString();
Hyoa_listconfig.hy_width = listconfigdt.Rows[0]["hy_width"].ToString();
Hyoa_listconfig.hy_listname = this.txtmudelname.Text;
Hyoa_listconfig.hy_sortfield1 = listconfigdt.Rows[0]["hy_sortfield1"].ToString();
Hyoa_listconfig.hy_sorttype1 = listconfigdt.Rows[0]["hy_sorttype1"].ToString();
Hyoa_listconfig.hy_sortfield2 = listconfigdt.Rows[0]["hy_sortfield2"].ToString();
Hyoa_listconfig.hy_sorttype2 = listconfigdt.Rows[0]["hy_sorttype2"].ToString();
Hyoa_listconfig.hy_sortfield3 = listconfigdt.Rows[0]["hy_sortfield3"].ToString();
Hyoa_listconfig.hy_sorttype3 = listconfigdt.Rows[0]["hy_sorttype3"].ToString();
Hyoa_listconfig.hy_fieldid_fl1 = listconfigdt.Rows[0]["hy_fieldid_fl1"].ToString();
Hyoa_listconfig.hy_fieldname_fl1 = listconfigdt.Rows[0]["hy_fieldname_fl1"].ToString();
Hyoa_listconfig.hy_sql_fl1 = listconfigdt.Rows[0]["hy_sql_fl1"].ToString();
Hyoa_listconfig.hy_fieldid_fl2 = listconfigdt.Rows[0]["hy_fieldid_fl2"].ToString();
Hyoa_listconfig.hy_fieldname_fl2 = listconfigdt.Rows[0]["hy_fieldname_fl2"].ToString();
Hyoa_listconfig.hy_sql_fl2 = listconfigdt.Rows[0]["hy_sql_fl2"].ToString();
Hyoa_listconfig.hy_fieldid_fl3 = listconfigdt.Rows[0]["hy_fieldid_fl3"].ToString();
Hyoa_listconfig.hy_fieldname_fl3 = listconfigdt.Rows[0]["hy_fieldname_fl3"].ToString();
Hyoa_listconfig.hy_sql_fl3 = listconfigdt.Rows[0]["hy_sql_fl3"].ToString();
Hyoa_listconfig.ID = strListId;
Hyoa_listconfig.Insert();
}
#endregion
#region 生成列表查询条件
DataTable listsearchdt = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndTableid(this.ddlmudelid.SelectedValue, this.ddltableid.SelectedValue);
for (int m = 0; m < listsearchdt.Rows.Count; m++)
{
Hyoa_listsearchfield.ID = Hyoa_global.GetRandom();
Hyoa_listsearchfield.hy_listid = strListId;
Hyoa_listsearchfield.hy_mudelid = "Mudel" + this.txtmudelid.Text;
Hyoa_listsearchfield.hy_tableid = "Table" + this.txtmudelid.Text;
Hyoa_listsearchfield.hy_field = listsearchdt.Rows[m]["hy_field"].ToString();
Hyoa_listsearchfield.hy_fieldid = listsearchdt.Rows[m]["hy_fieldid"].ToString();
Hyoa_listsearchfield.hy_sort = m + 2;
Hyoa_listsearchfield.Insert();
}
#endregion
#region 生成流程信息
string lssoureceflowid = "";
if (tableconfigdt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
DataTable flowinfordt = Hyoa_flowinfor.Getflowinforbymudelid(this.ddlmudelid.SelectedValue);
if (flowinfordt.Rows.Count > 0)
{
//得到老模块的flowid 后面要用到
lssoureceflowid = flowfielddt.Rows[0]["hy_flowid"].ToString();
//插入流程信息start
Hyoa_flowinfor.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowinfor.hy_flowname = this.txtmudelname.Text;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtno.Value);
Hyoa_flowinfor.hy_mudelid = "Mudel" + this.txtmudelid.Text;
// Hyoa_flowinfor.hy_addbyalluser = flowinfordt.Rows[0]["hy_addbyalluser"].ToString();
Hyoa_flowinfor.Insert();
}
//插入流程信息end
//流程环节
DataTable flowtachedt = Hyoa_flowtache.Getflowtachebyflowid(lssoureceflowid);
if (flowtachedt.Rows.Count > 0)
{
for (i = 0; i < flowtachedt.Rows.Count; i++)
{
Hyoa_flowtache.ID = Hyoa_global.GetRandom();
Hyoa_flowtache.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowtache.hy_tacheid = flowtachedt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtache.hy_tachename = flowtachedt.Rows[i]["hy_tachename"].ToString();
Hyoa_flowtache.hy_sort = System.Int32.Parse(flowtachedt.Rows[i]["hy_sort"].ToString());
Hyoa_flowtache.hy_ifshowcurcomp = flowtachedt.Rows[i]["hy_ifshowcurcomp"].ToString();
Hyoa_flowtache.hy_ifshowcurdept = flowtachedt.Rows[i]["hy_ifshowcurdept"].ToString();
Hyoa_flowtache.hy_XValue = flowtachedt.Rows[i]["hy_XValue"].ToString();
Hyoa_flowtache.hy_YValue = flowtachedt.Rows[i]["hy_YValue"].ToString();
Hyoa_flowtache.hy_rdDoIsSendSms = flowtachedt.Rows[i]["hy_rdDoIsSendSms"].ToString();
Hyoa_flowtache.hy_rdDoIsSendMessage = flowtachedt.Rows[i]["hy_rdDoIsSendMessage"].ToString();
Hyoa_flowtache.hy_rdPassIsSendSms = flowtachedt.Rows[i]["hy_rdPassIsSendSms"].ToString();
Hyoa_flowtache.hy_rdPassIsSendMessage = flowtachedt.Rows[i]["hy_rdPassIsSendMessage"].ToString();
Hyoa_flowtache.hy_enablecondition = flowtachedt.Rows[i]["hy_enablecondition"].ToString();
Hyoa_flowtache.Insert();
}
}
//流程环节对应的域
DataTable flowtachefielddt = Hyoa_flowtachefield.Getflowtachefieldbyflowid(lssoureceflowid);
if (flowtachefielddt.Rows.Count > 0)
{
for (i = 0; i < flowtachefielddt.Rows.Count; i++)
{
Hyoa_flowtachefield.ID = Hyoa_global.GetRandom();
Hyoa_flowtachefield.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowtachefield.hy_tacheid = flowtachefielddt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtachefield.hy_fieldid = flowtachefielddt.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowtachefield.Insert();
}
}
//流程环节对应的用户
DataTable flowtacheuserdt = Hyoa_flowtacheuser.Getflowtacheuserbyflowid(lssoureceflowid);
if (flowtacheuserdt.Rows.Count > 0)
{
for (i = 0; i < flowtacheuserdt.Rows.Count; i++)
{
Hyoa_flowtacheuser.ID = Hyoa_global.GetRandom();
Hyoa_flowtacheuser.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowtacheuser.hy_tacheid = flowtacheuserdt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtacheuser.hy_userid = flowtacheuserdt.Rows[i]["hy_userid"].ToString();
Hyoa_flowtacheuser.Insert();
}
}
//工作流
DataTable flowworkdt = Hyoa_flowwork.Getflowworksbyflowid(lssoureceflowid);
if (flowworkdt.Rows.Count > 0)
{
for (i = 0; i < flowworkdt.Rows.Count; i++)
{
Hyoa_flowwork.ID = Hyoa_global.GetRandom();
Hyoa_flowwork.hy_flowid = "Flow" + this.txtmudelid.Text;
Hyoa_flowwork.hy_curtacheid = flowworkdt.Rows[i]["hy_curtacheid"].ToString();
Hyoa_flowwork.hy_curtachename = flowworkdt.Rows[i]["hy_curtachename"].ToString();
Hyoa_flowwork.hy_nexttacheid = flowworkdt.Rows[i]["hy_nexttacheid"].ToString();
Hyoa_flowwork.hy_nexttachename = flowworkdt.Rows[i]["hy_nexttachename"].ToString();
Hyoa_flowwork.hy_sort = System.Int32.Parse(flowworkdt.Rows[i]["hy_sort"].ToString());
Hyoa_flowwork.hy_actiontype = flowworkdt.Rows[i]["hy_actiontype"].ToString();
Hyoa_flowwork.hy_identity_type = flowworkdt.Rows[i]["hy_identity_type"].ToString();
Hyoa_flowwork.hy_identity_id = flowworkdt.Rows[i]["hy_identity_id"].ToString();
Hyoa_flowwork.hy_jscondition = flowworkdt.Rows[i]["hy_jscondition"].ToString();
Hyoa_flowwork.hy_jscondition1 = flowworkdt.Rows[i]["hy_jscondition1"].ToString();
Hyoa_flowwork.hy_jscondition2 = flowworkdt.Rows[i]["hy_jscondition2"].ToString();
Hyoa_flowwork.hy_zdcyuserids = flowworkdt.Rows[i]["hy_zdcyuserids"].ToString();
Hyoa_flowwork.Insert();
}
}
}
#endregion
}
catch
{
ls_tip = "复制失败！";
}
finally
{
Response.Write("<script>alert('" + ls_tip + "');window.location.href='" + txturl.Text + "';</script>");
}
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_mudelid="";
string ls_colname="";
string ls_colid="";
string ls_colname2="";
string ls_colid2="";
string ls_colname3="";
string ls_colid3="";
string ls_tableid = "";
if (this.Request.QueryString["mudelid"] != null)
{
ls_mudelid = this.Request.QueryString["mudelid"].ToString();
}
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
}
//模块对应的域
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dt4 = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(ls_mudelid, ls_tableid);
if (dt4.Rows.Count > 0)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
if (ls_colname == "")
{
ls_colname = dt4.Rows[i]["hy_fieldname"].ToString();
ls_colid = dt4.Rows[i]["hy_fieldid"].ToString();
}
else
{
ls_colname = ls_colname + "+" + dt4.Rows[i]["hy_fieldname"].ToString();
ls_colid = ls_colid + "+" + dt4.Rows[i]["hy_fieldid"].ToString();
}
}
}
dt4.Clear();
string lsid = "";
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
dt4 = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(ls_mudelid,ls_tableid);
if (dt4.Rows.Count > 0)
{
ls_colname2 = dt4.Rows[0]["hy_columnshow"].ToString();
ls_colid2 = dt4.Rows[0]["hy_columnshowid"].ToString();
lsid = dt4.Rows[0]["ID"].ToString();
}
dt4.Clear();
HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
dt4 = Hyoa_listsearchfield.GetlistsearchfieldsbyMudelidAndListid(ls_mudelid,lsid);
if (dt4.Rows.Count > 0)
{
for (int k = 0; k < dt4.Rows.Count; k++)
{
if (ls_colname3 == "")
{
ls_colname3 = dt4.Rows[k]["hy_field"].ToString();
ls_colid3 = dt4.Rows[k]["hy_fieldid"].ToString();
}
else
{
ls_colname3 = ls_colname3 + "+" + dt4.Rows[k]["hy_field"].ToString();
ls_colid3 = ls_colid3 + "+" + dt4.Rows[k]["hy_fieldid"].ToString();
}
}
}
//HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield();
this.Response.Write(ls_colname + "*" + ls_colid + "#" + ls_colname2 + "*" + ls_colid2 + "#" + ls_colname3 + "*" + ls_colid3);
//return ;
}