protected void btndelinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
String[] v_uids = this.txtuids.Value.Split(',');
for (var i = 0; i < v_uids.Length; i++)
{
if (v_uids[i] != "")
{
//删除流程信息
Hyoa_flowinfor.hy_flowid = v_uids[i];
Hyoa_flowinfor.Delete();
//删除环节信息
Hyoa_flowtache.DeleteByflowid(v_uids[i]);
//删除流转信息
Hyoa_flowwork.DeleteAllbyflowid(v_uids[i]);
//删除流程对应的域
Hyoa_flowfield.DeleteAllbyflowid(v_uids[i]);
//删除流程环节对应的域
Hyoa_flowtachefield.DeleteAllbyflowid(v_uids[i]);
//删除流程环节对应的用户
Hyoa_flowtacheuser.DeleteAllbyflowid(v_uids[i]);
}
}
this.txtuids.Value = "";
//DataPlay(1);
DataPlay(System.Int32.Parse(this.curpage.Text));
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
//新文档时
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
Hyoa_tableconfig.ID = this.txtdocid.Text;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelid.SelectedValue.ToString();
Hyoa_tableconfig.hy_name = this.txtname.Value;
Hyoa_tableconfig.hy_onload = this.txthy_onload.Text;
Hyoa_tableconfig.hy_sort = float.Parse(this.txtsort.Value);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_tableconfig.hy_ifdisplayall = this.ddlifdisplayall.SelectedValue;
Hyoa_tableconfig.hy_ifcomment = this.ddlifcomment.SelectedValue;
Hyoa_tableconfig.hy_ispuballByflowYB = this.ddlispuballByflowYB.SelectedValue;
Hyoa_tableconfig.hy_tablerole = this.ddltablerole.SelectedValue;
Hyoa_tableconfig.hy_colnum = float.Parse(this.ddldisplaycol.SelectedValue);
Hyoa_tableconfig.hy_field1 = "";
Hyoa_tableconfig.hy_field2 = "";
Hyoa_tableconfig.hy_field3 = "";
Hyoa_tableconfig.hy_field4 = "";
Hyoa_tableconfig.hy_field5 = "";
if (this.txtop.Value == "add")
{
//先判断是否已经存在
DataTable dt = Hyoa_tableconfig.GetTable(this.txtdocid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该表单编号已存在，请重新填写！');history.back();</script>");
return;
}
if (this.txtdocid.Text.Length < 6)
{
Response.Write("<script>alert('表单编号长度必须大于5位！');history.back();</script>");
return;
}
if (this.txtdocid.Text.Substring(0, 5) != "Table")
{
Response.Write("<script>alert('表单编号必须以Table开头！');history.back();</script>");
return;
}
Hyoa_tableconfig.Insert();
//创建SQL表
if (CreateSQLTable()==false)
{
ls_tip = "生成表结构失败，请联系管理员！";
}
}
else
{
Hyoa_tableconfig.Update();
//修改时，保存完成后同时更新对应的字段中FLOWID值（如果非流程则置为空，如果是流程则置为值）
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
if (this.ddlifflowdoc.SelectedValue == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.ddlmudelid.SelectedValue);
if (dt_flow.Rows.Count > 0)
{
Hyoa_flowfield.Updateflowid_For_tacheconfig(dt_flow.Rows[0]["hy_flowid"].ToString(), this.txtdocid.Text);
}
}
else
{
Hyoa_flowfield.Updateflowid_For_tacheconfig("", this.txtdocid.Text);
}
//修改后，同时更新对应的字段中的模块ID，为了解决当表单中对应的模块修改后，字段中没有更新的BUG
Hyoa_flowfield.Updatemudelid_For_tableconfig(this.ddlmudelid.SelectedValue, this.txtdocid.Text);
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
//保存
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>");
}
}
//加载主表单 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的特殊处理
}
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
string ls_tip = "保存成功！";
//新文档时
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
if (this.txtop.Value == "add")
{
//先判断是否已经存在
DataTable dt = Hyoa_flowinfor.Getflowinfor(this.txtid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该流程已存在，请重新填写！');history.back();</script>");
return;
}
else
{
Hyoa_flowinfor.hy_flowid = this.txtid.Text;
Hyoa_flowinfor.hy_flowname = this.txtname.Value;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtsort.Value);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_flowinfor.Insert();
}
}
else
{
Hyoa_flowinfor.hy_flowid = this.txtid.Text;
Hyoa_flowinfor.hy_flowname = this.txtname.Value;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtsort.Value);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_flowinfor.Update();
}
//保存时更新选中的模块对应的流程字段（hy_flowid）
HyoaClass.DAO db = new HyoaClass.DAO();
string sql;
sql = "select a.id from hyt_flowfield a,hyt_tableconfig b where a.hy_tableid=b.ID and b.hy_ifflowdoc='是' and a.hy_mudelid='"+this.ddlmudelid.SelectedValue+"'";
DataTable dt_update = db.GetDataTable(sql);
if (dt_update.Rows.Count > 0)
{
for (var i = 0; i < dt_update.Rows.Count; i++)
{
sql = "update hyt_flowfield set hy_flowid='" + this.txtid.Text + "' where id='" + dt_update.Rows[i]["id"].ToString()+"'";
db.Execute(sql);
}
}
db.Close();
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
private void DataPlay()
{
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//判断当前用户是否有保存的权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.btn_submit.Visible = true; //保存
}
else
{
this.btn_submit.Visible = false; //保存
}
//加载模块
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudels();
if (dtmudel.Rows.Count > 0)
{
this.ddlmudelid.DataSource = dtmudel;
this.ddlmudelid.DataTextField = "hy_mudelname";
this.ddlmudelid.DataValueField = "hy_mudelid";
this.ddlmudelid.DataBind();
this.ddlmudelid.Items.Insert(0, "--请选择--");
this.ddlmudelid.SelectedIndex = 0;
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
if (this.Request.QueryString["id"] != null)
{
//根据id得到信息
this.txtid.Text = this.Request.QueryString["id"].ToString();
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getflowinfor(this.txtid.Text);
if (dt.Rows.Count > 0)
{
this.txtname.Value = dt.Rows[0]["hy_flowname"].ToString();
this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString();
this.ddlmudelid.SelectedValue = dt.Rows[0]["hy_mudelid"].ToString();
}
dt.Clear();
this.txtid.Enabled = false;
}
}
}
}
private void DataPlay()
{
//加载可选择的表
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig = Hyoa_tableconfig.GetTables();
this.ddlwhichtable.DataSource = dt_tableconfig;
this.ddlwhichtable.DataTextField = "hy_name";
this.ddlwhichtable.DataValueField = "ID";
this.ddlwhichtable.DataBind();
this.ddlwhichtable.Items.Insert(0, "--请选择--");
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//判断当前用户是否有保存的权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.btn_submit.Visible = true; //保存
}
else
{
this.btn_submit.Visible = false; //保存
}
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dt = Hyoa_flowfield.Getflowfield(this.txtdocid.Value);
if (dt.Rows.Count > 0)
{
this.txttableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.txtmudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
//this.txtflowid.Text = dt.Rows[0]["hy_flowid"].ToString();
//得到流程编号(如果当前字段所在的表单是流程表单，则需要读取FLOWID)
DataTable dt_table = Hyoa_tableconfig.GetTable(this.txttableid.Text);
if (dt_table.Rows.Count > 0)
{
if (dt_table.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
if (dt_flow.Rows.Count > 0)
{
this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
}
}
else
{
this.txtflowid.Text = "";
}
}
this.txtfieldid.Text = dt.Rows[0]["hy_fieldid"].ToString();
this.txtfieldname.Text = dt.Rows[0]["hy_fieldname"].ToString();
this.ddlfieldtype.SelectedValue = dt.Rows[0]["hy_fieldtype"].ToString();
this.ddlifreadonly.SelectedValue = dt.Rows[0]["hy_ifreadonly"].ToString();
this.ddldefaultvaluetype.SelectedValue = dt.Rows[0]["hy_defaultvaluetype"].ToString();
this.txtdefaultvalue.Text = dt.Rows[0]["hy_defaultvalue"].ToString();
this.ddloptiontype.SelectedValue = dt.Rows[0]["hy_optiontype"].ToString();
this.txtoptions.Text = dt.Rows[0]["hy_options"].ToString();
this.txtonclick.Text = dt.Rows[0]["hy_onclick"].ToString();
this.txtondblclick.Text = dt.Rows[0]["hy_ondblclick"].ToString();
this.txtonchange.Text = dt.Rows[0]["hy_onchange"].ToString();
this.txtonkeydown.Text = dt.Rows[0]["hy_onkeydown"].ToString();
this.txtonkeyup.Text = dt.Rows[0]["hy_onkeyup"].ToString();
this.txtsqlfield.Text = dt.Rows[0]["hy_sqlfield"].ToString();
this.txtclass.Text = dt.Rows[0]["hy_class"].ToString();
this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();
this.txtheight.Text = dt.Rows[0]["hy_height"].ToString();
this.ddltdnums.SelectedValue = dt.Rows[0]["hy_tdnums"].ToString();
this.txtsort.Text = dt.Rows[0]["hy_sort"].ToString();
this.txtwordlimit.Text = dt.Rows[0]["hy_wordlimit"].ToString();
this.ddlrequired.SelectedValue = dt.Rows[0]["hy_required"].ToString();
this.ddlalign.SelectedValue = dt.Rows[0]["hy_align"].ToString();
this.ddlifhiddle.SelectedValue = dt.Rows[0]["hy_ifhiddle"].ToString();
}
dt.Clear();
}
else
{
//得到模块ID
DataTable dt = Hyoa_tableconfig.GetTable(this.txttableid.Text);
if (dt.Rows.Count > 0)
{
this.txtmudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
}
else
{
Response.Write("<script>alert('读取表单信息出错！');history.back();</script>");
}
//得到流程编号(如果当前字段所在的表单是流程表单，则需要读取FLOWID)
if (dt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
if (dt_flow.Rows.Count > 0)
{
this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
}
}
else
{
this.txtflowid.Text = "";
}
////得到流程编号
//HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
//DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
//if (dt_flow.Rows.Count > 0)
//{
// this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
//}
}
//加载未分配的SQL字段
HyoaClass.DAO db = new HyoaClass.DAO();
DataTable dt_flowmain = db.GetDataTable("exec sp_mshelpcolumns 'hyp_flowmain'");
int j = 0;
for (int i = 0; i < dt_flowmain.Rows.Count; i++)
{
//hy_field60作为了是否提醒的固定标志位
if (dt_flowmain.Rows[i]["col_name"].ToString() != "DOCID" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_mudelid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_tableid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_flowid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_flowname" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_curtacheid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_curtachename" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_curclrid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_curclrname" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_djrid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_djrbmid" && dt_flowmain.Rows[i]["col_name"].ToString() != "hy_field60")
{
//判断该当前字段是否已经配置过了，配置过了就不加载了。
DataTable dtjudeg_flowfield = db.GetDataTable("select * from hyt_flowfield where hy_mudelid='" + this.txtmudelid.Text + "' and hy_tableid='" + this.txttableid.Text + "' and hy_sqlfield='" + dt_flowmain.Rows[i]["col_name"].ToString() + "'");
if (dtjudeg_flowfield.Rows.Count > 0)
{ }
else
{
this.ddlsqlfield.Items.Insert(j, new ListItem(dt_flowmain.Rows[i]["col_name"].ToString(), dt_flowmain.Rows[i]["col_name"].ToString()));
j += 1;
}
}
}
//旧文档加载当前字段对应的SQL，添加到第一项
if (this.Request.QueryString["op"] == "modify")
{
this.ddlsqlfield.Items.Insert(0, new ListItem(this.txtsqlfield.Text, this.txtsqlfield.Text));
}
else
{
this.ddlsqlfield.Items.Insert(0, new ListItem("--请选择--",""));
}
db.Close();
}
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tdnewdoc.Visible = true; //新建
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tdnewdoc.Visible = false; //新建
this.tddeldoc.Visible = false; //删除
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt;
Hyoa_flowinfor.hy_flowname = this.hy_bt_1.Value;
dt = Hyoa_flowinfor.GetflowinforsByflowname();
DataTable tempTable = dt.Clone();
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();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
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()
{
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;
}
}
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
string ls_tip = "保存成功！";
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
//先判断流程是否已经存在
DataTable dt = Hyoa_flowinfor.Getflowinfor(this.txtFlowID.Value);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该流程已存在，请重新填写！');history.back();</script>");
return;
}
else
{
//添加流程信息
Hyoa_flowinfor.hy_flowid = this.txtFlowID.Value;
Hyoa_flowinfor.hy_flowname = this.txtFlowCh.Value;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtFlowSort.Value);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_flowinfor.Insert();
//添加环节信息
DataTable dtflowtache = Hyoa_flowtache.Getflowtachebyflowid(this.txtSrcFlowID.Value);
if (dtflowtache.Rows.Count > 0)
{
for (var i = 0; i < dtflowtache.Rows.Count; i++)
{
//复制到新流程中
Hyoa_flowtache.ID = Hyoa_global.GetRandom();
Hyoa_flowtache.hy_flowid = this.txtFlowID.Value;
Hyoa_flowtache.hy_tacheid = dtflowtache.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtache.hy_tachename = dtflowtache.Rows[i]["hy_tachename"].ToString();
Hyoa_flowtache.hy_sort = System.Int32.Parse(dtflowtache.Rows[i]["hy_sort"].ToString());
Hyoa_flowtache.hy_ifshowcurdept = dtflowtache.Rows[i]["hy_ifshowcurdept"].ToString();
Hyoa_flowtache.hy_XValue = dtflowtache.Rows[i]["hy_XValue"].ToString();
Hyoa_flowtache.hy_YValue = dtflowtache.Rows[i]["hy_YValue"].ToString();
Hyoa_flowtache.hy_rdDoIsSendSms = dtflowtache.Rows[i]["hy_rdDoIsSendSms"].ToString();
Hyoa_flowtache.hy_rdDoIsSendMessage = dtflowtache.Rows[i]["hy_rdDoIsSendMessage"].ToString();
Hyoa_flowtache.hy_rdPassIsSendSms = dtflowtache.Rows[i]["hy_rdPassIsSendSms"].ToString();
Hyoa_flowtache.hy_rdPassIsSendMessage = dtflowtache.Rows[i]["hy_rdPassIsSendMessage"].ToString();
Hyoa_flowtache.Insert();
}
}
//添加流转信息
DataTable dtflowwork = Hyoa_flowwork.Getflowworksbyflowid(this.txtSrcFlowID.Value);
if (dtflowwork.Rows.Count > 0)
{
for (var i = 0; i < dtflowwork.Rows.Count; i++)
{
//复制到新流程中
Hyoa_flowwork.ID = Hyoa_global.GetRandom();
Hyoa_flowwork.hy_flowid = this.txtFlowID.Value;
Hyoa_flowwork.hy_curtacheid = dtflowwork.Rows[i]["hy_curtacheid"].ToString();
Hyoa_flowwork.hy_curtachename = dtflowwork.Rows[i]["hy_curtachename"].ToString();
Hyoa_flowwork.hy_nexttacheid = dtflowwork.Rows[i]["hy_nexttacheid"].ToString();
Hyoa_flowwork.hy_nexttachename = dtflowwork.Rows[i]["hy_nexttachename"].ToString();
Hyoa_flowwork.hy_sort = System.Int32.Parse(dtflowwork.Rows[i]["hy_sort"].ToString());
Hyoa_flowwork.hy_actiontype = dtflowwork.Rows[i]["hy_actiontype"].ToString();
Hyoa_flowwork.Insert();
}
}
//添加流程对应的域
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbyflowid(this.txtSrcFlowID.Value);
if (dtflowfield.Rows.Count > 0)
{
for (var i = 0; i < dtflowfield.Rows.Count; i++)
{
//复制到新流程中
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.hy_flowid = this.txtFlowID.Value;
Hyoa_flowfield.hy_fieldid = dtflowfield.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowfield.hy_fieldname = dtflowfield.Rows[i]["hy_fieldname"].ToString();
Hyoa_flowfield.hy_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
Hyoa_flowfield.hy_config = dtflowfield.Rows[i]["hy_config"].ToString();
Hyoa_flowfield.hy_sort = System.Int32.Parse(dtflowfield.Rows[i]["hy_sort"].ToString());
Hyoa_flowfield.Insert();
}
}
//添加流程环节对应的域
DataTable dtflowtachefield = Hyoa_flowtachefield.Getflowtachefieldbyflowid(this.txtSrcFlowID.Value);
if (dtflowtachefield.Rows.Count > 0)
{
for (var i = 0; i < dtflowtachefield.Rows.Count; i++)
{
//复制到新流程中
Hyoa_flowtachefield.ID = Hyoa_global.GetRandom();
Hyoa_flowtachefield.hy_flowid = this.txtFlowID.Value;
Hyoa_flowtachefield.hy_tacheid = dtflowtachefield.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtachefield.hy_fieldid = dtflowtachefield.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowtachefield.Insert();
}
}
//添加流程环节对应的人员
DataTable dtflowtacheuser = Hyoa_flowtacheuser.Getflowtacheuserbyflowid(this.txtSrcFlowID.Value);
if (dtflowtacheuser.Rows.Count > 0)
{
for (var i = 0; i < dtflowtacheuser.Rows.Count; i++)
{
//复制到新流程中
Hyoa_flowtacheuser.ID = Hyoa_global.GetRandom();
Hyoa_flowtacheuser.hy_flowid = this.txtFlowID.Value;
Hyoa_flowtacheuser.hy_tacheid = dtflowtacheuser.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtacheuser.hy_userid = dtflowtacheuser.Rows[i]["hy_userid"].ToString();
Hyoa_flowtacheuser.Insert();
}
}
}
//处理完成后的提示及跳转
Response.Write("<script>alert('" + ls_tip + "');window.opener.location.reload();self.close();</script>");
}
private void DataPlay()
{
//判断当前用户是否有保存的权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.btn_submit.Visible = true; //保存
}
else
{
this.btn_submit.Visible = false; //保存
}
//加载模块
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dtmudel = Hyoa_mudel.Getmudels();
if (dtmudel.Rows.Count > 0)
{
this.ddlmudelid.DataSource = dtmudel;
this.ddlmudelid.DataTextField = "hy_mudelname";
this.ddlmudelid.DataValueField = "hy_mudelid";
this.ddlmudelid.DataBind();
this.ddlmudelid.Items.Insert(0, "--请选择--");
this.ddlmudelid.SelectedIndex = 0;
}
//根据流程ID得到流程名称
if (this.txtSrcFlowID.Value != "")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt = Hyoa_flowinfor.Getflowinfor(this.txtSrcFlowID.Value);
if(dt.Rows.Count>0)
{
this.lblSrcFlowID.Text = this.txtSrcFlowID.Value;
this.lblSrcFlowName.Text = dt.Rows[0]["hy_flowname"].ToString();
}
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
//新文档时
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
if (this.txtop.Value == "add")
{
//先判断是否已经存在
DataTable dt = Hyoa_flowinfor.Getflowinfor(this.txtid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该流程已存在，请重新填写！');history.back();</script>");
return;
}
if (this.txtid.Text.Length < 5)
{
Response.Write("<script>alert('模块编号长度必须大于4位！');history.back();</script>");
return;
}
if (this.txtid.Text.Substring(0, 4) != "Flow")
{
Response.Write("<script>alert('模块编号必须以Flow开头！');history.back();</script>");
return;
}
Hyoa_flowinfor.hy_flowid = this.txtid.Text;
Hyoa_flowinfor.hy_flowname = this.txtname.Value;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtsort.Value);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_flowinfor.Insert();
}
else
{
Hyoa_flowinfor.hy_flowid = this.txtid.Text;
Hyoa_flowinfor.hy_flowname = this.txtname.Value;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtsort.Value);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_flowinfor.Update();
}
//保存时更新选中的模块对应的流程字段（hy_flowid）
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dt_update = Hyoa_flowfield.Getflowfieldsbymudelid_For_flowinfor(this.ddlmudelid.SelectedValue);
if (dt_update.Rows.Count > 0)
{
for (var i = 0; i < dt_update.Rows.Count; i++)
{
Hyoa_flowfield.Updateflowid_For_flowinfor(this.txtid.Text, dt_update.Rows[i]["id"].ToString());
}
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
//加载主表单 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()
{
//加载可选择的表
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
//判断当前用户是否有保存的权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.btn_submit.Visible = true; //保存
}
else
{
this.btn_submit.Visible = false; //保存
}
//旧文档
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
if (this.Request.QueryString["op"] == "modify")
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
DataTable dt = Hyoa_flowfield.Getflowfield(this.txtdocid.Value);
if (dt.Rows.Count > 0)
{
this.txttableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.txtmudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
//得到流程编号(如果当前字段所在的表单是流程表单，则需要读取FLOWID)
DataTable dt_table = Hyoa_tableconfig.GetTable(this.txttableid.Text);
if (dt_table.Rows.Count > 0)
{
if (dt_table.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
if (dt_flow.Rows.Count > 0)
{
this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
}
}
else
{
this.txtflowid.Text = "";
}
}
this.txtfieldid.Text = dt.Rows[0]["hy_fieldid"].ToString();
this.txtfieldid.Enabled = false;
this.txtfieldname.Text = dt.Rows[0]["hy_fieldname"].ToString();
this.ddlfieldtype.SelectedValue = dt.Rows[0]["hy_fieldtype"].ToString();
this.txtfieldtype_old.Text = dt.Rows[0]["hy_fieldtype"].ToString();
this.ddlifreadonly.SelectedValue = dt.Rows[0]["hy_ifreadonly"].ToString();
this.ddldefaultvaluetype.SelectedValue = dt.Rows[0]["hy_defaultvaluetype"].ToString();
this.txtdefaultvalue.Text = dt.Rows[0]["hy_defaultvalue"].ToString();
this.ddloptiontype.SelectedValue = dt.Rows[0]["hy_optiontype"].ToString();
this.txtoptions.Text = dt.Rows[0]["hy_options"].ToString();
this.txtonclick.Text = dt.Rows[0]["hy_onclick"].ToString();
this.txtondblclick.Text = dt.Rows[0]["hy_ondblclick"].ToString();
this.txtonchange.Text = dt.Rows[0]["hy_onchange"].ToString();
this.txtonkeydown.Text = dt.Rows[0]["hy_onkeydown"].ToString();
this.txtonkeyup.Text = dt.Rows[0]["hy_onkeyup"].ToString();
this.txtonfocus.Text = dt.Rows[0]["hy_onfocus"].ToString();
this.txtonblur.Text = dt.Rows[0]["hy_onblur"].ToString();
this.txtclass.Text = dt.Rows[0]["hy_class"].ToString();
this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();
this.txtheight.Text = dt.Rows[0]["hy_height"].ToString();
this.ddltdnums.SelectedValue = dt.Rows[0]["hy_tdnums"].ToString();
this.txtsort.Text = dt.Rows[0]["hy_sort"].ToString();
this.txtwordlimit.Text = dt.Rows[0]["hy_wordlimit"].ToString();
this.ddlrequired.SelectedValue = dt.Rows[0]["hy_required"].ToString();
this.ddlalign.SelectedValue = dt.Rows[0]["hy_align"].ToString();
this.ddlifhiddle.SelectedValue = dt.Rows[0]["hy_ifhiddle"].ToString();
this.ddlifdbsybt.SelectedValue = dt.Rows[0]["hy_ifdbsybt"].ToString();
}
dt.Clear();
}
else
{
//得到模块ID
DataTable dt = Hyoa_tableconfig.GetTable(this.txttableid.Text);
if (dt.Rows.Count > 0)
{
this.txtmudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
}
else
{
Response.Write("<script>alert('读取表单信息出错！');history.back();</script>");
}
//得到流程编号(如果当前字段所在的表单是流程表单，则需要读取FLOWID)
if (dt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
if (dt_flow.Rows.Count > 0)
{
this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
}
}
else
{
this.txtflowid.Text = "";
}
//自动获取最大排序号，然后+2
DataTable dt_maxsort = Hyoa_flowfield.GetMaxfieldsortbytable(this.txttableid.Text);
if (dt_maxsort.Rows.Count > 0)
txtsort.Text = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString();
else
txtsort.Text = "1";
}
}
}
//加载主表单 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; //新文档时，“已读人员”按钮隐藏
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
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
string ls_tip = "保存成功！";
//string lssql1 = "SELECT * FROM hyt_flowfield WHERE hy_tableid = '" + this.lbtableidbysorce.Text + "'"; //得到配置字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
int i;
DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.lbtableidbysorce.Text);
string newtableid;
newtableid = Hyoa_global.GetRandom();
if (flowfielddt.Rows.Count > 0)
{
for (i = 0; i < flowfielddt.Rows.Count; i++)
{
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.hy_tableid = newtableid;
Hyoa_flowfield.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_flowfield.hy_flowid = this.txtflowidbymd.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_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 = System.Int32.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.Insert();
}
}
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); //hyt_tableconfig
DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.lbmudelidbysource.Text);
if (tableconfigdt.Rows.Count > 0)
{
Hyoa_tableconfig.ID = newtableid;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_tableconfig.hy_name = this.txttablenamebymd.Text;
Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
Hyoa_tableconfig.hy_sort = System.Int32.Parse(this.txttablesortbymd.Text);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
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.Insert();
}
//以下为流程模块的功能，非流程模块不需要执行
if (this.ddlifflowdoc.SelectedValue == "是")
{
//string lssql2 = "SELECT * FROM hyt_flowinfor WHERE hy_mudelid = 'bgyply'";//得到模块对应的流程
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable flowinfordt = Hyoa_flowinfor.Getflowinforbymudelid(this.lbmudelidbysource.Text);
string lssoureceflowid = flowfielddt.Rows[0]["hy_flowid"].ToString();//得到老模块的flowid 后面要用到
//插入流程信息start
Hyoa_flowinfor.hy_flowid = this.txtflowidbymd.Text;
Hyoa_flowinfor.hy_flowname =this.txtflownamebymd.Text;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtflowsortbymd.Text);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_flowinfor.Insert();
//插入流程信息end
//string lssql3 = "select * from hyt_flowtache where hy_flowid = 'flow0004'";//流程对应的环节
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
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 = this.txtflowidbymd.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_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.Insert();
}
}
//string lssql4 = "select * from hyt_flowtachefield where hy_flowid='flow0004'";//流程环节对应的域
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
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 = this.txtflowidbymd.Text;
Hyoa_flowtachefield.hy_tacheid = flowtachefielddt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtachefield.hy_fieldid = flowtachefielddt.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowtachefield.Insert();
}
}
//string lssql5 = "select * from hyt_flowtacheuser where hy_flowid='flow0004'";//流程环节对应的用户
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
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 = this.txtflowidbymd.Text;
Hyoa_flowtacheuser.hy_tacheid = flowtacheuserdt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtacheuser.hy_userid = flowtacheuserdt.Rows[i]["hy_userid"].ToString();
Hyoa_flowtacheuser.Insert();
}
}
//string lssql6 = "select * from hyt_flowwork where hy_flowid='flow0004'";//流程的下环节对应什么，即工作流
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
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 = this.txtflowidbymd.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.Insert();
}
}
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//判断目的表单ID是否重复
DataTable dt_table = Hyoa_tableconfig.GetTable(txttableidbymd.Text);
if (dt_table.Rows.Count > 0)
{
Response.Write("<script>alert('目的表单ID已存在！');</script>");
return;
}
//插入TABLE配置
DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.lbmudelidbysource.Text);
if (tableconfigdt.Rows.Count > 0)
{
Hyoa_tableconfig.ID = txttableidbymd.Text;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_tableconfig.hy_name = this.txttablenamebymd.Text;
Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
Hyoa_tableconfig.hy_sort = float.Parse(this.txttablesortbymd.Text);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
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();
}
//插入FIELD配置
int i;
DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.lbtableidbysorce.Text);
if (flowfielddt.Rows.Count > 0)
{
for (i = 0; i < flowfielddt.Rows.Count; i++)
{
Hyoa_flowfield.ID = Hyoa_global.GetRandom();
Hyoa_flowfield.hy_tableid = txttableidbymd.Text;
Hyoa_flowfield.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_flowfield.hy_flowid = this.txtflowidbymd.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_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();
}
}
//生成SQL/ORACLE中的表
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * into hyc_" + txttableidbymd.Text + " from hyc_" + this.lbtableidbysorce.Text + " where 1=0";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "create table hyc_" + txttableidbymd.Text + " as select * from hyc_" + this.lbtableidbysorce.Text + " where 1=2";
}
Hyoa_global.ExcuteSQL(sql);
//以下为流程模块的功能，非流程模块不需要执行
if (this.ddlifflowdoc.SelectedValue == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable flowinfordt = Hyoa_flowinfor.Getflowinforbymudelid(this.lbmudelidbysource.Text);
string lssoureceflowid = flowfielddt.Rows[0]["hy_flowid"].ToString();//得到老模块的flowid 后面要用到
//插入流程信息start
Hyoa_flowinfor.hy_flowid = this.txtflowidbymd.Text;
Hyoa_flowinfor.hy_flowname =this.txtflownamebymd.Text;
Hyoa_flowinfor.hy_sort = System.Int32.Parse(this.txtflowsortbymd.Text);
Hyoa_flowinfor.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
Hyoa_flowinfor.Insert();
//插入流程信息end
//string lssql3 = "select * from hyt_flowtache where hy_flowid = 'flow0004'";//流程对应的环节
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
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 = this.txtflowidbymd.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();
}
}
//string lssql4 = "select * from hyt_flowtachefield where hy_flowid='flow0004'";//流程环节对应的域
HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield();
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 = this.txtflowidbymd.Text;
Hyoa_flowtachefield.hy_tacheid = flowtachefielddt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtachefield.hy_fieldid = flowtachefielddt.Rows[i]["hy_fieldid"].ToString();
Hyoa_flowtachefield.Insert();
}
}
//string lssql5 = "select * from hyt_flowtacheuser where hy_flowid='flow0004'";//流程环节对应的用户
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
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 = this.txtflowidbymd.Text;
Hyoa_flowtacheuser.hy_tacheid = flowtacheuserdt.Rows[i]["hy_tacheid"].ToString();
Hyoa_flowtacheuser.hy_userid = flowtacheuserdt.Rows[i]["hy_userid"].ToString();
Hyoa_flowtacheuser.Insert();
}
}
//string lssql6 = "select * from hyt_flowwork where hy_flowid='flow0004'";//流程的下环节对应什么，即工作流
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
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 = this.txtflowidbymd.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();
}
}
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
string ls_tip = "保存成功！";
//新文档时
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
string lstableid="";
HyoaClass.Hyoa_detail Hyoa_detail = new HyoaClass.Hyoa_detail();//主表单显示的列数
if (this.txtop.Value == "add")
{
////先判断这个模块编号是否已经存在
//DataTable dt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
//if (dt.Rows.Count > 0)
//{
// Response.Write("<script>alert('该模块的表单配置已存在，请重新填写！');history.back();</script>");
// return;
//}
//else
//{
lstableid = Hyoa_global.GetRandom();
Hyoa_tableconfig.ID = lstableid;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelid.SelectedValue.ToString();
Hyoa_tableconfig.hy_name = this.txtname.Value;
Hyoa_tableconfig.hy_onload = this.txthy_onload.Value;
Hyoa_tableconfig.hy_sort = float.Parse(this.txtsort.Value);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_tableconfig.hy_ifdisplayall = this.ddlifdisplayall.SelectedValue;
Hyoa_tableconfig.hy_ispuballByflowYB = this.ddlispuballByflowYB.SelectedValue;
Hyoa_tableconfig.hy_tablerole = this.ddltablerole.SelectedValue;
Hyoa_tableconfig.Insert();
//新文档时增加主表显示列数
Hyoa_detail.hy_fatherid = lstableid;
Hyoa_detail.hy_colnum = int.Parse(this.ddldisplaycol.SelectedValue);
Hyoa_detail.hy_field1 = "";
Hyoa_detail.hy_field2 = "";
Hyoa_detail.hy_field3 = "";
Hyoa_detail.hy_field4 = "";
Hyoa_detail.hy_field5 = "";
Hyoa_detail.Insert();
//}
}
else
{
Hyoa_tableconfig.ID = this.txtdocid.Value;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_tableconfig.hy_name = this.txtname.Value;
Hyoa_tableconfig.hy_onload = this.txthy_onload.Value;
Hyoa_tableconfig.hy_sort = float.Parse(this.txtsort.Value);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_tableconfig.hy_ifdisplayall = this.ddlifdisplayall.SelectedValue;
Hyoa_tableconfig.hy_ispuballByflowYB = this.ddlispuballByflowYB.SelectedValue;
Hyoa_tableconfig.hy_tablerole = this.ddltablerole.SelectedValue;
Hyoa_tableconfig.Update();
//更新文档时更新主表显示列数
Hyoa_detail.hy_fatherid = this.txtdocid.Value;
Hyoa_detail.hy_colnum = int.Parse(this.ddldisplaycol.SelectedValue);
Hyoa_detail.hy_field1 = "";
Hyoa_detail.hy_field2 = "";
Hyoa_detail.hy_field3 = "";
Hyoa_detail.hy_field4 = "";
Hyoa_detail.hy_field5 = "";
DataTable dt2 = Hyoa_detail.Getdetail(this.txtdocid.Value);
if (dt2.Rows.Count > 0)
{
Hyoa_detail.Update();
}
else
{
Hyoa_detail.Insert();
}
//修改时，保存完成后同时更新对应的字段中FLOWID值（如果非流程则置为空，如果是流程则置为值）
HyoaClass.DAO db = new HyoaClass.DAO();
string sql_field = "";
if (this.ddlifflowdoc.SelectedValue == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.ddlmudelid.SelectedValue);
if (dt_flow.Rows.Count > 0)
{
sql_field = "update hyt_flowfield set hy_flowid='" + dt_flow.Rows[0]["hy_flowid"].ToString() + "' where hy_tableid='" + this.txtdocid.Value + "'";
}
}
else
{
sql_field = "update hyt_flowfield set hy_flowid='' where hy_tableid='" + this.txtdocid.Value + "'";
}
db.Execute(sql_field);
db.Close();
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
