protected void Page_Load(object sender, EventArgs e) { string ls_docids=""; string ls_filepath=""; if (this.Request.QueryString["docids"] != null) { ls_docids = this.Request.QueryString["docids"].ToString(); } string[] lv_docids; lv_docids = ls_docids.Split(','); HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); DataTable dt = new DataTable(); for (int j = 0; j < lv_docids.Length; j++) { dt = Hyoa_fileatt.Getfileatt(lv_docids[j]); if (dt.Rows[0]["hy_userid"].ToString() == Session["hyuid"].ToString() || Hyoa_global.isHaveRole("Role9995", Session["hyuid"].ToString())) { ls_filepath = Server.MapPath("~/") + dt.Rows[0]["hy_filepath"].ToString(); //this.Response.Write(ls_filepath); //return; if (File.Exists(ls_filepath)) { System.IO.File.Delete(ls_filepath); } Hyoa_fileatt.ID = lv_docids[j]; Hyoa_fileatt.Delete(); } dt.Clear(); } this.Response.Write("aaa"); return ; }
//保存或提交时的JS代码(判断是否必填项),动态架构 Written by xf 20110515 public string CheckfmMainInput() { 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_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9995", Session["hyuid"].ToString())) { } else { HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); //根据模块ID和表单ID得到对应的配置字段 DataTable dt_gettablecolumns = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(ls_mid, ls_tableid); if (dt_gettablecolumns.Rows.Count > 0) { //判断是否必填 for (int i = 0; i < dt_gettablecolumns.Rows.Count; i++) { if (dt_gettablecolumns.Rows[i]["hy_required"].ToString() == "是") { if (dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "文本" || dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "多行文本" || dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "文本加按钮" || dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "多行文本加按钮" || dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "日期" || dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "口令") ls_return += "try{if(fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".value==\"\"){alert(\"" + dt_gettablecolumns.Rows[i]["hy_fieldname"].ToString() + "不能为空!\");fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".focus();return false;}}catch(err){}"; if (dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "数值") ls_return += "try{if(fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".value==\"\"){alert(\"" + dt_gettablecolumns.Rows[i]["hy_fieldname"].ToString() + "不能为空!\");fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".focus();return false;}if(isNaN(fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".value)){alert(\"" + dt_gettablecolumns.Rows[i]["hy_fieldname"].ToString() + "必须为数值!\");fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".focus();return false}}catch(err){}"; if (dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "对话框列表") ls_return += "try{if(fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".selectedIndex==0){alert(\"请选择" + dt_gettablecolumns.Rows[i]["hy_fieldname"].ToString() + "!\");fm." + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + ".focus();return false;}}catch(err){}"; //if (dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "复选框") // ls_return += "try{var ls_select=\"\";var obj1=document.getElementsById(\"" + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + "\");for(var i = 0; i < obj1.length; i++){if(obj1[i].checked){if(ls_select==\"\"){ls_select = obj1[i].value;}else{ls_select=ls_select+\"#\"+obj1[i].value;}}}if(ls_select==\"\"){alert('请选择" + dt_gettablecolumns.Rows[i]["hy_fieldname"].ToString() + "!');return false;}}catch(err){}"; //if (dt_gettablecolumns.Rows[i]["hy_fieldtype"].ToString() == "单选框") // ls_return += "try{var ls_select=\"\";var obj1=document.getElementsById(\"" + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + "\");for(var i = 0; i < obj1.length; i++){if(obj1[i].checked){if(ls_select==\"\"){ls_select = obj1[i].value;}else{ls_select=ls_select+\"#\"+obj1[i].value;}}}if(ls_select==\"\"){alert('请选择" + dt_gettablecolumns.Rows[i]["hy_fieldname"].ToString() + "!');return false;}}catch(err){}"; } //哪个字段是待办事宜提醒的字段 edited by xf 20140625 if (dt_gettablecolumns.Rows[i]["hy_ifdbsybt"].ToString() == "是") { ls_return += "try{var d=document.getElementById('" + dt_gettablecolumns.Rows[i]["hy_fieldid"].ToString() + "');if(d==null||typeof(d.value)=='undefined'){}else{document.getElementById('hy_bt').value=d.value;}}catch(err){}"; } } } } return ls_return; }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (this.Request.QueryString["pop"] != null) { this.txtifpop.Value = this.Request.QueryString["pop"].ToString(); //是否弹出窗口 } //esppath = Server.MapPath("esp"); //if (this.Session["hyuid"].ToString() == "") // this.Response.Redirect("../login.aspx"); if (Request.QueryString["url"] != null) { this.url.Value = Request.QueryString["url"].ToString(); } if (Request.QueryString["espid"] != null) { this.txtdocid.Value = Request.QueryString["espid"].ToString(); } //按钮控制 this.tdCreateNew.Visible = false; this.tdSave.Visible = false; //判断当前用户是否有新建删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_mudelid = "Mudelfwgl"; string ls_role = ""; HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel = Hyoa_mudel.Getmudel(ls_mudelid); if (dt_mudel.Rows.Count > 0) { ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString(); } if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { if (Request.QueryString["op"] != null) { string ls_op = Request.QueryString["op"].ToString(); txtop.Value = ls_op; if (ls_op == "add") { this.tdCreateNew.Visible = true; this.tdSave.Visible = true; this.txtdocid.Value = Hyoa_global.GetRandom(); } } } } }
public string hy_nav() { string hy_nav = ""; HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //得到一级目录 HyoaClass.Hyoa_ml Hyoa_ml = new HyoaClass.Hyoa_ml(); DataTable dt = Hyoa_ml.GetFirstmls(); if (dt.Rows.Count > 0) { string ls_flag1 = "0"; //无权限 int j = 0; for (int i = 0; i < dt.Rows.Count; i++) { ls_flag1 = "0"; //输出一级 if (dt.Rows[i]["hy_role"].ToString() == "" || dt.Rows[i]["hy_role"] == null) { ls_flag1 = "1"; //有权限(没有设置role) } else { if (Hyoa_global.isHaveRole(dt.Rows[i]["hy_role"].ToString(), Session["hyuid"].ToString())) { ls_flag1 = "1"; //有权限 } } if (dt.Rows[i]["hy_ifqy"].ToString() != "是") { //未启用,直接赋为无权限 ls_flag1 = "0"; } if (ls_flag1 == "1") { hy_nav += "<div id=\"div_" + i.ToString() + "\" title=\"<img src=" + dt.Rows[i]["hy_pic"].ToString() + " /> " + dt.Rows[i]["MLName"].ToString() + "\" iconcss=\"menu-icon-model\" class=\"l-scroll\" >"; hy_nav += "<ul id=\"global_channel_tree" + (j + 1).ToString() + "\" style=\"margin-top: 3px;\">"; hy_nav += GetSecMl(dt.Rows[i]["MLID"].ToString()); hy_nav += "</ul>"; hy_nav += "</div>"; j += 1; } } } return hy_nav; }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("/login.aspx"); if (!this.IsPostBack) { if (this.Request.QueryString["flowid"] != null) { string ls_flowid = this.Request.QueryString["flowid"].ToString(); this.txtflowid.Value = ls_flowid; //判断一下是否是管理员 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()) == true) { HyoaClass.Hyoa_lcdz Hyoa_lcdz = new HyoaClass.Hyoa_lcdz(); //制作流程图 this.txtFlowXML.Value = Hyoa_lcdz.GetXmlBody(ls_flowid); } } } }
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; //保存 } //旧文档 if (this.Request.QueryString["op"] == "modify") { if (this.Request.QueryString["id"] != null) { //根据id得到信息 this.txtdocid.Value = this.Request.QueryString["id"].ToString(); HyoaClass.Hyoa_link Hyoa_link = new HyoaClass.Hyoa_link(); DataTable dt = Hyoa_link.Getlink(this.txtdocid.Value); if (dt.Rows.Count > 0) { this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString(); this.txtname.Value = dt.Rows[0]["hy_linkname"].ToString(); this.txtlink.Value = dt.Rows[0]["hy_linkurl"].ToString(); } dt.Clear(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); if (!this.IsPostBack) { //判断是否有权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { } else { this.tdsave.Visible = false; Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>"); } if (this.Request.QueryString["userid"] != null) { this.txtuserid.Value = this.Request.QueryString["userid"].ToString(); } } }
private void DataPlay(int PageNo) { //得到当前模块对应的role HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value); string ls_role = "Rolegwk"; if (dt_mudel.Rows.Count > 0) ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString(); //判断当前用户是否有删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.tddeldoc.Visible = true; //删除 this.tdnewdoc.Visible = true;//新建 } else { this.isrole.Value = "0"; this.tddeldoc.Visible = false; //删除 this.tdnewdoc.Visible = false;//新建 } //得到当前页号 this.curpage.Text = PageNo.ToString(); //已流转完成的全局公告 string sql = ""; string lstypeid = ""; if (this.Request.QueryString["type"] != null) { lstypeid = this.Request.QueryString["type"].ToString(); } sql = "select * from hyp_gwk where 1=1"; if (this.hy_djsj_start_1.Value != "") { if (Session["conntype"].ToString() == "SQL") { sql += " and hy_djsj>='" + this.hy_djsj_start_1.Value + "' "; } if (Session["conntype"].ToString() == "ORACLE") { sql += " and to_char(hy_djsj,'YYYY-MM-DD')>='" + this.hy_djsj_start_1.Value + "' "; } } if (this.hy_djsj_end_1.Value != "") { if (Session["conntype"].ToString() == "SQL") { sql += " and hy_djsj<='" + this.hy_djsj_end_1.Value + "' "; } if (Session["conntype"].ToString() == "ORACLE") { sql += " and to_char(hy_djsj,'YYYY-MM-DD')<='" + this.hy_djsj_end_1.Value + "' "; } } if (this.hy_bt_1.Value != "") sql += " and hy_bt like '%" + this.hy_bt_1.Value + "%' "; if (this.hy_wh_1.Value != "") sql += " and hy_wh like '%" + this.hy_wh_1.Value + "%' "; if (lstypeid != "") sql += " and hy_typeid = '" + lstypeid + "' "; sql += " order by hy_djsj desc "; DataTable dt = Hyoa_global.GetDataTable(sql); DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("lookfileatt", typeof(String)); //定义新的一列 add tempTable.Columns.Add(col); //追加一列 add 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]; } //fileatt string ls_classnames = ""; //add if (dt.Rows[i]["hy_mudelid"].ToString() == "Mudelfwgl") { string lssqlfwglfile; lssqlfwglfile = "select * from files where fother = '" + dt.Rows[i]["hy_fatherid"].ToString() + "'"; DataTable dtfwglfile = Hyoa_global.GetDataTable(lssqlfwglfile); if (dtfwglfile.Rows.Count > 0) { for (int jfile = 0; jfile < dtfwglfile.Rows.Count; jfile++) { if (ls_classnames == "") { ls_classnames = "<a href='../NTKO/" + dtfwglfile.Rows[jfile]["fpath"].ToString() + "/" + dtfwglfile.Rows[jfile]["fname"].ToString() + "' target=_blank>正文</a>"; } else { ls_classnames += "<br>" + "<a href='../NTKO/" + dtfwglfile.Rows[jfile]["fpath"].ToString() + "/" + dtfwglfile.Rows[jfile]["fname"].ToString() + "' target=_blank>正文</a>"; } } } } HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); DataTable dtfile = new DataTable(); if (dt.Rows[i]["hy_fatherid"].ToString() == "") { dtfile = Hyoa_fileatt.GetfileattByFatherid(dt.Rows[i]["ID"].ToString()); } else { dtfile = Hyoa_fileatt.GetfileattByFatherid(dt.Rows[i]["hy_fatherid"].ToString()); } if (dtfile.Rows.Count > 0) { for (int ifile = 0; ifile < dtfile.Rows.Count; ifile++) { if (ls_classnames == "") { ls_classnames = "<a href='../" + dtfile.Rows[ifile]["hy_filepath"].ToString() + "' target=_blank>" + dtfile.Rows[ifile]["hy_filename"].ToString() + "</a>"; } else { ls_classnames += "<br>" + "<a href='../" + dtfile.Rows[ifile]["hy_filepath"].ToString() + "' target=_blank>" + dtfile.Rows[ifile]["hy_filename"].ToString() + "</a>"; } } } dr["lookfileatt"] = ls_classnames; //将新值赋给相应的列 add tempTable.Rows.Add(dr); } int TotalRecord = dt.Rows.Count; this.sumts.Text = TotalRecord.ToString(); this.sumts2.Text = TotalRecord.ToString(); this.ShowTotalRecord.Text = TotalRecord.ToString(); //计算及显示总页数 int TotalPage; if (TotalRecord < System.Int32.Parse(PageSize.Text)) { TotalPage = 1; } else { if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0) { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1; } else { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text); } } this.ShowTotalPage.Text = TotalPage.ToString(); this.rptlist.DataSource = tempTable; this.rptlist.DataBind(); dt.Clear(); }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("login.aspx"); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Rolescsylc", Session["hyuid"].ToString())) { isdellcrole.Value = "1"; } if (this.Request.QueryString["mid"] != null) { //得到模块ID this.txtmudelid.Value = this.Request.QueryString["mid"].ToString(); } else { this.Response.Write("<script>alert('模块ID没有传入,请联系管理员!');</script>"); return; } if (this.Request.QueryString["tableid"] != null) { //表的ID this.txttableid.Value = this.Request.QueryString["tableid"].ToString(); //得到表名 HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.txttableid.Value); if (dt_tableconfig.Rows.Count > 0) this.lblcurtachenameshow.Text = dt_tableconfig.Rows[0]["hy_name"].ToString(); } else { this.Response.Write("<script>alert('表单ID没有传入,请联系管理员!');</script>"); return; } if (this.Request.QueryString["listid"] != null) { //得到列表ID if (this.Request.QueryString["listid"].ToString() != "") { this.txtlistid.Value = this.Request.QueryString["listid"].ToString(); } } else { this.Response.Write("<script>alert('列表ID没有传入,请联系管理员!');</script>"); return; } //判断是否需要查询 HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig(); DataTable dt_listconfig = Hyoa_listconfig.Getlistconfig(this.txtlistid.Value); if (dt_listconfig.Rows.Count > 0) { if (dt_listconfig.Rows[0]["hy_ifsearch"].ToString() == "是") GetSearchTableHtml();//查询表格动态生成 } if (!IsPostBack) { DataPlay(1); //列表区动态生成 PageListItem(); EnabledWhatButton(); } }
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(); //判断当前用户是否有删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.tddeldoc.Visible = true; } else { this.isrole.Value = "0"; this.tddeldoc.Visible = false; } //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.DAO db = new HyoaClass.DAO(); //已流转完成的工作月汇报 string sql = ""; sql = "select * from hyp_flowmain where hy_mudelid='" + this.txtmudelid.Value + "' and hy_tableid='" + this.txttableid.Value + "' and hy_curtacheid='**' "; if (this.hy_djsj_start_1.Value != "") sql += " and hy_djsj>='" + this.hy_djsj_start_1.Value + "' "; if (this.hy_djsj_end_1.Value != "") sql += " and hy_djsj<='" + this.hy_djsj_end_1.Value + "' "; if (this.hy_djrname_1.Value != "") sql += " and hy_djrname like '%" + this.hy_djrname_1.Value + "%' "; if (this.hy_djrbmname_1.Value != "") sql += " and hy_djrbmname like '%" + this.hy_djrbmname_1.Value + "%' "; sql += " order by hy_djsj desc "; DataTable dt = db.GetDataTable(sql); 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(); }
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; //保存 } //新文档 if (this.Request.QueryString["op"] == "add") { if (this.hy_deptid.Text != "") { //根据部门ID得到部门名称 HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dtdept = Hyoa_dept.Getdept(this.hy_deptid.Text); if (dtdept.Rows.Count > 0) this.hy_deptname.Text = dtdept.Rows[0]["hy_deptname"].ToString(); this.ddlifleader.Items.Insert(0, "否"); this.ddlifleader.Items.Insert(1, "是"); this.ddlisenabled.Items.Insert(0, "是"); this.ddlisenabled.Items.Insert(1, "否"); this.ddlxb.Items.Insert(0, "--请选择--"); this.ddlxb.Items.Insert(1, "男"); this.ddlxb.Items.Insert(2, "女"); dtdept.Clear(); } } //旧文档 if (this.Request.QueryString["op"] == "modify") { if (this.Request.QueryString["userid"] != null) { this.ddlifleader.Items.Insert(0, "否"); this.ddlifleader.Items.Insert(1, "是"); this.ddlisenabled.Items.Insert(0, "是"); this.ddlisenabled.Items.Insert(1, "否"); this.ddlxb.Items.Insert(0, "--请选择--"); this.ddlxb.Items.Insert(1, "男"); this.ddlxb.Items.Insert(2, "女"); //根据用户ID得到信息 this.txtuserid.Text = this.Request.QueryString["userid"].ToString(); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); HyoaClass.Hyoa_user_detail Hyoa_user_detail = new HyoaClass.Hyoa_user_detail(); DataTable dtuser = Hyoa_user.Getuserallinfo(this.txtuserid.Text); if (dtuser.Rows.Count > 0) { this.txtusername.Value = dtuser.Rows[0]["hy_username"].ToString(); this.hy_deptid.Text = dtuser.Rows[0]["hy_deptid"].ToString(); this.hy_deptname.Text = dtuser.Rows[0]["hy_deptname"].ToString(); this.txtposition.Value = dtuser.Rows[0]["hy_post"].ToString(); if (dtuser.Rows[0]["hy_ifleader"].ToString() == "是") this.ddlifleader.SelectedIndex = 1; else this.ddlifleader.SelectedIndex = 0; this.txtofficetel.Value = dtuser.Rows[0]["hy_officetel"].ToString(); this.txthometel.Value = dtuser.Rows[0]["hy_hometel"].ToString(); this.txtmobile.Value = dtuser.Rows[0]["hy_mobile"].ToString(); this.txtvirtualtel.Value = dtuser.Rows[0]["hy_virtualnumber"].ToString(); this.txtuserno.Value = dtuser.Rows[0]["hy_sort"].ToString(); if (dtuser.Rows[0]["hy_isenabled"].ToString() == "是") this.ddlisenabled.SelectedIndex = 0; else this.ddlisenabled.SelectedIndex = 1; DataTable dtdetail = Hyoa_user_detail.Getuserdetail(this.txtuserid.Text); if (dtdetail.Rows.Count > 0) { this.txtbirthday.Value = System.DateTime.Parse(dtdetail.Rows[0]["hy_birthday"].ToString()).ToString("yyyy-MM-dd"); this.txtfjh.Value = dtdetail.Rows[0]["hy_fjh"].ToString(); this.ddlxb.SelectedValue = dtdetail.Rows[0]["hy_xb"].ToString(); this.txtzzmm.Value = dtdetail.Rows[0]["hy_zzmm"].ToString(); this.txtxl.Value = dtdetail.Rows[0]["hy_xl"].ToString(); this.txtbyyx.Value = dtdetail.Rows[0]["hy_byyx"].ToString(); if (dtdetail.Rows[0]["hy_jdwsj"].ToString() != "" && dtdetail.Rows[0]["hy_jdwsj"].ToString() != null && dtdetail.Rows[0]["hy_jdwsj"].ToString() != "1900-01-01") this.txtjdwsj.Value = System.DateTime.Parse(dtdetail.Rows[0]["hy_jdwsj"].ToString()).ToShortDateString(); this.txtjtzz.Value = dtdetail.Rows[0]["hy_jtzz"].ToString(); this.txtsfzhm.Value = dtdetail.Rows[0]["hy_sfzhm"].ToString(); } if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { } else { this.txtsfzhm.Value = "您无权查看,如有需要请联系管理员!"; } } dtuser.Clear(); this.txtuserid.Enabled = false; } } } }
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(); }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() =="") this.Response.Redirect("/login.aspx"); if (this.Request.QueryString["mid"] != null) { //得到模块ID this.txtmudelid.Value = this.Request.QueryString["mid"].ToString(); } else { this.Response.Write("<script>alert('模块ID没有传入,请联系管理员!');</script>"); return; } if (this.Request.QueryString["tableid"] != null) { //表的ID this.txttableid.Value = this.Request.QueryString["tableid"].ToString(); //得到表名 HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.txttableid.Value); if (dt_tableconfig.Rows.Count > 0) this.lblcurtachenameshow.Text = dt_tableconfig.Rows[0]["hy_name"].ToString(); } else { this.Response.Write("<script>alert('表单ID没有传入,请联系管理员!');</script>"); return; } if (!IsPostBack) { //判断是否需要查询(目前一个表单只能对应一个列表,所以直接用表单ID进行查找) HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig(); DataTable dt_listconfig = Hyoa_listconfig.GetlistconfigByTableid(this.txttableid.Value); if (dt_listconfig.Rows.Count > 0) { if (dt_listconfig.Rows[0]["hy_ifsearch"].ToString() == "是") GetSearchTableHtml();//查询表格动态生成 } DataPlay(1); //列表区动态生成 PageListItem(); EnabledWhatButton(); if (this.txtmudelid.Value == "kqgl" && this.txttableid.Value == "74e7e280-4fc5-4ccb-be3d-0f995ac2c934") { this.delcontrol_my.Visible = false; this.newcontrol.Visible = false; } if (this.txtmudelid.Value == "clgl" && this.txttableid.Value == "0b5c53fe-114b-4fa3-8b59-4163b3053504") { this.exportexcel.Visible = true; } ///只有管理员岗位能删除(大榭特有) HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { } else { this.delcontrol.Visible = false; this.delcontrol_my.Visible = false; } } }
//输出一个字段 //li_tdnums_onerow:当前行已输出了几列 //li_colnums_show:每行显示几列(标准情况下) //pi_isnewdoc 0:新文档 1:旧文档 //ifhavarole:表单上是否有权限 0:lable输出 1:input输出 //ifflowdoc:是否流程表单 0:非流程 1:流程 //curtacheid:当前环节ID,用于判断字段是否在当前环节有权限 public int GetFieldHtml(TableRow tRow, int li_tdnums_onerow, int li_colnums_show, string hy_fieldid, string pi_isnewdoc, string ifhavarole, string ifflowdoc, string curtacheid) { int li_return = li_tdnums_onerow; string ls_laborinput = "0"; //输出LABLE还是INPUT 0:LABLE 1:INPUT HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); DataTable dtfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.hy_mudelid.Text, hy_fieldid, this.hy_tableid.Text); int li_left = 30; int li_right = 70; if (dtfield.Rows.Count > 0) { string field_type = dtfield.Rows[0]["hy_fieldtype"].ToString(); //字段类型 if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "5") //如果设置了不显示左侧说明文字,则不加载左侧列 { li_return += 1; //插入单元格(左侧) TableCell tCell = new TableCell(); tRow.Cells.Add(tCell); tCell.Width = Unit.Percentage((li_left / li_colnums_show)); tCell.Height = Unit.Pixel(30); tCell.CssClass = "Tdcellleft"; tCell.HorizontalAlign = HorizontalAlign.Center; tCell.Controls.Add(new LiteralControl(dtfield.Rows[0]["hy_fieldname"].ToString())); } else { li_left = 50; li_right = 50; } //插入单元格(右侧) TableCell tCell2 = new TableCell(); tRow.Cells.Add(tCell2); tCell2.Width = Unit.Percentage((li_right / li_colnums_show)); tCell2.Height = Unit.Pixel(30); tCell2.CssClass = "Tdcellright"; if (dtfield.Rows[0]["hy_align"].ToString() == "left") { tCell2.HorizontalAlign = HorizontalAlign.Left; } if (dtfield.Rows[0]["hy_align"].ToString() == "center") { tCell2.HorizontalAlign = HorizontalAlign.Center; } if (dtfield.Rows[0]["hy_align"].ToString() == "right") { tCell2.HorizontalAlign = HorizontalAlign.Right; } tCell2.ColumnSpan = int.Parse(dtfield.Rows[0]["hy_tdnums"].ToString()); li_return += int.Parse(dtfield.Rows[0]["hy_tdnums"].ToString()); //赋值(新文档取配置的默认值,旧文档取数据库表中的值) string field_docvalue = ""; if (pi_isnewdoc == "0") //新文档 { if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() != "-1") { if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "0") { field_docvalue = dtfield.Rows[0]["hy_defaultvalue"].ToString(); //手工配置 } if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "1") { DataTable dt_getfieldvalue = Hyoa_global.GetDataTable(dtfield.Rows[0]["hy_defaultvalue"].ToString()); field_docvalue = dt_getfieldvalue.Rows[0][0].ToString(); //SQL语句 } if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "2") { field_docvalue = Session[dtfield.Rows[0]["hy_defaultvalue"].ToString()].ToString(); //SESSION } if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "3") { if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd") field_docvalue = System.DateTime.Now.ToString("yyyy-MM-dd"); //当前时间 else field_docvalue = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //当前时间 } if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "4") { //自动生成 if (dtfield.Rows[0]["hy_fieldtype"].ToString() == "数值") { //得到目前最大的数值,然后+1,未找到则赋值为1 DataTable dt_autovalue = Hyoa_global.GetDataTable("select max(hyc_" + hy_fieldid + ") maxint from hyc_" + this.hy_tableid.Text); if (dt_autovalue.Rows[0]["maxint"].ToString() == null || dt_autovalue.Rows[0]["maxint"].ToString() == "") field_docvalue += "1"; else field_docvalue += (System.Int32.Parse(dt_autovalue.Rows[0]["maxint"].ToString()) + 1).ToString(); } else { field_docvalue += System.Guid.NewGuid().ToString(); } } if (dtfield.Rows[0]["hy_defaultvaluetype"].ToString() == "5") { field_docvalue += dtfield.Rows[0]["hy_defaultvalue"].ToString(); } } } else { if (field_type == "文本" || field_type == "多行文本" || field_type == "多行文本_TEXT" || field_type == "文本加按钮" || field_type == "多行文本加按钮" || field_type == "日期" || field_type == "数值" || field_type == "对话框列表" || field_type == "复选框" || field_type == "单选框" || field_type == "口令" || field_type == "编辑器") { string ls_sql = "select hyc_" + hy_fieldid + " from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "'"; DataTable dt_getdocvalue = Hyoa_global.GetDataTable(ls_sql); if (dt_getdocvalue.Rows.Count > 0) { field_docvalue = dt_getdocvalue.Rows[0][0].ToString(); if (field_type == "日期") { if (field_docvalue.Length > 8) { if (field_docvalue.Substring(0, 8) == "1900-1-1") { field_docvalue = " "; } else { if (dtfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd") { field_docvalue = System.DateTime.Parse(field_docvalue).ToString("yyyy-MM-dd"); } } } } } } if (field_type == "说明文字") { field_docvalue += dtfield.Rows[0]["hy_defaultvalue"].ToString(); } if (field_type == "意见加按钮") { HyoaClass.Hyoa_yj Hyoa_yj = new HyoaClass.Hyoa_yj(); DataTable dt_yj = Hyoa_yj.Getyjsbydocidandfieldid_sx(this.txtdocid.Value, hy_fieldid); if (dt_yj.Rows.Count > 0) { field_docvalue = ""; for (int ii = 0; ii < dt_yj.Rows.Count; ii++) { field_docvalue += dt_yj.Rows[ii]["hy_yjbody"].ToString() + "(" + dt_yj.Rows[ii]["hy_yjusername"].ToString() + " " + System.DateTime.Parse(dt_yj.Rows[ii]["hy_yjtime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + ")<br/>"; } } } } //判断是输出LABL还是INPUT if (pi_isnewdoc == "0") //新文档 { if (ifhavarole == "1") //有权限 { //有流程(判断当前环节这个字段是否有权限) HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield(); ls_laborinput = Hyoa_flowtachefield.IfHaveRolebyflowidandtacheidandfieldid(hy_flowid.Text, curtacheid, hy_fieldid); if (ls_laborinput == "0") { field_docvalue = ""; } } else { field_docvalue = ""; } } else //旧文档 { if (ifhavarole == "1") //有权限 { //有流程(判断当前环节这个字段是否有权限) HyoaClass.Hyoa_flowtachefield Hyoa_flowtachefield = new HyoaClass.Hyoa_flowtachefield(); ls_laborinput = Hyoa_flowtachefield.IfHaveRolebyflowidandtacheidandfieldid(hy_flowid.Text, curtacheid, hy_fieldid); //如果流程结束了,则输出lable if (hy_curtacheid.Text == "**") { ls_laborinput = "0"; } if (ls_laborinput == "1") { //如果当前字段中文名为“结束流程按钮”,则这个字段主要用于收文中阅件时,可点击这个按钮结束流程,用于控制这个按钮的隐藏和显示 if (dtfield.Rows[0]["hy_fieldname"].ToString() == "结束流程按钮") { td_flowend.Visible = true; } } } //如果是“可修改所有文档的权限人员”,则可以修改所有的字段 if (Hyoa_global.isHaveRole("Role9995", Session["hyuid"].ToString())) { ls_laborinput = "1"; } } //如果是输出LABLE,值为空则赋为 不为空时需要转换回车和空格 if (ls_laborinput == "0") { if (field_docvalue == "") { field_docvalue = " "; } else { if (field_type != "编辑器") { field_docvalue = RtfToText(field_docvalue); } } } //单行文本 if (field_type == "文本") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "") { txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "") { txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString()); } if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "") { txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString()); } if (dtfield.Rows[0]["hy_onfocus"].ToString() != "") { txtTextBox.Attributes.Add("onfocus", dtfield.Rows[0]["hy_onfocus"].ToString()); } if (dtfield.Rows[0]["hy_onblur"].ToString() != "") { txtTextBox.Attributes.Add("onblur", dtfield.Rows[0]["hy_onblur"].ToString()); } if (dtfield.Rows[0]["hy_wordlimit"].ToString() != "") { txtTextBox.MaxLength = System.Int32.Parse((System.Int32.Parse(dtfield.Rows[0]["hy_wordlimit"].ToString()) / 2).ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "0"); } } //多行文本 if (field_type == "多行文本") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.TextMode = TextBoxMode.MultiLine; txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "") { txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "") { txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString()); } if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "") { txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString()); } if (dtfield.Rows[0]["hy_onfocus"].ToString() != "") { txtTextBox.Attributes.Add("onfocus", dtfield.Rows[0]["hy_onfocus"].ToString()); } if (dtfield.Rows[0]["hy_onblur"].ToString() != "") { txtTextBox.Attributes.Add("onblur", dtfield.Rows[0]["hy_onblur"].ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "0"); } } //多行文本_TEXT if (field_type == "多行文本_TEXT") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.TextMode = TextBoxMode.MultiLine; txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "") { txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "") { txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString()); } if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "") { txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString()); } if (dtfield.Rows[0]["hy_onfocus"].ToString() != "") { txtTextBox.Attributes.Add("onfocus", dtfield.Rows[0]["hy_onfocus"].ToString()); } if (dtfield.Rows[0]["hy_onblur"].ToString() != "") { txtTextBox.Attributes.Add("onblur", dtfield.Rows[0]["hy_onblur"].ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "0"); } } //按钮 if (field_type == "按钮") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = " "; tCell2.Controls.Add(txtTextBox); } else { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value='" + dtfield.Rows[0]["hy_fieldname"].ToString() + "' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />"; txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } } //一直显示的按钮 if (field_type == "一直显示的按钮") { //-----开始输出字段------ Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value='" + dtfield.Rows[0]["hy_fieldname"].ToString() + "' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />"; txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } //日期 if (field_type == "日期") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "") { txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "") { txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString()); } if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "") { txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString()); } if (dtfield.Rows[0]["hy_onfocus"].ToString() != "") { txtTextBox.Attributes.Add("onfocus", dtfield.Rows[0]["hy_onfocus"].ToString()); } if (dtfield.Rows[0]["hy_onblur"].ToString() != "") { txtTextBox.Attributes.Add("onblur", dtfield.Rows[0]["hy_onblur"].ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "1"); } } //文本加按钮 if (field_type == "文本加按钮") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } txtTextBox.Width = Unit.Parse("60%"); if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_wordlimit"].ToString() != "") { txtTextBox.MaxLength = System.Int32.Parse((System.Int32.Parse(dtfield.Rows[0]["hy_wordlimit"].ToString()) / 2).ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); Label txtTextBox2 = new Label(); txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />"; txtTextBox2.Text = field_docvalue; tCell2.Controls.Add(txtTextBox2); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "0"); } } //多行文本加按钮 if (field_type == "多行文本加按钮") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.TextMode = TextBoxMode.MultiLine; txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); Label txtTextBox2 = new Label(); txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" />"; txtTextBox2.Text = field_docvalue; tCell2.Controls.Add(txtTextBox2); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "0"); } } //意见加按钮 if (field_type == "意见加按钮") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { Label txtTextBox_show = new Label(); txtTextBox_show.ID = dtfield.Rows[0]["hy_fieldid"].ToString() + "_show"; txtTextBox_show.Text = field_docvalue; tCell2.Controls.Add(txtTextBox_show); TextBox txtTextBox = new TextBox(); txtTextBox.TextMode = TextBoxMode.MultiLine; txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } //txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); Label txtTextBox2 = new Label(); txtTextBox2.ID = "span_" + dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "' value=' 选 择 ' class=btn3 onclick=\"" + dtfield.Rows[0]["hy_onclick"].ToString() + "\" /><input type=button id='btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "_cz' value=' 重 置 ' class=btn3 onclick=\"document.getElementById('" + dtfield.Rows[0]["hy_fieldid"].ToString() + "').value='';\" />"; txtTextBox2.Text = field_docvalue; tCell2.Controls.Add(txtTextBox2); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "9"); } } //数值 if (field_type == "数值") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "") { txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "") { txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString()); } if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "") { txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString()); } if (dtfield.Rows[0]["hy_onfocus"].ToString() != "") { txtTextBox.Attributes.Add("onfocus", dtfield.Rows[0]["hy_onfocus"].ToString()); } if (dtfield.Rows[0]["hy_onblur"].ToString() != "") { txtTextBox.Attributes.Add("onblur", dtfield.Rows[0]["hy_onblur"].ToString()); } //if (dtfield.Rows[0]["hy_wordlimit"].ToString() != "") //{ // txtTextBox.MaxLength = System.Int32.Parse((System.Int32.Parse(dtfield.Rows[0]["hy_wordlimit"].ToString())).ToString()); //} txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "3"); } } //对话框列表(下拉框 if (field_type == "对话框列表") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { DropDownList ddlDropDownList = new DropDownList(); ddlDropDownList.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_class"].ToString() != "") { ddlDropDownList.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { ddlDropDownList.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { ddlDropDownList.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0") { //手工配置 if (dtfield.Rows[0]["hy_options"].ToString() != "") { string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#'); for (int i = 0; i < lv_options.Length; i++) { ddlDropDownList.Items.Add(lv_options[i].ToString()); } } } if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1") { //SQL语句 if (dtfield.Rows[0]["hy_options"].ToString() != "") { //如果SQL语句中含有特殊标示,则需要替换 string ls_sql = dtfield.Rows[0]["hy_options"].ToString(); if (ls_sql.Contains("用户ID")) { ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'"); } if (ls_sql.Contains("用户名")) { ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'"); } if (ls_sql.Contains("部门ID")) { ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'"); } if (ls_sql.Contains("部门名")) { ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'"); } DataTable dt_options = Hyoa_global.GetDataTable(ls_sql); ddlDropDownList.DataSource = dt_options; ddlDropDownList.DataTextField = dt_options.Columns[0].ColumnName; ddlDropDownList.DataValueField = dt_options.Columns[0].ColumnName; ddlDropDownList.DataBind(); } } ddlDropDownList.Items.Insert(0, new ListItem("--请选择--", "")); ddlDropDownList.SelectedValue = field_docvalue; tCell2.Controls.Add(ddlDropDownList); //插入字段:共有哪几个查询条件 addsavefields(hy_fieldid, "0"); } } //复选框(查询时直接显示文本框) if (field_type == "复选框") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { CheckBoxList txtTextBox = new CheckBoxList(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0") { //手工配置 if (dtfield.Rows[0]["hy_options"].ToString() != "") { string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#'); for (int i = 0; i < lv_options.Length; i++) { txtTextBox.Items.Add(lv_options[i].ToString()); } } } if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1") { //SQL语句 //如果SQL语句中含有特殊标示,则需要替换 string ls_sql = dtfield.Rows[0]["hy_options"].ToString(); if (ls_sql.Contains("用户ID")) { ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'"); } if (ls_sql.Contains("用户名")) { ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'"); } if (ls_sql.Contains("部门ID")) { ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'"); } if (ls_sql.Contains("部门名")) { ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'"); } if (dtfield.Rows[0]["hy_options"].ToString() != "") { DataTable dt_options = Hyoa_global.GetDataTable(ls_sql); txtTextBox.DataSource = dt_options; txtTextBox.DataTextField = dt_options.Columns[0].ColumnName; txtTextBox.DataValueField = dt_options.Columns[0].ColumnName; txtTextBox.DataBind(); } } if (field_docvalue != "") { field_docvalue = "," + field_docvalue + ","; foreach (ListItem li in txtTextBox.Items) { if (field_docvalue.Contains(li.Value)) li.Selected = true; } } tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "7"); } } //单选框(查询时直接显示文本框) if (field_type == "单选框") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { RadioButtonList txtTextBox = new RadioButtonList(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_optiontype"].ToString() == "0") { //手工配置 if (dtfield.Rows[0]["hy_options"].ToString() != "") { string[] lv_options = dtfield.Rows[0]["hy_options"].ToString().Split('#'); for (int i = 0; i < lv_options.Length; i++) { txtTextBox.Items.Add(lv_options[i].ToString()); } } } if (dtfield.Rows[0]["hy_optiontype"].ToString() == "1") { //SQL语句 //如果SQL语句中含有特殊标示,则需要替换 string ls_sql = dtfield.Rows[0]["hy_options"].ToString(); if (ls_sql.Contains("用户ID")) { ls_sql = ls_sql.Replace("用户ID", "'" + Session["hyuid"].ToString() + "'"); } if (ls_sql.Contains("用户名")) { ls_sql = ls_sql.Replace("用户名", "'" + Session["hyuname"].ToString() + "'"); } if (ls_sql.Contains("部门ID")) { ls_sql = ls_sql.Replace("部门ID", "'" + Session["hydeptid"].ToString() + "'"); } if (ls_sql.Contains("部门名")) { ls_sql = ls_sql.Replace("部门名", "'" + Session["hydeptname"].ToString() + "'"); } if (dtfield.Rows[0]["hy_options"].ToString() != "") { DataTable dt_options = Hyoa_global.GetDataTable(ls_sql); txtTextBox.DataSource = dt_options; txtTextBox.DataTextField = dt_options.Columns[0].ColumnName; txtTextBox.DataValueField = dt_options.Columns[0].ColumnName; txtTextBox.DataBind(); } } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "8"); } } //口令 if (field_type == "口令") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = " "; tCell2.Controls.Add(txtTextBox); } else { TextBox txtTextBox = new TextBox(); txtTextBox.TextMode = TextBoxMode.Password; txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (dtfield.Rows[0]["hy_ifreadonly"].ToString() == "是") { txtTextBox.ReadOnly = true; } if (dtfield.Rows[0]["hy_class"].ToString() != "") { txtTextBox.CssClass = dtfield.Rows[0]["hy_class"].ToString(); } if (dtfield.Rows[0]["hy_width"].ToString() != "") { txtTextBox.Width = Unit.Parse(dtfield.Rows[0]["hy_width"].ToString()); } if (dtfield.Rows[0]["hy_height"].ToString() != "") { txtTextBox.Height = Unit.Parse(dtfield.Rows[0]["hy_height"].ToString()); } if (dtfield.Rows[0]["hy_onclick"].ToString() != "") { txtTextBox.Attributes.Add("onclick", dtfield.Rows[0]["hy_onclick"].ToString()); } if (dtfield.Rows[0]["hy_ondblclick"].ToString() != "") { txtTextBox.Attributes.Add("ondblclick", dtfield.Rows[0]["hy_ondblclick"].ToString()); } if (dtfield.Rows[0]["hy_onchange"].ToString() != "") { txtTextBox.Attributes.Add("onchange", dtfield.Rows[0]["hy_onchange"].ToString()); } if (dtfield.Rows[0]["hy_onkeydown"].ToString() != "") { txtTextBox.Attributes.Add("onkeydown", dtfield.Rows[0]["hy_onkeydown"].ToString()); } if (dtfield.Rows[0]["hy_onkeyup"].ToString() != "") { txtTextBox.Attributes.Add("onkeyup", dtfield.Rows[0]["hy_onkeyup"].ToString()); } if (dtfield.Rows[0]["hy_onfocus"].ToString() != "") { txtTextBox.Attributes.Add("onfocus", dtfield.Rows[0]["hy_onfocus"].ToString()); } if (dtfield.Rows[0]["hy_onblur"].ToString() != "") { txtTextBox.Attributes.Add("onblur", dtfield.Rows[0]["hy_onblur"].ToString()); } if (dtfield.Rows[0]["hy_wordlimit"].ToString() != "") { txtTextBox.MaxLength = System.Int32.Parse((System.Int32.Parse(dtfield.Rows[0]["hy_wordlimit"].ToString())).ToString()); } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "5"); } } //附件组件 if (field_type == "附件组件") { //读取附件内容 HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatheridandFatherfield(this.txtdocid.Value, hy_fieldid); field_docvalue = ""; if (dt_fileatt.Rows.Count > 0) { for (var ii = 0; ii < dt_fileatt.Rows.Count; ii++) { field_docvalue += (ii + 1).ToString() + "、<a href=\"" + dt_fileatt.Rows[ii]["hy_filepath"].ToString() + "\" target=_blank>" + dt_fileatt.Rows[ii]["hy_filename"].ToString() + "</a><br />"; } } //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); if (field_docvalue == "") { field_docvalue = " "; } txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<span id=\"fjinfoshow_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\">" + field_docvalue + "</span>"; field_docvalue += "<input type=button id='uploadfile1' value='附件管理' class=btn3 onclick=\"window.open('ggdy/main_fileatt.aspx?fatherid=" + this.txtdocid.Value + "&fatherfield=" + hy_fieldid + "','filewindow','height=350,width=600,top=100,left=200,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no');\" />"; txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } } //说明文字 if (field_type == "说明文字") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } } //编辑器 if (field_type == "编辑器") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { //隐藏文本框 TextBox txtTextBox = new TextBox(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; txtTextBox.Style.Value = "display:none"; tCell2.Controls.Add(txtTextBox); //编辑器 Label txtTextBox2 = new Label(); txtTextBox2.ID = "eWebEditor" + dtfield.Rows[0]["hy_fieldid"].ToString(); field_docvalue = "<iframe ID=\"eWebEditor" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"system/eWebEditor/ewebeditor.htm?id=" + dtfield.Rows[0]["hy_fieldid"].ToString() + "&style=Portal\" frameborder=0 scrolling=no width=" + dtfield.Rows[0]["hy_width"].ToString() + " height=" + dtfield.Rows[0]["hy_height"].ToString() + "></iframe>"; txtTextBox2.Text = field_docvalue; tCell2.Controls.Add(txtTextBox2); //插入字段:共有哪几个INPUT字段 addsavefields(hy_fieldid, "6"); } } //痕迹保留 if (field_type == "痕迹保留") { string ls_btnname = ""; HyoaClass.Hyoa_ntko Hyoa_ntko = new HyoaClass.Hyoa_ntko(); DataTable dt_ntko = Hyoa_ntko.GetntkofileByfother(this.txtdocid.Value); if (dt_ntko.Rows.Count > 0) { ls_btnname = "正文:" + this.hy_bt.Text; } else { ls_btnname = "<span id='ntko_wsc'>未上传正文,请点击上传!</span>"; } //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { //field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='" + ls_btnname + "' class=btn3 onclick=\"window.open('ntko/readoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> "; field_docvalue = "<a href=\"#\" onclick=\"window.open('ntko/readoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\">" + ls_btnname + "</a> "; Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { //field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='" + ls_btnname + "' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> "; field_docvalue = "<a href=\"#\" onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\">" + ls_btnname + "</a> "; //如果是流程模块,则根据环节判断一下 if (ifflowdoc == "1") { //判断是否为第一环节 HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, "*"); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == this.hy_curtacheid.Text) { //field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='" + ls_btnname + "' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> "; field_docvalue = "<a href=\"#\" onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=1&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\">" + ls_btnname + "</a> "; } else { //判断是否为最后一个环节 dtflowwork.Clear(); dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**") { //field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='" + ls_btnname + "' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> "; field_docvalue = "<a href=\"#\" onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=1&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\">" + ls_btnname + "</a> "; } else { //field_docvalue = "<input type=button id=\"btn_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" value='" + ls_btnname + "' class=btn3 onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\" /> "; field_docvalue = "<a href=\"#\" onclick=\"window.open('ntko/editoffice.aspx?newofficetype=1&fatherid=" + this.txtdocid.Value + "&tableid=" + this.hy_tableid.Text + "&tacheByhj=0&jsxd=0&rnd='+Math.random(),'hjblwindow','height=768,width=1024,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no');\">" + ls_btnname + "</a> "; } } } } } Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } } //IFRAME列表 if (field_type == "IFRAME列表") { //-----开始输出字段------ if (ls_laborinput == "0") //输出LABLE { field_docvalue = "<iframe id=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" name=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"" + dtfield.Rows[0]["hy_defaultvalue"].ToString() + "&motherid=" + this.txtdocid.Value + "&ishaverole=0\" frameborder=\"0\" scrolling=\"yes\" height=\"80px\" width=\"98%\"></iframe>"; Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } else { field_docvalue = "<iframe id=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" name=\"ifr_" + dtfield.Rows[0]["hy_fieldid"].ToString() + "\" src=\"" + dtfield.Rows[0]["hy_defaultvalue"].ToString() + "&motherid=" + this.txtdocid.Value + "&ishaverole=1\" frameborder=\"0\" scrolling=\"yes\" height=\"80px\" width=\"98%\"></iframe>"; Label txtTextBox = new Label(); txtTextBox.ID = dtfield.Rows[0]["hy_fieldid"].ToString(); txtTextBox.Text = field_docvalue; tCell2.Controls.Add(txtTextBox); } } //子表信息带链接 //子表信息不带链接 } return li_return; }
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 (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.delcontrol.Visible = true; this.newcontrol.Visible = true; } else { this.isrole.Value = "0"; this.newcontrol.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 (this.txttableid.Value == "Tablefpbd") { cmdStr_Search += " and hyc_sfbf <> '1' "; } if (txtsearchfields.Text != "") { string[] lv_searchfields = txtsearchfields.Text.Split(','); string[] lv_searchfields_sx = txtsearchfields_sx.Text.Split(','); for (int i = 0; i < lv_searchfields.Length; i++) { string ls_fieldid = lv_searchfields[i].ToString(); string ls_fieldid_sx = lv_searchfields_sx[i].ToString(); string ls_searchtext = ""; if (this.Request.Form[ls_fieldid] != null) { ls_searchtext = this.Request.Form[ls_fieldid].ToString(); } if (ls_searchtext != "") { if (ls_fieldid_sx == "0") { cmdStr_Search += " and hyc_" + ls_fieldid + " like '%" + ls_searchtext + "%' "; } else { if (ls_fieldid_sx == "1") { if (Session["conntype"].ToString() == "SQL") { cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) >= '" + ls_searchtext + "' "; } if (Session["conntype"].ToString() == "ORACLE") { cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') >= '" + ls_searchtext + "' "; } } if (ls_fieldid_sx == "2") { if (Session["conntype"].ToString() == "SQL") { cmdStr_Search += " and left(CONVERT(varchar, hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ", 120 ) ,10) <= '" + ls_searchtext + "' "; } if (Session["conntype"].ToString() == "ORACLE") { cmdStr_Search += " and to_char(hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + ",'YYYY-MM-DD') <= '" + ls_searchtext + "' "; } } if (ls_fieldid_sx == "3") { cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " >= " + ls_searchtext + " "; } if (ls_fieldid_sx == "4") { cmdStr_Search += " and hyc_" + ls_fieldid.Substring(0, ls_fieldid.Length - 2) + " <= " + ls_searchtext + " "; } } } } } //---查询条件---结束 //---排序---开始 string cmdStr_SearchSort = ""; if (dtlist.Rows[0]["hy_sortfield1"].ToString() != "") { if (cmdStr_SearchSort == "") { cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString(); } else { cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield1"].ToString() + " " + dtlist.Rows[0]["hy_sorttype1"].ToString(); } } if (dtlist.Rows[0]["hy_sortfield2"].ToString() != "") { if (cmdStr_SearchSort == "") { cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString(); } else { cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield2"].ToString() + " " + dtlist.Rows[0]["hy_sorttype2"].ToString(); } } if (dtlist.Rows[0]["hy_sortfield3"].ToString() != "") { if (cmdStr_SearchSort == "") { cmdStr_SearchSort = " order by hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString(); } else { cmdStr_SearchSort += " ,hyc_" + dtlist.Rows[0]["hy_sortfield3"].ToString() + " " + dtlist.Rows[0]["hy_sorttype3"].ToString(); } } if (this.txtfieldid.Value != "" && this.txtfieldsort.Value != "") { cmdStr_SearchSort = " order by hyc_" + this.txtfieldid.Value + " " + this.txtfieldsort.Value + " "; } if (cmdStr_SearchSort == "") { //没有配置,则默认按登记日期 cmdStr_SearchSort = " order by hy_djsj desc "; } //---排序---结束 //--根据查询条件得到返回数据集--s DataTable dt = new DataTable(); //单页数据集 DataTable dt_total = new DataTable(); //数据总条数,返回总条数值 DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc string cmdStr = ""; string ls_from = ""; if (Session["conntype"].ToString() == "SQL") { //edited by xf 20140625 ls_from = " hyc_" + this.txttableid.Value + " a where (a.hy_clrylist like '%," + Session["hyuid"].ToString() + ",%' or a.hy_cyrylist like '%," + Session["hyuid"].ToString() + ",%') and a.hy_curtacheid<>'**' " + cmdStr_Search; cmdStr = "select distinct top " + PageSize.Text + " a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from; cmdStr += " and a.DOCID not in (select top " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString() + " a.DOCID from " + ls_from + cmdStr_SearchSort + ") " + cmdStr_SearchSort; } if (Session["conntype"].ToString() == "ORACLE") { cmdStr = " select * from ( "; cmdStr += " select my_table.*, rownum as my_rownum from "; cmdStr += " ( "; cmdStr += " select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid"; cmdStr += ",a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj"; cmdStr += ",a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from hyc_" + this.txttableid.Value + " a,hyp_flowhistoryinfo_cl b where a.DOCID=b.DOCID "; cmdStr += " and (CONCAT(CONCAT(',',b.hy_clrid),',') like '%," + Session["hyuid"].ToString() + ",%' or CONCAT(CONCAT(',',b.hy_cyrid),',') like '%," + Session["hyuid"].ToString(); cmdStr += ",%') and a.hy_curtacheid<>'**' and (b.hy_ifth!='是' or b.hy_ifth is null) " + cmdStr_Search + cmdStr_SearchSort; cmdStr += " ) my_table "; cmdStr += " where rownum<= " + ((PageNo) * int.Parse(PageSize.Text)).ToString(); cmdStr += " ) where my_rownum> " + ((PageNo - 1) * int.Parse(PageSize.Text)).ToString(); } dt = Hyoa_global.GetDataTable(cmdStr); if (Session["conntype"].ToString() == "SQL") { cmdStr = "select count(*) from (select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid,a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt,a.hy_iftx,a.hy_zhtxsj,a.hy_motherid,a.hy_ifconfirm" + ls_flowfield + " from " + ls_from + " ) f"; } if (Session["conntype"].ToString() == "ORACLE") { cmdStr = "select count(*) from (select distinct a.DOCID from hyc_" + this.txttableid.Value + " a,hyp_flowhistoryinfo_cl b where a.DOCID=b.DOCID "; cmdStr += " and (CONCAT(CONCAT(',',b.hy_clrid),',') like '%," + Session["hyuid"].ToString() + ",%' or CONCAT(CONCAT(',',b.hy_cyrid),',') like '%," + Session["hyuid"].ToString(); cmdStr += ",%') and a.hy_curtacheid<>'**' and (b.hy_ifth!='是' or b.hy_ifth is null) " + cmdStr_Search; cmdStr += ")"; } dt_total = Hyoa_global.GetDataTable(cmdStr); //--根据查询条件得到返回数据集--e //开始输出----整合成HTML为数据行 DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("displaycol", typeof(String)); //定义新的一列 add tempTable.Columns.Add(col); //追加一列 add string lscolname = ""; string lscolnameid = ""; string lscolwidth = ""; string ls_col = ""; string[] lvcolname; string[] lvcolnameid; string[] lvcolwidth; string lscolwidthper; lscolname = dtlist.Rows[0]["hy_columnshow"].ToString(); //要显示的列名:附件,标题,收文来源 lscolnameid = dtlist.Rows[0]["hy_columnshowid"].ToString(); //要显示的列名id:uploadfile1,Hy_bt,Hy_swly lscolwidth = dtlist.Rows[0]["hy_width"].ToString(); //要显示的列名id:10,20,30 lvcolname = lscolname.Split(','); lvcolnameid = lscolnameid.Split(','); lvcolwidth = lscolwidth.Split(','); if (dt.Rows.Count <= 0) { //如果没有数据则输出表头 for (int n = 0; n < lvcolname.Length; n++) { if (n >= lvcolwidth.Length) { lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时,会溢出报错。 else { lscolwidthper = lvcolwidth[n]; } this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[n] + "</td>"; } } for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = tempTable.NewRow(); //输出主表所有字段,start for (int j = 0; j < dt.Columns.Count; j++) { dr[dt.Columns[j].ColumnName] = dt.Rows[i][j]; } //输出主表所有字段,end //////开始得到列的值 DataTable dtgetsqlfield; for (int m = 0; m < lvcolname.Length; m++) { //如果有数据,则输出数据 if (m >= lvcolwidth.Length) { lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时,会溢出报错。 else { lscolwidthper = lvcolwidth[m]; } dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lvcolnameid[m], this.txttableid.Value); if (i % System.Int32.Parse(PageSize.Text) == 0) this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" title=\"点击可排序\" onclick=\"fun_sort('" + lvcolnameid[m] + "');\">" + lvcolname[m] + "</a></p></td>"; //根据字段英文名,得到数据库中对应的字段 string lsgetsqlfield = "hyc_" + dtgetsqlfield.Rows[0]["hy_fieldid"].ToString(); //根据数据库中对应的字段,得到输出字段的值start (日期型根据格式进行了转换) string lsgetputfiled = ""; if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd") { if (dt.Rows[i][lsgetsqlfield].ToString() != "") lsgetputfiled = System.DateTime.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToShortDateString(); } else { //解决Float小数点后面出现N位小数乱码的问题 if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "数值") { if (dt.Rows[i][lsgetsqlfield].ToString() != "") { //是否包含小数点,包含的话,取小数点后两位 if (dt.Rows[i][lsgetsqlfield].ToString().Contains(".") == true) { lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString("F2"); } else { lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString(); } } else { lsgetputfiled = "0"; } //lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString(); } else { lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString(); } } if (lsgetputfiled == "") lsgetputfiled = " "; //根据得到的SQL字段,得到输出字段的值end if (dtgetsqlfield.Rows[0]["hy_ifdbsybt"].ToString() == "是") { ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\"><a href=\"#\" onclick=\"var ss='main.aspx?op=modify&mid=" + dt.Rows[i]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[i]["hy_tableid"].ToString() + "&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url='+window.location;window.location=ss;\">" + lsgetputfiled + "</a></td>"; } else { ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>"; } } //如果是流程表单,则最后追加两列(当前环节和当前处理人) //表头 if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null && i == 0) { this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前环节</td>"; this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前处理人</td>"; } //数据 if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null) { ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curtachename"].ToString() + " </td>"; ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curclrname"].ToString() + " </td>"; } dr["displaycol"] = ls_col; //将新值赋给相应的列 add ls_col = ""; tempTable.Rows.Add(dr); } int TotalRecord = int.Parse(dt_total.Rows[0][0].ToString()); this.sumts.Text = TotalRecord.ToString(); this.sumts2.Text = TotalRecord.ToString(); this.ShowTotalRecord.Text = TotalRecord.ToString(); //计算及显示总页数 int TotalPage; if (TotalRecord < System.Int32.Parse(PageSize.Text)) { TotalPage = 1; } else { if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0) { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1; } else { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text); } } this.ShowTotalPage.Text = TotalPage.ToString(); this.rptlist.DataSource = tempTable; this.rptlist.DataBind(); dt.Clear(); //列表中的一些特殊处理,都放在这个函数内 DataPlay_Tscl(); }
//条件流程 //根据流程ID和环节ID,得到后续环节,进行身份过滤,JS条件暂不过滤 private void ConditionFlow(string pi_flowid, string pi_tacheid) { this.txtenablecondition.Text = "是"; HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dt = Hyoa_flowwork.Getflowworkbyflowidtacheid(pi_flowid, pi_tacheid); Boolean b_flag = false; //是否加载这个环节的标志位 if (dt.Rows.Count > 0) { for (var i = 0; i < dt.Rows.Count; i++) { b_flag = false; if (dt.Rows[i]["hy_identity_type"] == null || dt.Rows[i]["hy_identity_type"].ToString() == "") { //加载没有设置条件的环节 b_flag = true; } else { //设置了条件,开始判断 if (dt.Rows[i]["hy_identity_type"].ToString() != "" && dt.Rows[i]["hy_identity_id"].ToString() != "") { if (dt.Rows[i]["hy_identity_type"].ToString() == "属于") { if (Hyoa_global.isHaveRole(dt.Rows[i]["hy_identity_id"].ToString(), Session["hyuid"].ToString()) == true) { b_flag = true; } } else { if (Hyoa_global.isHaveRole(dt.Rows[i]["hy_identity_id"].ToString(), Session["hyuid"].ToString()) == false) { b_flag = true; } } } } //开始加载 if (b_flag == true) { ddlnexttache.Items.Add(new ListItem(dt.Rows[i]["hy_nexttachename"].ToString(), dt.Rows[i]["hy_nexttacheid"].ToString())); ddljscondition.Items.Add(new ListItem(dt.Rows[i]["hy_jscondition"].ToString(), dt.Rows[i]["hy_jscondition"].ToString())); } } } }
private void DataPlay(int PageNo) { //得到当前模块对应的role HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value); string ls_role = "Role9999"; if (dt_mudel.Rows.Count > 0) ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString(); //判断当前用户是否有删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.tddeldoc.Visible = true; //删除 } else { this.isrole.Value = "0"; this.tddeldoc.Visible = false; //删除 } //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.DAO db = new HyoaClass.DAO(); string lssql = ""; lssql = "select distinct a.DOCID,a.hy_mudelid,a.hy_tableid,a.hy_flowid,a.hy_flowname,a.hy_curtacheid,a.hy_curtachename,a.hy_curclrid,a.hy_curclrname,a.hy_djrid"; lssql += ",a.hy_djrname,a.hy_djrbmid,a.hy_djrbmname,a.hy_djsj,a.hy_bt"; lssql += ",a.hy_field1,a.hy_field2,a.hy_field3,a.hy_field4,a.hy_field5,a.hy_field6,a.hy_field7,a.hy_field8,a.hy_field9,a.hy_field10,a.hy_field11"; lssql += ",a.hy_field12,a.hy_field13,a.hy_field14,a.hy_field15,a.hy_field16,a.hy_field17,a.hy_field18,a.hy_field19,a.hy_field20,a.hy_field21"; lssql += ",a.hy_field22,a.hy_field23,a.hy_field24,a.hy_field25,a.hy_field26,a.hy_field27,a.hy_field28,a.hy_field29,a.hy_field30,a.hy_field31"; lssql += ",a.hy_field32,a.hy_field33,a.hy_field34,a.hy_field35,a.hy_field36,a.hy_field37,a.hy_field38,a.hy_field39,a.hy_field40,a.hy_field41"; lssql += ",a.hy_field42,a.hy_field43,a.hy_field44,a.hy_field45,a.hy_field46,a.hy_field47,a.hy_field48,a.hy_field49,a.hy_field50,a.hy_field51"; lssql += ",a.hy_field52,a.hy_field53,a.hy_field54,a.hy_field55,a.hy_field56,a.hy_field57,a.hy_field58,a.hy_field59,a.hy_field60,a.hy_field61"; lssql += ",a.hy_field62,a.hy_field63,a.hy_field64,a.hy_field65,a.hy_field66,a.hy_field67,a.hy_field68,a.hy_field69,a.hy_field70"; lssql += ",a.hy_field71,a.hy_field72,a.hy_field73,a.hy_field74,a.hy_field75,a.hy_field76,a.hy_field77,a.hy_field78,a.hy_field79,a.hy_field80"; lssql += ",a.hy_field81,a.hy_field82,a.hy_field83,a.hy_field84,a.hy_field85,a.hy_field86,a.hy_field87,a.hy_field88,a.hy_field89,a.hy_field90"; lssql += ",a.hy_field91,a.hy_field92,a.hy_field93,a.hy_field94,a.hy_field95,a.hy_field96,a.hy_field97,a.hy_field98,a.hy_field99,a.hy_field100"; lssql += ",a.hy_iftx,a.hy_zhtxsj,a.hy_readuserlist from hyp_flowmain a,hyp_flowhistoryinfo_cl b "; lssql += "where a.DOCID=b.DOCID and (','+b.hy_clrid+',' like '%," + this.Session["hyuid"].ToString() + ",%' or ','+b.hy_cyrid+',' like '%," + this.Session["hyuid"].ToString() + ",%') and a.hy_curtacheid!='' and a.hy_djrid!='" + this.Session["hyuid"].ToString() + "' and a.hy_curtacheid!='**'"; if (this.hy_bt_1.Value != "") { lssql += " and hy_bt like '%" + this.hy_bt_1.Value + "%'"; } lssql += " order by hy_djsj desc "; //--根据查询条件得到返回数据集--s DataTable dt = db.GetDataTable(lssql); //当前用户能够看到的未结束的文档 //--根据查询条件得到返回数据集--e 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(); }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() =="") this.Response.Redirect("/login.aspx"); if (!IsPostBack) { if (this.Request.QueryString["mid"] != null) { this.txtmudelid.Value = Request.QueryString["mid"].ToString(); } //else //{ // this.Response.Write("<script>alert('模块ID没有传入,请联系管理员!');</script>"); // return; //} //if (this.Request.QueryString["tableid"] != null) //{ // this.txttableid.Value = Request.QueryString["tableid"].ToString(); //} //else //{ // this.Response.Write("<script>alert('表单ID没有传入,请联系管理员!');</script>"); // return; //} if (this.Request.QueryString["page"] != null) { int pos = Request.RawUrl.IndexOf("page=") - 1; if (pos > 0) this.txturl.Text = Request.RawUrl.Substring(0, Request.RawUrl.IndexOf("page=") - 1); //得到page前边的URL地址 DataPlay(System.Int32.Parse(this.Request.QueryString["page"].ToString())); } else { this.txturl.Text = this.Request.RawUrl; DataPlay(1); } PageListItem(); EnabledWhatButton(); ///只有管理员岗位能删除(大榭特有) HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { } else { this.tddeldoc.Visible = false; //this.delcontrol_my.Visible = false; } } }
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.DAO db = new HyoaClass.DAO(); String sql = " select * from hyt_ml where len(MLID)=6 "; if (this.hy_bt.Value != "") { sql += " and MLName like '%" + this.hy_bt.Value + "%'"; } sql += " order by left(MLID,3),hy_sort"; DataTable dt = db.GetDataTable(sql); HyoaClass.Hyoa_ml Hyoa_ml = new HyoaClass.Hyoa_ml(); //DataTable dt; //dt = Hyoa_ml.Getsecondmls(); DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("firstmlname", typeof(String)); tempTable.Columns.Add(col); 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]; } //-------得到一级目录名称-------- DataTable dt_getlast = Hyoa_ml.Getml(dt.Rows[i]["MLID"].ToString().Substring(0,(dt.Rows[i]["MLID"].ToString().Length-3))); if(dt_getlast.Rows.Count>0) dr["firstmlname"] = dt_getlast.Rows[0]["MLName"].ToString(); else dr["firstmlname"] = ""; //-------得到一级目录名称-------- 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(); }
private void DataPlay() { //是否流程文档 this.ddlifflowdoc.Items.Insert(0, "否"); this.ddlifflowdoc.Items.Insert(1, "是"); //是否显示所有文档非流程 this.ddlifdisplayall.Items.Insert(0, "否"); this.ddlifdisplayall.Items.Insert(1, "是"); //是否进行评论 this.ddlifcomment.Items.Insert(0, "否"); this.ddlifcomment.Items.Insert(1, "是"); //主表单显示的列数 this.ddldisplaycol.Items.Insert(0, "4"); this.ddldisplaycol.Items.Insert(1, "6"); this.ddldisplaycol.Items.Insert(2, "8"); this.ddldisplaycol.Items.Insert(3, "10"); //只对流程模块起作用,流程完成后是否公开,是表示大家都能看,否表示不公开 this.ddlispuballByflowYB.Items.Insert(0, "否"); this.ddlispuballByflowYB.Items.Insert(1, "是"); //加载模块 HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dtmudel = Hyoa_mudel.Getmudels(); if (dtmudel.Rows.Count > 0) { this.ddlmudelid.DataSource = dtmudel; this.ddlmudelid.DataTextField = "hy_mudelname"; this.ddlmudelid.DataValueField = "hy_mudelid"; this.ddlmudelid.DataBind(); this.ddlmudelid.Items.Insert(0, "--请选择--"); this.ddlmudelid.SelectedIndex = 0; } if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //判断当前用户是否有保存的权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { this.btn_submit.Visible = true; //保存 } else { this.btn_submit.Visible = false; //保存 } //旧文档 HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); if (this.Request.QueryString["op"] == "modify") { if (this.Request.QueryString["id"] != null) { //根据id得到信息 this.txtdocid.Text = this.Request.QueryString["id"].ToString(); this.txtdocid.Enabled = false; DataTable dt = Hyoa_tableconfig.GetTable(this.txtdocid.Text); if (dt.Rows.Count > 0) { this.ddlmudelid.SelectedValue = dt.Rows[0]["hy_mudelid"].ToString(); this.txtname.Value = dt.Rows[0]["hy_name"].ToString(); this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString(); this.ddlifflowdoc.SelectedValue = dt.Rows[0]["hy_ifflowdoc"].ToString(); this.ddlifdisplayall.SelectedValue = dt.Rows[0]["hy_ifdisplayall"].ToString(); this.ddlifcomment.SelectedValue = dt.Rows[0]["hy_ifcomment"].ToString(); this.ddlispuballByflowYB.SelectedValue = dt.Rows[0]["hy_ispuballByflowYB"].ToString(); this.txthy_onload.Text = dt.Rows[0]["hy_onload"].ToString(); this.ddltablerole.SelectedValue = dt.Rows[0]["hy_tablerole"].ToString(); this.ddldisplaycol.SelectedValue = dt.Rows[0]["hy_colnum"].ToString(); } } } else { this.txtdocid.Text = "Table"; //自动获取最大排序号,然后+2 DataTable dt_maxsort = Hyoa_tableconfig.GetMaxtableconfigsort(); if (dt_maxsort.Rows.Count > 0) txtsort.Value = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString(); else txtsort.Value = "1"; } } }
//加载主表单 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 Page_Load(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("/login.aspx"); if (!this.IsPostBack) { //当前用户信息 this.txtcurloginuserid.Text = Session["hyuid"].ToString(); this.txtcurloginusername.Text = Session["hyuname"].ToString(); this.txtcurlogindeptid.Text = Session["hydeptid"].ToString(); this.txtcurlogindeptname.Text = Session["hydeptname"].ToString(); if (this.Request.QueryString["pop"] != null) { string ls_pop = ""; ls_pop = this.Request.QueryString["pop"].ToString(); //是否弹出窗口 if (ls_pop.Contains(",")) ls_pop = ls_pop.Substring(0, ls_pop.IndexOf(",")); this.txtifpop.Value = ls_pop; } if (this.Request.QueryString["mid"] != null) { string ls_mid = ""; ls_mid = this.Request.QueryString["mid"].ToString(); if (ls_mid.Contains(",")) ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(",")); this.hy_mudelid.Text = ls_mid; } if (this.Request.QueryString["tableid"] != null) { string ls_tableid = ""; ls_tableid = this.Request.QueryString["tableid"].ToString(); if (ls_tableid.Contains(",")) ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(",")); this.hy_tableid.Text = ls_tableid; //得到表单名称 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) this.lbltablename.Text = dt_tableconfig.Rows[0]["hy_name"].ToString(); //是否为流程表单 this.txtifhaveflow.Value = dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString(); this.txttablerole.Value = dt_tableconfig.Rows[0]["hy_tablerole"].ToString(); dt_tableconfig.Clear(); } if (this.Request.QueryString["url"] != null) { //this.txturl.Value = this.Request.QueryString["url"].ToString(); //返回URL string ls_url = this.Request.Url.ToString(); this.txturl.Value = ls_url.Substring(ls_url.LastIndexOf("url=") + 4, ls_url.Length - ls_url.LastIndexOf("url=") - 4); //返回URL } else { //没有URL值的保存后进入列表中,即/list.aspx?mid=clgl&tableid=8b10b316-98d6-4a50-bc15-52745bb119bb this.txturl.Value = "/list.aspx?mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text; getreturnurl(); //特殊返回地址 } DataPlay(); GetFlowtachefields(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", Session["hyuid"].ToString())) { this.td_sc.Visible = true; //删除 } } }
private void DataPlay() { //加载一级目录ID、一级目录名称、每个一级目录最大的二级目录 HyoaClass.Hyoa_ml Hyoa_firstml = new HyoaClass.Hyoa_ml(); DataTable dtfirstml = Hyoa_firstml.GetFirstmls(); if (dtfirstml.Rows.Count > 0) { this.ddlfirstmlid.DataSource = dtfirstml; this.ddlfirstmlid.DataTextField = "MLID"; this.ddlfirstmlid.DataValueField = "MLID"; this.ddlfirstmlid.DataBind(); this.ddlfirstmlid.Items.Insert(0, "--请选择--"); this.ddlfirstmlid.SelectedIndex = 0; this.ddlfirstmlname.DataSource = dtfirstml; this.ddlfirstmlname.DataTextField = "MLName"; this.ddlfirstmlname.DataValueField = "MLName"; this.ddlfirstmlname.DataBind(); this.ddlfirstmlname.Items.Insert(0, "--请选择--"); this.ddlfirstmlname.SelectedIndex = 0; //加载每个一级目录最大的二级目录 string ls_id; for (var i = 0; i < dtfirstml.Rows.Count; i++) { ls_id = Hyoa_firstml.GetMaxMLID(dtfirstml.Rows[i]["MLID"].ToString()); this.ddlsecondmlid.Items.Insert(i, ls_id); } this.ddlsecondmlid.Items.Insert(0, "--请选择--"); this.ddlsecondmlid.SelectedIndex = 0; } //加载模块信息 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; } //加载权限 HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role(); DataTable dtrole = Hyoa_role.Getroles(); if (dtrole.Rows.Count > 0) { this.ddlrole.DataSource = dtrole; this.ddlrole.DataTextField = "hy_rolename"; this.ddlrole.DataValueField = "hy_roleid"; this.ddlrole.DataBind(); this.ddlrole.Items.Insert(0, "--请选择--"); this.ddlrole.SelectedIndex = 0; } this.ddlisenabled.Items.Insert(0, "是"); this.ddlisenabled.Items.Insert(1, "否"); 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_ml Hyoa_ml = new HyoaClass.Hyoa_ml(); //旧文档 if (this.Request.QueryString["op"] == "modify") { if (this.Request.QueryString["id"] != null) { //根据id得到信息 this.lblid.Value = this.Request.QueryString["id"].ToString(); this.txtMLID.Value = this.Request.QueryString["id"].ToString(); DataTable dt = Hyoa_ml.Getml(this.lblid.Value); if (dt.Rows.Count > 0) { this.txtname.Value = dt.Rows[0]["MLName"].ToString(); this.txtlink.Value = dt.Rows[0]["hy_link"].ToString(); this.ddltarget.SelectedValue = dt.Rows[0]["hy_target"].ToString(); this.ddlrole.SelectedValue = dt.Rows[0]["hy_role"].ToString(); this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString(); //模块信息定位 for (var i = 0; i < this.ddlmudelid.Items.Count; i++) { if (this.ddlmudelid.Items[i].Value == dt.Rows[0]["hy_mudelid"].ToString()) { this.ddlmudelid.SelectedIndex = i; } } //一级目录定位 for (var i = 0; i < this.ddlfirstmlid.Items.Count; i++) { if (this.ddlfirstmlid.Items[i].Value == dt.Rows[0]["MLID"].ToString().Substring(0,3)) { this.ddlfirstmlid.SelectedIndex = i; this.ddlfirstmlname.SelectedIndex = i; } } if (dt.Rows[0]["hy_ifqy"].ToString() == "是") this.ddlisenabled.SelectedIndex = 0; else this.ddlisenabled.SelectedIndex = 1; //根据模块信息得到对应的选择表单值 if (dt.Rows[0]["hy_tableid"] != "" && dt.Rows[0]["hy_tableid"] != null) { this.ddltableid.Items.Clear(); //根据模块ID得到表单ID HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dtgettableid = Hyoa_tableconfig.GetTablesbymudelid(dt.Rows[0]["hy_mudelid"].ToString()); if (dtgettableid.Rows.Count > 0) { for (var i = 0; i < dtgettableid.Rows.Count; i++) { this.ddltableid.Items.Insert(i, new ListItem(dtgettableid.Rows[i]["hy_name"].ToString(), dtgettableid.Rows[i]["ID"].ToString())); } this.ddltableid.Items.Insert(0, new ListItem("--请选择--", "")); //定位 this.ddltableid.SelectedValue = dt.Rows[0]["hy_tableid"].ToString(); } } } dt.Clear(); } } } }
//加载主表单 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的特殊处理 } } }
private void DataPlay(int PageNo) { //判断当前用户是否有新建删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9990", 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; //删除 } if (this.txtdeptid.Value == "") this.tdnewdoc.Visible = false; //新建 //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); DataTable dt; if (this.hy_name.Value != "") { if (this.txtdeptid.Value == "") { dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value); } else { dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value); } } else { if (this.txtdeptid.Value == "") { //显示所有用户 dt = Hyoa_user.GetusersOrderbydeptsortandusersort(); } else { //按部门ID显示 dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value); } } DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("ifjz", typeof(String)); //定义新的一列 是否兼职 tempTable.Columns.Add(col); //追加一列 add 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]; } if (dt.Rows[i]["hy_loginuid"].ToString() == "") { dr["ifjz"] = "<font color=red>[兼职信息]</font>"; //将新值赋给相应的列 add } else { dr["ifjz"] = ""; //将新值赋给相应的列 add } 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(); }
private void DataPlay(int PageNo) { //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string sql = ""; DataTable dt = new DataTable(); if (txtmid.Text == "dbsy") { dt = Hyoa_dbsy.Getdbsys_db(Session["hyuid"].ToString()); } if (txtmid.Text == "dysy") { dt = Hyoa_dbsy.Getdbsys_dy(Session["hyuid"].ToString()); } if (txtmid.Text == "ybsy") { dt = Hyoa_dbsy.Getdbsys_yb(Session["hyuid"].ToString()); } if (txtmid.Text == "yysy") { dt = Hyoa_dbsy.Getdbsys_yy(Session["hyuid"].ToString()); } //电子邮件 if (this.Request.QueryString["mid"] == "mail") { //收件箱 if (this.Request.QueryString["tableid"].ToString() == "sjx") { sql = "select * from hyt_mail where hy_jsrid='" + Session["hyuid"].ToString() + "' and hy_type='收件' "; if (txtname.Value != "") { sql += " and hy_title like '%" + txtname.Value + "%' "; } sql += " order by hy_datetime desc "; dt = Hyoa_global.GetDataTable(sql); } //发件箱 if (this.Request.QueryString["tableid"].ToString() == "fjx") { sql = "select * from hyt_mail where hy_fsrid='" + Session["hyuid"].ToString() + "' and hy_type='发件' "; if (txtname.Value != "") { sql += " and hy_title like '%" + txtname.Value + "%' "; } sql += " order by hy_datetime desc "; dt = Hyoa_global.GetDataTable(sql); } } //日程安排 if (this.Request.QueryString["mid"] == "Mudelrcap") { sql = "select * from hyc_Tablercap where hy_djrid='" + Session["hyuid"].ToString() + "' "; if (txtname.Value != "") { sql += " and hyc_zt like '%" + txtname.Value + "%' "; } sql += " order by hyc_qssj desc "; dt = Hyoa_global.GetDataTable(sql); } //个人通讯录 if (this.Request.QueryString["mid"] == "Mudelgrtxl") { sql = "select * from hyc_Tablegrtxl where hy_djrid='" + Session["hyuid"].ToString() + "' "; if (txtname.Value != "") { sql += " and hyc_xm like '%" + txtname.Value + "%' "; } sql += " order by hyc_xm "; dt = Hyoa_global.GetDataTable(sql); } //个人通讯录类别 if (this.Request.QueryString["mid"] == "Mudelgrtxllb") { sql = "select * from hyc_Tablegrtxllb where hy_djrid='" + Session["hyuid"].ToString() + "' "; sql += " order by hyc_pxh "; dt = Hyoa_global.GetDataTable(sql); } //通知公告 if (this.Request.QueryString["mid"] == "Mudeltzgg") { sql = "select * from hyc_Tabletzgg where 1=1 "; if (txtname.Value != "") { sql += " and hyc_bt like '%" + txtname.Value + "%' "; } sql += " order by hyc_djsj desc "; dt = Hyoa_global.GetDataTable(sql); } //最新公文 if (this.Request.QueryString["mid"] == "gwk") { sql = "select * from hyp_gwk where 1=1 "; if (txtname.Value != "") { sql += " and hy_bt like '%" + txtname.Value + "%' "; } sql += " order by hy_djsj desc "; dt = Hyoa_global.GetDataTable(sql); } //工作日志 if (this.Request.QueryString["mid"] == "Mudelgzrz") { sql = "select * from hyc_Tablegzrz where 1=1 "; if (txtname.Value != "") { sql += " and hyc_zt like '%" + txtname.Value + "%' "; } if (this.Request.QueryString["type"].ToString() == "dept") { sql += " and hy_djrbmid = '" + Session["hydeptid"].ToString() + "' "; } else { sql += " and hy_djrid = '" + Session["hyuid"].ToString() + "' "; } sql += " order by hy_djsj desc "; dt = Hyoa_global.GetDataTable(sql); } //请假管理 if (this.Request.QueryString["mid"] == "Mudelqjsq") { sql = "select distinct a.* from hyc_Tableqjsq a,hyp_flowhistoryinfo_cl b where a.DOCID=b.DOCID and (','+b.hy_clrid+',' like '%," + Session["hyuid"].ToString() + ",%' or ','+b.hy_cyrid+',' like '%," + Session["hyuid"].ToString() + ",%') and b.hy_ifth!='是' "; if (txtname.Value != "") { sql += " and hyc_qjsy like '%" + txtname.Value + "%' "; } sql += " order by a.hy_djsj desc "; dt = Hyoa_global.GetDataTable(sql); } DataTable tempTable = dt.Clone(); //模块名称 DataColumn col1 = new DataColumn("show_mudelname", typeof(String)); tempTable.Columns.Add(col1); //显示的标题 DataColumn col2 = new DataColumn("show_bt", typeof(String)); tempTable.Columns.Add(col2); //显示的时间 DataColumn col3 = new DataColumn("show_sj", typeof(String)); tempTable.Columns.Add(col3); //显示的连接 DataColumn col4 = new DataColumn("show_lj", typeof(String)); tempTable.Columns.Add(col4); //删除按钮 DataColumn col5 = new DataColumn("show_delinfo", typeof(String)); tempTable.Columns.Add(col5); 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]; } dr["show_mudelname"] = this.lblmudelname.Text; HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel = Hyoa_mudel.Getmudel(txtmid.Text); string ls_role = "Role9999"; if (dt_mudel.Rows.Count > 0) { ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString(); } if (txtmid.Text == "dbsy" || txtmid.Text == "dysy" || txtmid.Text == "ybsy" || txtmid.Text == "yysy") { dr["show_bt"] = dt.Rows[i]["hy_subbt"].ToString() + "-" + dt.Rows[i]["hy_bt"].ToString(); dr["show_sj"] = "时间:" + System.DateTime.Parse(dt.Rows[i]["hy_createtime"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = dt.Rows[i]["hy_url"].ToString().Replace("main.aspx", "wap_main.aspx"); dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["ID"].ToString() + "');\">[删除记录]</a>"; } //电子邮件 if (this.Request.QueryString["mid"] == "mail") { dr["show_bt"] = dt.Rows[i]["hy_title"].ToString(); dr["show_sj"] = "时间:" + System.DateTime.Parse(dt.Rows[i]["hy_datetime"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = "wap_main_mailread.aspx?op=modify&mid=mail&tableid=sjx&docid=" + dt.Rows[i]["ID"].ToString() + "&url=wap_list.aspx?mid=mail&tableid=sjx&page=" + this.curpage.Text; dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["ID"].ToString() + "');\">[删除记录]</a>"; } //日程安排 if (this.Request.QueryString["mid"] == "Mudelrcap") { dr["show_bt"] = dt.Rows[i]["hyc_zt"].ToString(); dr["show_sj"] = "时间:" + System.DateTime.Parse(dt.Rows[i]["hyc_qssj"].ToString()).ToString("yyyy-MM-dd") + "至" + System.DateTime.Parse(dt.Rows[i]["hyc_jssj"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = "wap_main.aspx?op=modify&mid=Mudelrcap&tableid=Tablercap&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url=wap_list.aspx?mid=Mudelrcap&tableid=Tablercap&page=" + this.curpage.Text; dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["DOCID"].ToString() + "');\">[删除]</a>"; } //个人通信录 if (this.Request.QueryString["mid"] == "Mudelgrtxl") { dr["show_bt"] = dt.Rows[i]["hyc_xm"].ToString(); dr["show_sj"] = "手机:" + dt.Rows[i]["hyc_sj"].ToString(); dr["show_lj"] = "wap_main.aspx?op=modify&mid=Mudelgrtxl&tableid=Tablegrtxl&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url=wap_list.aspx?mid=Mudelgrtxl&tableid=Tablegrtxl&page=" + this.curpage.Text; dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["DOCID"].ToString() + "');\">[删除记录]</a>"; } //个人通信录类别 if (this.Request.QueryString["mid"] == "Mudelgrtxllb") { dr["show_bt"] = dt.Rows[i]["hyc_lb"].ToString(); dr["show_sj"] = "序号:" + dt.Rows[i]["hyc_pxh"].ToString(); dr["show_lj"] = "wap_main.aspx?op=modify&mid=Mudelgrtxl&tableid=Tablegrtxllb&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url=wap_list.aspx?mid=Mudelgrtxl&tableid=Tablegrtxllb&page=" + this.curpage.Text; dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["DOCID"].ToString() + "');\">[删除记录]</a>"; } //通知公告 if (this.Request.QueryString["mid"] == "Mudeltzgg") { dr["show_bt"] = dt.Rows[i]["hyc_bt"].ToString(); dr["show_sj"] = "发布时间:" + System.DateTime.Parse(dt.Rows[i]["hyc_djsj"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = "wap_main.aspx?op=modify&mid=Mudeltzgg&tableid=Tabletzgg&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url=wap_list.aspx?mid=Mudeltzgg&tableid=Tabletzgg&page=" + this.curpage.Text; //判断权限 if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["DOCID"].ToString() + "');\">[删除记录]</a>"; } } //公文库 if (this.Request.QueryString["mid"] == "gwk") { dr["show_bt"] = dt.Rows[i]["hy_bt"].ToString(); dr["show_sj"] = "发布时间:" + System.DateTime.Parse(dt.Rows[i]["hy_djsj"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = "wap_main_gwk.aspx?op=modify&mid=gwk&tableid=gwk&docid=" + dt.Rows[i]["ID"].ToString() + "&url=wap_list.aspx?mid=gwk&tableid=gwk&page=" + this.curpage.Text; //判断权限 if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["ID"].ToString() + "');\">[删除记录]</a>"; } } //工作日志 if (this.Request.QueryString["mid"] == "Mudelgzrz") { dr["show_bt"] = "[" + dt.Rows[i]["hy_djrname"].ToString() + "]" + dt.Rows[i]["hyc_zt"].ToString(); dr["show_sj"] = "发布时间:" + System.DateTime.Parse(dt.Rows[i]["hyc_djsj"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = "wap_main.aspx?op=modify&mid=Mudelgzrz&tableid=Tablegzrz&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url=wap_list.aspx?mid=Mudelgzrz&tableid=Tablegzrz&type=" + this.Request.QueryString["type"].ToString() + "&page=" + this.curpage.Text; dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["DOCID"].ToString() + "');\">[删除记录]</a>"; } //请假管理 if (this.Request.QueryString["mid"] == "Mudelqjsq") { dr["show_bt"] = dt.Rows[i]["hyc_qjr"].ToString() + "[" + dt.Rows[i]["hy_curtachename"].ToString() + "]"; dr["show_sj"] = "请假时间:" + System.DateTime.Parse(dt.Rows[i]["hyc_qjsj"].ToString()).ToString("yyyy-MM-dd"); dr["show_lj"] = "wap_main.aspx?op=modify&mid=Mudelqjsq&tableid=Tableqjsq&docid=" + dt.Rows[i]["DOCID"].ToString() + "&url=wap_list.aspx?mid=Mudelqjsq&tableid=Tableqjsq&page=" + this.curpage.Text; //判断权限 if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { dr["show_delinfo"] = "<a href=\"#\" onclick=\"DelInfo('" + dt.Rows[i]["DOCID"].ToString() + "');\">[删除记录]</a>"; } } tempTable.Rows.Add(dr); } int TotalRecord = dt.Rows.Count; this.ShowTotalRecord.Text = TotalRecord.ToString(); //计算及显示总页数 int TotalPage; if (TotalRecord < System.Int32.Parse(PageSize.Text)) { TotalPage = 1; } else { if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0) { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1; } else { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text); } } this.ShowTotalPage.Text = TotalPage.ToString(); this.rptlist.DataSource = tempTable; this.rptlist.DataBind(); dt.Clear(); }
private void DataPlay() { 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("Role9990", this.Session["hyuid"].ToString())) { this.btn_submit.Visible = true; //保存 } else { this.btn_submit.Visible = false; //保存 } //新文档 if (this.Request.QueryString["op"] == "add") { //对部门ID处理开始start HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dt; string lsdeptid; lsdeptid = ""; //this.Response.Write("<script>alert('" + this.Request.QueryString["deptid"] + "')</script>"); if (this.Request.QueryString["deptid"] == "") { //部门ID为空,说明是第一级部门 dt = Hyoa_dept.GetFirstdeptsOrderByDeptid(); if (dt.Rows.Count > 0) { //判断当前部门是不是有数据的 lsdeptid = (System.Int32.Parse(dt.Rows[0]["hy_deptid"].ToString()) + 1).ToString(); if (lsdeptid.Length == 1) { this.hy_deptid.Text = "00" + lsdeptid; } else if (lsdeptid.Length == 2) { this.hy_deptid.Text = "0" + lsdeptid; } else { this.hy_deptid.Text = lsdeptid; } } else { this.hy_deptid.Text = "001"; } } else { //部门ID不为空,说明不是第一级部门 dt = Hyoa_dept.GetSubDeptsOrderByDeptid(this.Request.QueryString["deptid"].ToString()); if (dt.Rows.Count > 0) { //判断当前部门是不是有数据的 lsdeptid = (long.Parse(dt.Rows[0]["hy_deptid"].ToString()) + 1).ToString(); this.hy_deptid.Text = this.Request.QueryString["deptid"].ToString() + lsdeptid.Substring(lsdeptid.Length - 3, 3).ToString(); } else { this.hy_deptid.Text = this.Request.QueryString["deptid"].ToString() + "001"; } } //对部门ID处理结束end this.hy_isenabled.Items.Insert(0, "是"); this.hy_isenabled.Items.Insert(1, "否"); } //旧文档 if (this.Request.QueryString["op"] == "modify") { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dt = Hyoa_dept.Getdept(this.txtdocid.Value); if (dt.Rows.Count > 0) { this.hy_deptid.Text = dt.Rows[0]["hy_deptid"].ToString(); this.hy_deptname.Text = dt.Rows[0]["hy_deptname"].ToString(); this.hy_deptsort.Text = dt.Rows[0]["hy_deptsort"].ToString(); //this.Response.Write("<script>alert('" + dt.Rows[0]["hy_isenabled"].ToString() + "')</script>"); this.hy_isenabled.Items.Insert(0, "是"); this.hy_isenabled.Items.Insert(1, "否"); if (dt.Rows[0]["hy_isenabled"].ToString() == "是") this.hy_isenabled.SelectedIndex = 0; else this.hy_isenabled.SelectedIndex = 1; } dt.Clear(); } } }
private void DataPlay(int PageNo) { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_where = " "; if (dwmc.Value != "") { ls_where += " and hyc_dwmc like '%" + dwmc.Value.Trim() + "%' "; } //客户管理 if (Hyoa_global.isHaveRole("Rolekhgl001", this.Session["hyuid"].ToString())) { //查看所有 } else if (Hyoa_global.isHaveRole("Rolekhgl002", this.Session["hyuid"].ToString())) { //查看本部 if (this.Session["hyuid"].ToString() == "008") { //业务一部 酒店、综合 ls_where += " and SUBSTRING(hy_djrbmid, 0, 4)='005' "; } if (this.Session["hyuid"].ToString() == "009") { //业务二部 金融、政府 ls_where += " and SUBSTRING(hy_djrbmid, 0, 4)='006' "; } } //else if (Hyoa_global.isHaveRole("Rolekhgl003", this.Session["hyuid"].ToString())) //{ // //查看本组 // ls_where += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'"; //} else { //ls_where += " and (hy_djrid='" + Session["hyuid"].ToString() + "') "; ls_where += " and hy_djrbmid='" + Session["hydeptid"].ToString() + "'"; } string ls_order = " order by hy_djsj desc"; string sqlSelect = "select top " + PageSize.Text + " hyc_dwmc from hyc_Tablekhda where 1=1 " + ls_where + " and docid not in ( select top " + System.Int32.Parse(PageSize.Text) * (PageNo - 1) + " docid from hyc_Tablekhda where 1=1 " + ls_where + ls_order + " ) " + ls_order; string sqlSelectAll = " select hyc_dwmc from hyc_Tablekhda where 1=1 " + ls_where + ls_order; DataTable dt = Hyoa_global.GetDataTable(sqlSelect); DataTable dt2 = Hyoa_global.GetDataTable(sqlSelectAll); StringBuilder lsShow = new StringBuilder(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { sqlSelect = " select docid from hyc_Tablekhda where hyc_dwmc='" + dt.Rows[i]["hyc_dwmc"].ToString() + "' order by hy_djsj desc "; DataTable dt3 = Hyoa_global.GetDataTable(sqlSelect); if (dt3.Rows.Count > 0) { lsShow.Append("<tr onmouseover=\"this.className='tr-over'\" onmouseout=\"this.className='TrList'\" class=\"TrList\" height=\"30\" > "); lsShow.Append(" <td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">" + (i + 1) + "</td>"); //单位名称 lsShow.Append("<td width=\"20%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" onclick=\" var path='main_look.aspx?op=modify&pop=_blank&mid=Mudelkhda&tableid=Tablekhda&docid=" + dt3.Rows[0]["docid"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + " ';window.open(path) \">" + dt.Rows[i]["hyc_dwmc"].ToString() + "</p></td>"); //联系人 lsShow.Append("<td width=\"15%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" onclick=\" var path='main_flc.aspx?op=add&pop=_blank&mid=Mudelkhda&tableid=Tablelxr&key=" + dt3.Rows[0]["docid"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "&url=" + Request.Url.AbsoluteUri.ToString() + "';window.open(path);\">登记</a> <a href=\"#\" onclick=\"var path='list_fl.aspx?mid=Mudelkhda&tableid=Tablelxr&listid=a715ab7d-c844-4aad-9297-ae1ef1c9c956&key=" + dt.Rows[i]["hyc_dwmc"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "';window.open(path);\">列表</a></p></td>"); //联系客户关系 lsShow.Append("<td width=\"15%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" onclick=\" var path='main_flc.aspx?op=add&pop=_blank&mid=Mudelkhda&tableid=Tablewxkhgx&key=" + dt3.Rows[0]["docid"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "&url=" + Request.Url.AbsoluteUri.ToString() + "';window.open(path);\">登记</a> <a href=\"#\" onclick=\"var path='list_fl.aspx?mid=Mudelkhda&tableid=Tablewxkhgx&listid=2352c0f2-8dfe-4f87-ad35-f1cc36f3b4bc&key=" + dt.Rows[i]["hyc_dwmc"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "';window.open(path);\">列表</a></p></td>"); //客户故障 lsShow.Append("<td width=\"15%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" onclick=\" var path='main_flc.aspx?op=add&pop=_blank&mid=Mudelkhda&tableid=Tablekhgzdj&key=" + dt3.Rows[0]["docid"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "&url=" + Request.Url.AbsoluteUri.ToString() + "';window.open(path);\">登记</a> <a href=\"#\" onclick=\"var path='list_fl.aspx?mid=Mudelkhda&tableid=Tablekhgzdj&listid=afbdf289-c511-4b91-a2c7-bdb4d510ca78&key=" + dt.Rows[i]["hyc_dwmc"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "';window.open(path);\">列表</a></p></td>"); //竞争对手行情分析 lsShow.Append("<td width=\"15%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" onclick=\" var path='main_flc.aspx?op=add&pop=_blank&mid=Mudelkhda&tableid=Tablejzdshq&key=" + dt3.Rows[0]["docid"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "&url=" + Request.Url.AbsoluteUri.ToString() + "';window.open(path);\">登记</a> <a href=\"#\" onclick=\"var path='list_fl.aspx?mid=Mudelkhda&tableid=Tablejzdshq&listid=2f7ab59f-fa4c-4b7f-bd33-f4cd941f348b&key=" + dt.Rows[i]["hyc_dwmc"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "';window.open(path);\">列表</a></p></td>"); //业务受理 lsShow.Append("<td width=\"15%\" class=\"TdcellHead\"><p align=\"center\"><a href=\"#\" onclick=\" var path='main_flc.aspx?op=add&pop=_blank&mid=Mudelkhda&tableid=Tableywslb&key=" + dt3.Rows[0]["docid"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "&url=" + Request.Url.AbsoluteUri.ToString() + "';window.open(path);\">登记</a> <a href=\"#\" onclick=\"var path='list_fl.aspx?mid=Mudelkhda&tableid=Tableywslb&listid=a1b7bf18-0f1a-4d1a-90c9-5d23772b52c9&key=" + dt.Rows[i]["hyc_dwmc"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString() + "';window.open(path);\">列表</a></p></td>"); } } lb_show.Text = lsShow.ToString(); } else { //Response.Write("<script>alert('对不起,暂时没有数据!');</script>"); lb_show.Text = ""; } //得到当前页号 this.curpage.Text = PageNo.ToString(); 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 = dt2.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(); dt.Clear(); }
private void DataPlay(int PageNo) { //得到当前模块对应的role HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value); string ls_role = "Role9999"; if (dt_mudel.Rows.Count > 0) ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString(); //根据表ID和模块ID得到当前传进来的模块是否有流程 HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dttableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.txtmudelid.Value, this.txttableid.Value); //判断当前用户是否有删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (dttableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //如果有流程的话,新建按钮就一直显示,不用作判断的,只要判断删除按钮就行。 if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.delcontrol.Visible = true; this.newcontrol.Visible = true; //this.copycontrol.Visible = false; //流程模块暂时都不能复制 } else { this.isrole.Value = "0"; this.newcontrol.Visible = true; } } else { //如果非流程(授权用户统一管理) if(dttableconfig.Rows[0]["hy_tablerole"].ToString() == "0") { if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.newcontrol.Visible = true; this.delcontrol.Visible = true; //this.copycontrol.Visible = true; } else { this.isrole.Value = "0"; } } //如果非流程(每个人管理自己的信息) if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "1") { this.isrole.Value = "1"; this.newcontrol.Visible = true; this.delcontrol_my.Visible = true; //this.copycontrol.Visible = true; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (dttableconfig.Rows[0]["hy_tablerole"].ToString() == "2") { if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.newcontrol.Visible = true; this.delcontrol.Visible = true; //this.copycontrol.Visible = true; } else { this.isrole.Value = "0"; this.newcontrol.Visible = true; this.delcontrol_my.Visible = true; //this.copycontrol.Visible = true; } } } //得到当前页号 this.lbdisplaytitle.Text = ""; this.curpage.Text = PageNo.ToString(); //---查询条件---开始 HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); Hyoa_flowmain.hy_mudelid = this.txtmudelid.Value; Hyoa_flowmain.hy_tableid = this.txttableid.Value; Hyoa_flowmain.hy_bt = this.hy_bt.Text; Hyoa_flowmain.hy_djrname = this.hy_djrname.Text; Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text; Hyoa_flowmain.hy_djsj_start = this.hy_djsj_start.Text; Hyoa_flowmain.hy_djsj_end = this.hy_djsj_end.Text; Hyoa_flowmain.hy_bt = this.hy_bt.Text; Hyoa_flowmain.hy_content1 = this.hy_content1.Text; Hyoa_flowmain.hy_content2 = this.hy_content2.Text; Hyoa_flowmain.hy_content3 = this.hy_content3.Text; Hyoa_flowmain.hy_content4 = this.hy_content4.Text; Hyoa_flowmain.hy_content5 = this.hy_content5.Text; Hyoa_flowmain.hy_field1 = this.hy_field1.Text; Hyoa_flowmain.hy_field2 = this.hy_field2.Text; Hyoa_flowmain.hy_field3 = this.hy_field3.Text; Hyoa_flowmain.hy_field4 = this.hy_field4.Text; Hyoa_flowmain.hy_field5 = this.hy_field5.Text; Hyoa_flowmain.hy_field6 = this.hy_field6.Text; Hyoa_flowmain.hy_field7 = this.hy_field7.Text; Hyoa_flowmain.hy_field8 = this.hy_field8.Text; Hyoa_flowmain.hy_field9 = this.hy_field9.Text; Hyoa_flowmain.hy_field10 = this.hy_field10.Text; Hyoa_flowmain.hy_field11 = this.hy_field11.Text; Hyoa_flowmain.hy_field12 = this.hy_field12.Text; Hyoa_flowmain.hy_field13 = this.hy_field13.Text; Hyoa_flowmain.hy_field14 = this.hy_field14.Text; Hyoa_flowmain.hy_field15 = this.hy_field15.Text; Hyoa_flowmain.hy_field16 = this.hy_field16.Text; Hyoa_flowmain.hy_field17 = this.hy_field17.Text; Hyoa_flowmain.hy_field18 = this.hy_field18.Text; Hyoa_flowmain.hy_field19 = this.hy_field19.Text; Hyoa_flowmain.hy_field20 = this.hy_field20.Text; Hyoa_flowmain.hy_field21 = this.hy_field21.Text; Hyoa_flowmain.hy_field22 = this.hy_field22.Text; Hyoa_flowmain.hy_field23 = this.hy_field23.Text; Hyoa_flowmain.hy_field24 = this.hy_field24.Text; Hyoa_flowmain.hy_field25 = this.hy_field25.Text; Hyoa_flowmain.hy_field26 = this.hy_field26.Text; Hyoa_flowmain.hy_field27 = this.hy_field27.Text; Hyoa_flowmain.hy_field28 = this.hy_field28.Text; Hyoa_flowmain.hy_field29 = this.hy_field29.Text; Hyoa_flowmain.hy_field30 = this.hy_field30.Text; Hyoa_flowmain.hy_field31_start = this.hy_field31_start.Text; Hyoa_flowmain.hy_field32_start = this.hy_field32_start.Text; Hyoa_flowmain.hy_field33_start = this.hy_field33_start.Text; Hyoa_flowmain.hy_field34_start = this.hy_field34_start.Text; Hyoa_flowmain.hy_field35_start = this.hy_field35_start.Text; Hyoa_flowmain.hy_field31_end = this.hy_field31_end.Text; Hyoa_flowmain.hy_field32_end = this.hy_field32_end.Text; Hyoa_flowmain.hy_field33_end = this.hy_field33_end.Text; Hyoa_flowmain.hy_field34_end = this.hy_field34_end.Text; Hyoa_flowmain.hy_field35_end = this.hy_field35_end.Text; if (this.hy_field36_start.Text == "") { this.hy_field36_start.Text = "0"; } if (this.hy_field37_start.Text == "") { this.hy_field37_start.Text = "0"; } if (this.hy_field38_start.Text == "") { this.hy_field38_start.Text = "0"; } if (this.hy_field39_start.Text == "") { this.hy_field39_start.Text = "0"; } if (this.hy_field40_start.Text == "") { this.hy_field40_start.Text = "0"; } if (this.hy_field36_end.Text == "") { this.hy_field36_end.Text = "0"; } if (this.hy_field37_end.Text == "") { this.hy_field37_end.Text = "0"; } if (this.hy_field38_end.Text == "") { this.hy_field38_end.Text = "0"; } if (this.hy_field39_end.Text == "") { this.hy_field39_end.Text = "0"; } if (this.hy_field40_end.Text == "") { this.hy_field40_end.Text = "0"; } Hyoa_flowmain.hy_field36_start = float.Parse(this.hy_field36_start.Text); Hyoa_flowmain.hy_field37_start = float.Parse(this.hy_field37_start.Text); Hyoa_flowmain.hy_field38_start = float.Parse(this.hy_field38_start.Text); Hyoa_flowmain.hy_field39_start = float.Parse(this.hy_field39_start.Text); Hyoa_flowmain.hy_field40_start = float.Parse(this.hy_field40_start.Text); Hyoa_flowmain.hy_field36_end = float.Parse(this.hy_field36_end.Text); Hyoa_flowmain.hy_field37_end = float.Parse(this.hy_field37_end.Text); Hyoa_flowmain.hy_field38_end = float.Parse(this.hy_field38_end.Text); Hyoa_flowmain.hy_field39_end = float.Parse(this.hy_field39_end.Text); Hyoa_flowmain.hy_field40_end = float.Parse(this.hy_field40_end.Text); Hyoa_flowmain.hy_field41 = this.hy_field41.Text; Hyoa_flowmain.hy_field42 = this.hy_field42.Text; Hyoa_flowmain.hy_field43 = this.hy_field43.Text; Hyoa_flowmain.hy_field44 = this.hy_field44.Text; Hyoa_flowmain.hy_field45 = this.hy_field45.Text; Hyoa_flowmain.hy_field46 = this.hy_field46.Text; Hyoa_flowmain.hy_field47 = this.hy_field47.Text; Hyoa_flowmain.hy_field48 = this.hy_field48.Text; Hyoa_flowmain.hy_field49 = this.hy_field49.Text; Hyoa_flowmain.hy_field50 = this.hy_field50.Text; Hyoa_flowmain.hy_field51 = this.hy_field51.Text; Hyoa_flowmain.hy_field52 = this.hy_field52.Text; Hyoa_flowmain.hy_field53 = this.hy_field53.Text; Hyoa_flowmain.hy_field54 = this.hy_field54.Text; Hyoa_flowmain.hy_field55 = this.hy_field55.Text; Hyoa_flowmain.hy_field56 = this.hy_field56.Text; Hyoa_flowmain.hy_field57 = this.hy_field57.Text; Hyoa_flowmain.hy_field58 = this.hy_field58.Text; Hyoa_flowmain.hy_field59 = this.hy_field59.Text; Hyoa_flowmain.hy_field60 = this.hy_field60.Text; Hyoa_flowmain.hy_field61_start = this.hy_field61_start.Text; Hyoa_flowmain.hy_field62_start = this.hy_field62_start.Text; Hyoa_flowmain.hy_field63_start = this.hy_field63_start.Text; Hyoa_flowmain.hy_field64_start = this.hy_field64_start.Text; Hyoa_flowmain.hy_field65_start = this.hy_field65_start.Text; Hyoa_flowmain.hy_field66_start = this.hy_field66_start.Text; Hyoa_flowmain.hy_field67_start = this.hy_field67_start.Text; Hyoa_flowmain.hy_field68_start = this.hy_field68_start.Text; Hyoa_flowmain.hy_field69_start = this.hy_field69_start.Text; Hyoa_flowmain.hy_field70_start = this.hy_field70_start.Text; Hyoa_flowmain.hy_field61_end = this.hy_field61_end.Text; Hyoa_flowmain.hy_field62_end = this.hy_field62_end.Text; Hyoa_flowmain.hy_field63_end = this.hy_field63_end.Text; Hyoa_flowmain.hy_field64_end = this.hy_field64_end.Text; Hyoa_flowmain.hy_field65_end = this.hy_field65_end.Text; Hyoa_flowmain.hy_field66_end = this.hy_field66_end.Text; Hyoa_flowmain.hy_field67_end = this.hy_field67_end.Text; Hyoa_flowmain.hy_field68_end = this.hy_field68_end.Text; Hyoa_flowmain.hy_field69_end = this.hy_field69_end.Text; Hyoa_flowmain.hy_field70_end = this.hy_field70_end.Text; if (this.hy_field71_start.Text == "") { this.hy_field71_start.Text = "0"; } if (this.hy_field72_start.Text == "") { this.hy_field72_start.Text = "0"; } if (this.hy_field73_start.Text == "") { this.hy_field73_start.Text = "0"; } if (this.hy_field74_start.Text == "") { this.hy_field74_start.Text = "0"; } if (this.hy_field75_start.Text == "") { this.hy_field75_start.Text = "0"; } if (this.hy_field76_start.Text == "") { this.hy_field76_start.Text = "0"; } if (this.hy_field77_start.Text == "") { this.hy_field77_start.Text = "0"; } if (this.hy_field78_start.Text == "") { this.hy_field78_start.Text = "0"; } if (this.hy_field79_start.Text == "") { this.hy_field79_start.Text = "0"; } if (this.hy_field80_start.Text == "") { this.hy_field80_start.Text = "0"; } if (this.hy_field71_end.Text == "") { this.hy_field71_end.Text = "0"; } if (this.hy_field72_end.Text == "") { this.hy_field72_end.Text = "0"; } if (this.hy_field73_end.Text == "") { this.hy_field73_end.Text = "0"; } if (this.hy_field74_end.Text == "") { this.hy_field74_end.Text = "0"; } if (this.hy_field75_end.Text == "") { this.hy_field75_end.Text = "0"; } if (this.hy_field76_end.Text == "") { this.hy_field76_end.Text = "0"; } if (this.hy_field77_end.Text == "") { this.hy_field77_end.Text = "0"; } if (this.hy_field78_end.Text == "") { this.hy_field78_end.Text = "0"; } if (this.hy_field79_end.Text == "") { this.hy_field79_end.Text = "0"; } if (this.hy_field80_end.Text == "") { this.hy_field80_end.Text = "0"; } if (this.hy_field81_start.Text == "") { this.hy_field81_start.Text = "0"; } if (this.hy_field82_start.Text == "") { this.hy_field82_start.Text = "0"; } if (this.hy_field83_start.Text == "") { this.hy_field83_start.Text = "0"; } if (this.hy_field84_start.Text == "") { this.hy_field84_start.Text = "0"; } if (this.hy_field85_start.Text == "") { this.hy_field85_start.Text = "0"; } if (this.hy_field86_start.Text == "") { this.hy_field86_start.Text = "0"; } if (this.hy_field87_start.Text == "") { this.hy_field87_start.Text = "0"; } if (this.hy_field88_start.Text == "") { this.hy_field88_start.Text = "0"; } if (this.hy_field89_start.Text == "") { this.hy_field89_start.Text = "0"; } if (this.hy_field90_start.Text == "") { this.hy_field90_start.Text = "0"; } if (this.hy_field81_end.Text == "") { this.hy_field81_end.Text = "0"; } if (this.hy_field82_end.Text == "") { this.hy_field82_end.Text = "0"; } if (this.hy_field83_end.Text == "") { this.hy_field83_end.Text = "0"; } if (this.hy_field84_end.Text == "") { this.hy_field84_end.Text = "0"; } if (this.hy_field85_end.Text == "") { this.hy_field85_end.Text = "0"; } if (this.hy_field86_end.Text == "") { this.hy_field86_end.Text = "0"; } if (this.hy_field87_end.Text == "") { this.hy_field87_end.Text = "0"; } if (this.hy_field88_end.Text == "") { this.hy_field88_end.Text = "0"; } if (this.hy_field89_end.Text == "") { this.hy_field89_end.Text = "0"; } if (this.hy_field90_end.Text == "") { this.hy_field90_end.Text = "0"; } //ztm if (this.hy_field91_start.Text == "") { this.hy_field91_start.Text = "0"; } if (this.hy_field92_start.Text == "") { this.hy_field92_start.Text = "0"; } if (this.hy_field93_start.Text == "") { this.hy_field93_start.Text = "0"; } if (this.hy_field94_start.Text == "") { this.hy_field94_start.Text = "0"; } if (this.hy_field95_start.Text == "") { this.hy_field95_start.Text = "0"; } if (this.hy_field96_start.Text == "") { this.hy_field96_start.Text = "0"; } if (this.hy_field97_start.Text == "") { this.hy_field97_start.Text = "0"; } if (this.hy_field98_start.Text == "") { this.hy_field98_start.Text = "0"; } if (this.hy_field99_start.Text == "") { this.hy_field99_start.Text = "0"; } if (this.hy_field100_start.Text == "") { this.hy_field100_start.Text = "0"; } if (this.hy_field91_end.Text == "") { this.hy_field91_end.Text = "0"; } if (this.hy_field92_end.Text == "") { this.hy_field92_end.Text = "0"; } if (this.hy_field93_end.Text == "") { this.hy_field93_end.Text = "0"; } if (this.hy_field94_end.Text == "") { this.hy_field94_end.Text = "0"; } if (this.hy_field95_end.Text == "") { this.hy_field95_end.Text = "0"; } if (this.hy_field96_end.Text == "") { this.hy_field96_end.Text = "0"; } if (this.hy_field97_end.Text == "") { this.hy_field97_end.Text = "0"; } if (this.hy_field98_end.Text == "") { this.hy_field98_end.Text = "0"; } if (this.hy_field99_end.Text == "") { this.hy_field99_end.Text = "0"; } if (this.hy_field100_end.Text == "") { this.hy_field100_end.Text = "0"; } Hyoa_flowmain.hy_field71_start = float.Parse(this.hy_field71_start.Text); Hyoa_flowmain.hy_field72_start = float.Parse(this.hy_field72_start.Text); Hyoa_flowmain.hy_field73_start = float.Parse(this.hy_field73_start.Text); Hyoa_flowmain.hy_field74_start = float.Parse(this.hy_field74_start.Text); Hyoa_flowmain.hy_field75_start = float.Parse(this.hy_field75_start.Text); Hyoa_flowmain.hy_field76_start = float.Parse(this.hy_field76_start.Text); Hyoa_flowmain.hy_field77_start = float.Parse(this.hy_field77_start.Text); Hyoa_flowmain.hy_field78_start = float.Parse(this.hy_field78_start.Text); Hyoa_flowmain.hy_field79_start = float.Parse(this.hy_field79_start.Text); Hyoa_flowmain.hy_field80_start = float.Parse(this.hy_field80_start.Text); Hyoa_flowmain.hy_field71_end = float.Parse(this.hy_field71_end.Text); Hyoa_flowmain.hy_field72_end = float.Parse(this.hy_field72_end.Text); Hyoa_flowmain.hy_field73_end = float.Parse(this.hy_field73_end.Text); Hyoa_flowmain.hy_field74_end = float.Parse(this.hy_field74_end.Text); Hyoa_flowmain.hy_field75_end = float.Parse(this.hy_field75_end.Text); Hyoa_flowmain.hy_field76_end = float.Parse(this.hy_field76_end.Text); Hyoa_flowmain.hy_field77_end = float.Parse(this.hy_field77_end.Text); Hyoa_flowmain.hy_field78_end = float.Parse(this.hy_field78_end.Text); Hyoa_flowmain.hy_field79_end = float.Parse(this.hy_field79_end.Text); Hyoa_flowmain.hy_field80_end = float.Parse(this.hy_field80_end.Text); Hyoa_flowmain.hy_field81_start = float.Parse(this.hy_field81_start.Text); Hyoa_flowmain.hy_field82_start = float.Parse(this.hy_field82_start.Text); Hyoa_flowmain.hy_field83_start = float.Parse(this.hy_field83_start.Text); Hyoa_flowmain.hy_field84_start = float.Parse(this.hy_field84_start.Text); Hyoa_flowmain.hy_field85_start = float.Parse(this.hy_field85_start.Text); Hyoa_flowmain.hy_field86_start = float.Parse(this.hy_field86_start.Text); Hyoa_flowmain.hy_field87_start = float.Parse(this.hy_field87_start.Text); Hyoa_flowmain.hy_field88_start = float.Parse(this.hy_field88_start.Text); Hyoa_flowmain.hy_field89_start = float.Parse(this.hy_field89_start.Text); Hyoa_flowmain.hy_field90_start = float.Parse(this.hy_field90_start.Text); Hyoa_flowmain.hy_field81_end = float.Parse(this.hy_field81_end.Text); Hyoa_flowmain.hy_field82_end = float.Parse(this.hy_field82_end.Text); Hyoa_flowmain.hy_field83_end = float.Parse(this.hy_field83_end.Text); Hyoa_flowmain.hy_field84_end = float.Parse(this.hy_field84_end.Text); Hyoa_flowmain.hy_field85_end = float.Parse(this.hy_field85_end.Text); Hyoa_flowmain.hy_field86_end = float.Parse(this.hy_field86_end.Text); Hyoa_flowmain.hy_field87_end = float.Parse(this.hy_field87_end.Text); Hyoa_flowmain.hy_field88_end = float.Parse(this.hy_field88_end.Text); Hyoa_flowmain.hy_field89_end = float.Parse(this.hy_field89_end.Text); Hyoa_flowmain.hy_field90_end = float.Parse(this.hy_field90_end.Text); Hyoa_flowmain.hy_field91_start = float.Parse(this.hy_field91_start.Text); Hyoa_flowmain.hy_field92_start = float.Parse(this.hy_field92_start.Text); Hyoa_flowmain.hy_field93_start = float.Parse(this.hy_field93_start.Text); Hyoa_flowmain.hy_field94_start = float.Parse(this.hy_field94_start.Text); Hyoa_flowmain.hy_field95_start = float.Parse(this.hy_field95_start.Text); Hyoa_flowmain.hy_field96_start = float.Parse(this.hy_field96_start.Text); Hyoa_flowmain.hy_field97_start = float.Parse(this.hy_field97_start.Text); Hyoa_flowmain.hy_field98_start = float.Parse(this.hy_field98_start.Text); Hyoa_flowmain.hy_field99_start = float.Parse(this.hy_field99_start.Text); Hyoa_flowmain.hy_field100_start = float.Parse(this.hy_field100_start.Text); Hyoa_flowmain.hy_field91_end = float.Parse(this.hy_field91_end.Text); Hyoa_flowmain.hy_field92_end = float.Parse(this.hy_field92_end.Text); Hyoa_flowmain.hy_field93_end = float.Parse(this.hy_field93_end.Text); Hyoa_flowmain.hy_field94_end = float.Parse(this.hy_field94_end.Text); Hyoa_flowmain.hy_field95_end = float.Parse(this.hy_field95_end.Text); Hyoa_flowmain.hy_field96_end = float.Parse(this.hy_field96_end.Text); Hyoa_flowmain.hy_field97_end = float.Parse(this.hy_field97_end.Text); Hyoa_flowmain.hy_field98_end = float.Parse(this.hy_field98_end.Text); Hyoa_flowmain.hy_field99_end = float.Parse(this.hy_field99_end.Text); Hyoa_flowmain.hy_field100_end = float.Parse(this.hy_field100_end.Text); Hyoa_flowmain.hy_curclrid = this.Session["hyuid"].ToString(); Hyoa_flowmain.hy_curuserid = this.Session["hyuid"].ToString(); //排序 HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig(); DataTable dt_listconfig = Hyoa_listconfig.GetlistconfigByTableid(this.txttableid.Value); if (dt_listconfig.Rows.Count > 0) { Hyoa_flowmain.hy_sorttype = dt_listconfig.Rows[0]["hy_sortfield"].ToString() + " " + dt_listconfig.Rows[0]["hy_sorttype"].ToString(); } //---查询条件---结束 //--根据查询条件得到返回数据集--s DataTable dt; DataTable dttable = Hyoa_tableconfig.GetTable(this.txttableid.Value); //得到表配置信息查看当前表是否有流程 hy_ifflowdoc dt = Hyoa_flowmain.GetflowmainsByIf_db(); //输出当前处理人是自己的dt //if (dttable.Rows[0]["hy_ifflowdoc"].ToString()=="是") //{ // //this.Response.Write("<script>alert('" + dttable.Rows[0]["hy_ispuballByflowYB"].ToString() + "')</script>"); // //dt = Hyoa_flowmain.GetflowmainsByIf(); //输出流程的dt // if (dttable.Rows[0]["hy_ispuballByflowYB"].ToString() == "是") // { // dt = Hyoa_flowmain.GetflowmainsByIf_jsDisplayAll(); //输出流程的dt // } // else // { // dt = Hyoa_flowmain.GetflowmainsByIf(); //输出流程的dt // } //} //else //{ // if (dttable.Rows[0]["hy_ifdisplayall"].ToString() == "是") // { // dt = Hyoa_flowmain.GetAllflowmainsByNoFlows();//输出所有的dt // } // else // { // dt = Hyoa_flowmain.GetPersonerflowmainsByNoFlows();//输出自己的dt // } //} //--根据查询条件得到返回数据集--e //开始输出----整合成HTML为数据行 DataTable tempTable = dt.Clone(); DataColumn col = new DataColumn("displaycol", typeof(String)); //定义新的一列 add tempTable.Columns.Add(col); //追加一列 add string lscolname = ""; string lscolnameid = ""; string lscolwidth = ""; string ls_col = ""; string[] lvcolname; string[] lvcolnameid; string[] lvcolwidth; string lscolwidthper; //HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig(); DataTable dtlist = Hyoa_listconfig.GetlistconfigsbyMudelidAndTableid(this.txtmudelid.Value,this.txttableid.Value); lscolname = dtlist.Rows[0]["hy_columnshow"].ToString(); //要显示的列名:附件,标题,收文来源 lscolnameid = dtlist.Rows[0]["hy_columnshowid"].ToString(); //要显示的列名id:uploadfile1,Hy_bt,Hy_swly lscolwidth = dtlist.Rows[0]["hy_width"].ToString(); //要显示的列名id:10,20,30 lvcolname = lscolname.Split(','); lvcolnameid = lscolnameid.Split(','); lvcolwidth = lscolwidth.Split(','); if (dt.Rows.Count <= 0) { //如果没有数据则输出表头 for (int n = 0; n < lvcolname.Length; n++) { if (n >= lvcolwidth.Length) { lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时,会溢出报错。 else { lscolwidthper = lvcolwidth[n]; } this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[n] + "</td>"; } } for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++) { if (i > dt.Rows.Count - 1) break; DataRow dr = tempTable.NewRow(); //输出主表所有字段,start for (int j = 0; j < dt.Columns.Count; j++) { dr[dt.Columns[j].ColumnName] = dt.Rows[i][j]; } //输出主表所有字段,end //////开始得到列的值 HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); DataTable dtgetsqlfield; for (int m = 0; m < lvcolname.Length; m++) { //如果有数据,则输出数据 if (m >= lvcolwidth.Length) { lscolwidthper = ""; }//此判断是为了防止对应宽度没有输入时,会溢出报错。 else { lscolwidthper = lvcolwidth[m]; } dtgetsqlfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Value, lvcolnameid[m],this.txttableid.Value); //ztm if (i % System.Int32.Parse(PageSize.Text) == 0) this.lbdisplaytitle.Text += "<td width=\"" + lscolwidthper + "%\" class=\"TdcellHead\"><p align=\"center\">" + lvcolname[m] + "</td>"; //根据字段英文名,得到数据库中对应的字段 string lsgetsqlfield = dtgetsqlfield.Rows[0]["hy_sqlfield"].ToString(); //根据数据库中对应的字段,得到输出字段的值start (日期型根据格式进行了转换) string lsgetputfiled=""; if (dtgetsqlfield.Rows[0]["hy_defaultvalue"].ToString() == "yyyy-mm-dd") { lsgetputfiled = System.DateTime.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToShortDateString(); } else { //解决Float小数点后面出现N位小数乱码的问题 if (dtgetsqlfield.Rows[0]["hy_fieldtype"].ToString() == "数值") { //是否包含小数点,包含的话,取小数点后两位 if (dt.Rows[i][lsgetsqlfield].ToString().Contains(".") == true) { lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString("F2"); } else { lsgetputfiled = float.Parse(dt.Rows[i][lsgetsqlfield].ToString()).ToString(); } //lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString(); }else { lsgetputfiled = dt.Rows[i][lsgetsqlfield].ToString(); } } if (lsgetputfiled == "") lsgetputfiled = " "; //根据得到的SQL字段,得到输出字段的值end if (lsgetputfiled == "1900-1-1") lsgetputfiled = ""; ls_col += "<td width=\"" + lscolwidthper + "%\" align=\"center\">" + lsgetputfiled + "</td>"; } //如果是流程表单,则最后追加两列(当前环节和当前处理人) //表头 if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null && i == (PageNo - 1) * System.Int32.Parse(PageSize.Text)) { this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前环节</td>"; this.lbdisplaytitle.Text += "<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">当前处理人</td>"; } //数据 if (dt.Rows[i]["hy_flowid"].ToString() != "" && dt.Rows[i]["hy_flowid"].ToString() != null) { ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curtachename"].ToString() + " </td>"; ls_col += "<td width=\"10%\" align=\"center\">" + dt.Rows[i]["hy_curclrname"].ToString() + " </td>"; } dr["displaycol"] = ls_col; //将新值赋给相应的列 add ls_col = ""; tempTable.Rows.Add(dr); } int TotalRecord = dt.Rows.Count; this.sumts.Text = TotalRecord.ToString(); this.sumts2.Text = TotalRecord.ToString(); this.ShowTotalRecord.Text = TotalRecord.ToString(); //计算及显示总页数 int TotalPage; if (TotalRecord < System.Int32.Parse(PageSize.Text)) { TotalPage = 1; } else { if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0) { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1; } else { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text); } } this.ShowTotalPage.Text = TotalPage.ToString(); this.rptlist.DataSource = tempTable; this.rptlist.DataBind(); dt.Clear(); }
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(); //判断当前用户是否有删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()) || Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.tddeldoc.Visible = true; //删除 } else { this.isrole.Value = "0"; this.tddeldoc.Visible = false; //删除 } //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.DAO db = new HyoaClass.DAO(); string ls_user = ""; if (this.Request.QueryString["user"] != null) ls_user = this.Request.QueryString["user"].ToString(); string sql = ""; sql = "select * from hyp_flowmain where hy_mudelid='" + this.txtmudelid.Value + "' and hy_tableid='" + this.txttableid.Value + "' "; sql += " and hy_field1='" + ls_user + "' and left(convert(char(7),getdate(),120),4)=left(convert(char(7),hy_field31,120),4) order by hy_field31 desc "; DataTable dt = db.GetDataTable(sql); 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(); }