本文整理汇总了C#中HyoaClass.Hyoa_tableconfig.GetTablesbymudelidandtableid方法的典型用法代码示例。如果您正苦于以下问题：C# HyoaClass.Hyoa_tableconfig.GetTablesbymudelidandtableid方法的具体用法？C# HyoaClass.Hyoa_tableconfig.GetTablesbymudelidandtableid怎么用？C# HyoaClass.Hyoa_tableconfig.GetTablesbymudelidandtableid使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类HyoaClass.Hyoa_tableconfig的用法示例。
在下文中一共展示了HyoaClass.Hyoa_tableconfig.GetTablesbymudelidandtableid方法的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DataPlay
private void DataPlay(int PageNo)
{
//得到当前模块对应的role
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (dttableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
{
//如果有流程的话，新建按钮就一直显示，不用作判断的，只要判断删除按钮就行。
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.delcontrol.Visible = true;
this.newcontrol.Visible = true;
//this.copycontrol.Visible = false; //流程模块暂时都不能复制
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
}
}
else
{
//如果非流程(授权用户统一管理)
if(dttableconfig.Rows[0]["hy_tablerole"].ToString() == "0")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
}
}
//如果非流程(每个人管理自己的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1")
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "2")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
}
}
//得到当前页号
this.lbdisplaytitle.Text = "";
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
Hyoa_flowmain.hy_mudelid = this.txtmudelid.Value;
Hyoa_flowmain.hy_tableid = this.txttableid.Value;
Hyoa_flowmain.hy_bt = this.hy_bt.Text;
Hyoa_flowmain.hy_djrname = this.hy_djrname.Text;
Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text;
Hyoa_flowmain.hy_djsj_start = this.hy_djsj_start.Text;
Hyoa_flowmain.hy_djsj_end = this.hy_djsj_end.Text;
Hyoa_flowmain.hy_bt = this.hy_bt.Text;
Hyoa_flowmain.hy_content1 = this.hy_content1.Text;
Hyoa_flowmain.hy_content2 = this.hy_content2.Text;
Hyoa_flowmain.hy_content3 = this.hy_content3.Text;
Hyoa_flowmain.hy_content4 = this.hy_content4.Text;
Hyoa_flowmain.hy_content5 = this.hy_content5.Text;
Hyoa_flowmain.hy_field1 = this.hy_field1.Text;
Hyoa_flowmain.hy_field2 = this.hy_field2.Text;
Hyoa_flowmain.hy_field3 = this.hy_field3.Text;
Hyoa_flowmain.hy_field4 = this.hy_field4.Text;
Hyoa_flowmain.hy_field5 = this.hy_field5.Text;
Hyoa_flowmain.hy_field6 = this.hy_field6.Text;
Hyoa_flowmain.hy_field7 = this.hy_field7.Text;
//.........这里部分代码省略.........
示例2: DataPlay
//加载主表单 Written by xf 20110515
private void DataPlay()
{
txtsavefields.Text = "";
txtsavefields_sx.Text = "";
if (this.Request.QueryString["op"] != null)
{
this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//旧文档
if (this.Request.QueryString["op"] == "modify")
{
this.td_browseflow.Visible = true; //查看流程
if (this.Request.QueryString["docid"] != null)
{
this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
DataTable dt = Hyoa_global.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
UpdateReadFlag(); //打开时添加阅读情况
}
dt.Clear();
//流程文档
if (this.txtifhaveflow.Value == "是")
{
//流程已结束
if (this.hy_curtacheid.Text == "**")
{
this.lblcurtachenameshow.Text = "流程已结束";
}
//加载页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
}
else
{
this.lblcurtachenameshow.Text = this.lbltablename.Text;
//非流程表单
this.td_browseflow.Visible = false;
//加载主表单页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");
//----加载评论页面 s add by xf 2011-11-19-----
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig_forpinglun.Rows.Count > 0)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
{
this.tb_nbsp.Visible = true;
this.tb_pltitle.Visible = true;
this.tb_plbody.Visible = true;
this.td_pinglun.Visible = true;
//得到已经评论的内容
HyoaClass.Hyoa_pinglun Hyoa_pinglun = new HyoaClass.Hyoa_pinglun();
DataTable dt_pinglun = Hyoa_pinglun.GetcommentByfatherid(this.txtdocid.Value);
if (dt_pinglun.Rows.Count > 0)
{
//输出评论记录
this.lblbody.Text = "";
for (var i = 0; i < dt_pinglun.Rows.Count; i++)
{
this.lblbody.Text += dt_pinglun.Rows[i]["hy_plbody"].ToString() + "<br> ";
this.lblbody.Text += "（评论人:" + dt_pinglun.Rows[i]["hy_plusername"].ToString() + " 所在部门:" + dt_pinglun.Rows[i]["hy_pldeptname"].ToString();
this.lblbody.Text += " 评论时间:" + dt_pinglun.Rows[i]["hy_pltime"].ToString() + " IP:" + dt_pinglun.Rows[i]["hy_plip"].ToString();
this.lblbody.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
}
}
}
//----加载评论页面 e-----
}
//.........这里部分代码省略.........
示例3: DataPlay
private void DataPlay(int PageNo)
{
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
//---查询条件---结束
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
//.........这里部分代码省略.........
示例4: DataPlay
//加载主表单 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")
{
//.........这里部分代码省略.........
示例5: onloadjs
//加载当前表单执行的onload代码 Written by xf 20110621
public string onloadjs()
{
string ls_mid = "";
if (this.Request.QueryString["mid"] != null)
{
ls_mid = this.Request.QueryString["mid"].ToString();
if (ls_mid.Contains(","))
ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
}
string ls_tableid = "";
if (this.Request.QueryString["tableid"] != null)
{
ls_tableid = this.Request.QueryString["tableid"].ToString();
if (ls_tableid.Contains(","))
ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
}
string ls_return = "";
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dt = Hyoa_tableconfig.GetTablesbymudelidandtableid(ls_mid, ls_tableid);
if (dt.Rows.Count > 0)
ls_return = dt.Rows[0]["hy_onload"].ToString();
return ls_return;
}示例6: DataPlay
//加载主表单 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)
//.........这里部分代码省略.........
示例7: DataPlay
//加载主表单 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)
{
//.........这里部分代码省略.........
示例8: DataPlay
//.........这里部分代码省略.........
{
if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1")
{
if (this.hy_djrid.Text == Session["hyuid"].ToString())
this.txtSystemClRight.Value = "1";
}
}
if (this.txtSystemClRight.Value == "1")
{
this.td_submit.Visible = true; //保存
this.td_continue.Visible = false; //保存并继续新建
this.td_xyb.Visible = false; //下一步
if (this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_tableid.Text == "TableVODfwxy" || this.hy_tableid.Text == "Tableffpdfwht" || this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_tableid.Text == "Tablekdjrht" || this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_tableid.Text == "Tablesjtxyyhzxy" || this.hy_tableid.Text == "Tablezdyht" || this.hy_tableid.Text == "Tablegxhzhht" || this.hy_tableid.Text == "Tableqtht" || this.hy_tableid.Text == "Tablexjsq" || this.hy_tableid.Text == "Tableshd" || this.hy_tableid.Text == "Tableszds")
{
string sql_wc = "";
DataTable dtwc;
sql_wc = "select * from hyt_blzt where DOCID='" + this.txtdocid.Value + "' and hy_state='未完成'";
dtwc = Hyoa_global.GetDataTable(sql_wc);
if (dtwc.Rows.Count > 0)
{
if (dtwc.Rows[0]["hy_state"].ToString() == "未完成")
{
this.td_wcan.Visible = true; //完成
}
}
this.td_continue.Visible = false;
this.td_xyb.Visible = true;
}
if (this.hy_ifconfirm.Text != "1" && this.hy_tableid.Text == "Tablefpbd")
{
this.btn_consubmit.Value = "付款";
this.td_consubmit.Visible = true; //确认
}
}
else
{
this.td_submit.Visible = false; //保存
this.td_wcan.Visible = false; //完成
this.td_xyb.Visible = false; //下一步
this.td_continue.Visible = false; //保存并继续新建
}
//如果是超级管理员把取消按钮显示出来。用于用户确认后还要修改
//if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
//{
// this.td_qxsubmit.Visible = true; //取消按钮
//}
//加载主表单页面
GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");
//----加载评论页面 s add by xf 2011-11-19-----
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
if (dt_tableconfig_forpinglun.Rows.Count > 0)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
{
if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
{
this.tb_nbsp.Visible = true;
this.tb_pltitle.Visible = true;
this.tb_plbody.Visible = true;
this.td_pinglun.Visible = true;
//得到已经评论的内容
HyoaClass.Hyoa_pinglun Hyoa_pinglun = new HyoaClass.Hyoa_pinglun();
DataTable dt_pinglun = Hyoa_pinglun.GetcommentByfatherid(this.txtdocid.Value);
if (dt_pinglun.Rows.Count > 0)
{
//输出评论记录
this.lblbody.Text = "";
for (var i = 0; i < dt_pinglun.Rows.Count; i++)
{
this.lblbody.Text += dt_pinglun.Rows[i]["hy_plbody"].ToString() + "<br> ";
this.lblbody.Text += "（评论人:" + dt_pinglun.Rows[i]["hy_plusername"].ToString() + " 所在部门:" + dt_pinglun.Rows[i]["hy_pldeptname"].ToString();
this.lblbody.Text += " 评论时间:" + dt_pinglun.Rows[i]["hy_pltime"].ToString() + " IP:" + dt_pinglun.Rows[i]["hy_plip"].ToString();
this.lblbody.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
}
}
}
}
}
//----加载评论页面 e-----
}
hywebopen_olddoc(); //旧文档OPEN的特殊处理
}
#endregion
}
// 部门礼品卡 显示导出按键 小潘 2015-12
if (this.hy_tableid.Text == "Tablelpksqd")
{
//if (this.hy_curtacheid.Text == "tache0001" || this.hy_curtacheid.Text == "**")
//{
this.td_dc.Visible = true;
//}
}
}示例9: getExcelContent
//需要导出的内容
private string getExcelContent()
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
#region ---查询条件---
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
}
else
{
if (ls_fieldid_sx == "1")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "2")
{
if (Session["conntype"].ToString() == "SQL")
{
cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' ";
}
if (Session["conntype"].ToString() == "ORACLE")
{
cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' ";
}
}
if (ls_fieldid_sx == "3")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " ";
}
if (ls_fieldid_sx == "4")
{
cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " ";
}
}
}
}
}
#endregion ---查询条件---
#region ---排序---
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
//.........这里部分代码省略.........
示例10: DataPlay
private void DataPlay(int PageNo)
{
//得到当前模块对应的role
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
{
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
}
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//如果非流程(授权用户统一管理)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "0")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
}
}
//如果非流程(每个人管理自己的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1")
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
//如果非流程(每个人操作自己的信息、授权用户可管理所有信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "2")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
{
string ls_fieldid = lv_searchfields[i].ToString();
string ls_fieldid_sx = lv_searchfields_sx[i].ToString();
string ls_searchtext = "";
if (this.Request.Form[ls_fieldid] != null)
{
ls_searchtext = this.Request.Form[ls_fieldid].ToString();
}
if (ls_searchtext != "")
{
if (ls_fieldid_sx == "0")
{
cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' ";
//.........这里部分代码省略.........
示例11: DataPlay
private void DataPlay(int PageNo)
{
//得到当前模块对应的role
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
{
ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
}
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
//判断当前用户是否有删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//如果非流程(授权用户可新建信息、可删除所有信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "0")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
}
}
//如果非流程(每个人管理自己的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1")
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
//如果非流程(每个人管理自己的信息、授权用户可管理所有信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "2")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol.Visible = true;
//this.copycontrol.Visible = true;
}
else
{
this.isrole.Value = "0";
this.newcontrol.Visible = true;
this.delcontrol_my.Visible = true;
//this.copycontrol.Visible = true;
}
}
//如果非流程(授权用户可新建、只能删自己新建的信息)
if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "3")
{
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.newcontrol.Visible = true;
this.delcontrol_sq.Visible = true;
//this.copycontrol.Visible = true;
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//得到当前页号
this.curpage.Text = PageNo.ToString();
//---查询条件---开始
string cmdStr_Search = "";
if (txtsearchfields.Text != "")
{
string[] lv_searchfields = txtsearchfields.Text.Split(',');
string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(',');
for (int i = 0; i < lv_searchfields.Length; i++)
//.........这里部分代码省略.........
示例12: DataPlay
//加载主表单 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++)
{
//.........这里部分代码省略.........
示例13: DataPlay
//加载主表单 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";
}
//.........这里部分代码省略.........
示例14: DataPlay
private void DataPlay(int PageNo)
{
//得到当前模块对应的全权用户组
HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
string ls_role = "Role9999";
if (dt_mudel.Rows.Count > 0)
{
if (dt_mudel.Rows[0]["hy_qqroleid"] == null)
{
return;
}
else
{
if (dt_mudel.Rows[0]["hy_qqroleid"] == "")
{
return;
}
else
{
ls_role = dt_mudel.Rows[0]["hy_qqroleid"].ToString();
}
}
}
//根据表ID和模块ID得到当前传进来的模块是否有流程
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value);
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
}
else
{
this.isrole.Value = "0";
Response.Write("<script>alert('您无权访问此页面的数据！');self.close();</script>");
return;
}
//根据表单得到对应的所有字段
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
DataTable dtflowfield = Hyoa_flowfield.Getflowfieldsbytableid(dttableconfig.Rows[0]["ID"].ToString());
//循环所有字段
string ls_flowfield = "";
if (dtflowfield.Rows.Count > 0)
{
for (int i = 0; i < dtflowfield.Rows.Count; i++)
{
string ls_fieldtype = dtflowfield.Rows[i]["hy_fieldtype"].ToString();
if (ls_fieldtype == "文本" || ls_fieldtype == "多行文本" || ls_fieldtype == "文本加按钮" || ls_fieldtype == "多行文本加按钮" || ls_fieldtype == "日期" || ls_fieldtype == "数值" || ls_fieldtype == "对话框列表" || ls_fieldtype == "复选框" || ls_fieldtype == "单选框" || ls_fieldtype == "口令")
{
ls_flowfield += ",a.hyc_" + dtflowfield.Rows[i]["hy_fieldid"].ToString();
}
}
}
HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
DataTable dtlist = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); //列表配置
this.lbdisplaytitle.Text = "";
//---排序---开始
string cmdStr_SearchSort = "";
if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString();
}
}
if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "")
{
if (cmdStr_SearchSort == "")
{
cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
else
{
cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString();
}
}
if (cmdStr_SearchSort == "")
{
//.........这里部分代码省略.........