• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

C# HyoaClass.Hyoa_tableconfig类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中HyoaClass.Hyoa_tableconfig的典型用法代码示例。如果您正苦于以下问题:C# HyoaClass.Hyoa_tableconfig类的具体用法?C# HyoaClass.Hyoa_tableconfig怎么用?C# HyoaClass.Hyoa_tableconfig使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



HyoaClass.Hyoa_tableconfig类属于命名空间,在下文中一共展示了HyoaClass.Hyoa_tableconfig类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: btnLogin_Click

 protected void btnLogin_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
     HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
     DataTable dt = Hyoa_tableconfig.GetTables();
     string sql = "";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             //增加字段,先删除再添加
             sql = "ALTER TABLE hyc_" + dt.Rows[i]["ID"].ToString();
             sql += " ADD hy_clrylist text ";
             Hyoa_global.ExcuteSQL(sql);
             sql = "ALTER TABLE hyc_" + dt.Rows[i]["ID"].ToString();
             sql += " ADD hy_cyrylist text ";
             //Hyoa_global.ExcuteSQL(sql);   //第一次要执行一下添加字段
             //处理数据
             sql = "select * from hyc_" + dt.Rows[i]["ID"].ToString();
             DataTable dt2 = Hyoa_global.GetDataTable(sql);
             if (dt2.Rows.Count > 0)
             {
                 for (int j = 0; j < dt2.Rows.Count; j++)
                 {
                     //先置为,
                     sql = "update hyc_" + dt.Rows[i]["ID"].ToString() + " set hy_clrylist=',',hy_cyrylist=',' where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                     Hyoa_global.ExcuteSQL(sql);
                     //再根据cl表更新
                     sql = "select * from hyp_flowhistoryinfo_cl where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                     DataTable dt3 = Hyoa_global.GetDataTable(sql);
                     if (dt3.Rows.Count > 0)
                     {
                         for (int m = 0; m < dt3.Rows.Count; m++)
                         {
                             //得到初始值
                             sql = "select * from hyc_" + dt.Rows[i]["ID"].ToString() + " where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                             DataTable dt4 = Hyoa_global.GetDataTable(sql);
                             string ls_value = dt4.Rows[0]["hy_clrylist"].ToString() + dt3.Rows[m]["hy_clrid"].ToString() + ",";
                             sql = "update hyc_" + dt.Rows[i]["ID"].ToString() + " set hy_clrylist='" + ls_value + "',hy_cyrylist=',' where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                             //Response.Write(sql);
                             Hyoa_global.ExcuteSQL(sql);
                         }
                     }
                 }
             }
         }
     }
     Response.Write("更新完成");
 }
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:49,代码来源:updatehyc.aspx.cs


示例2: btndelinfo_Click

 protected void btndelinfo_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
     String[] v_uids = this.txtuids.Value.Split(',');
     for (var i = 0; i < v_uids.Length; i++)
     {
         if (v_uids[i] != "")
         {
             Hyoa_tableconfig.ID = v_uids[i];
             Hyoa_tableconfig.Delete();
         }
     }
     this.txtuids.Value = "";
     //DataPlay(1);
     DataPlay(System.Int32.Parse(this.curpage.Text));
 }
开发者ID:wjszxli,项目名称:Webapp,代码行数:16,代码来源:list_tableconfig.aspx.cs


示例3: btndelinfo_Click

 protected void btndelinfo_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
     HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
     String[] v_uids = this.txtuids.Value.Split(',');
     for (var i = 0; i < v_uids.Length; i++)
     {
         if (v_uids[i] != "")
         {
             //先删除SQL中的表
             DelSQLTableByTableid(v_uids[i]);
             //删除配置表
             Hyoa_tableconfig.ID = v_uids[i];
             Hyoa_tableconfig.Delete();
             //删除表字段
             string ls_sql = "delete from hyt_flowfield where hy_tableid='"+v_uids[i]+"'";
             Hyoa_global.ExcuteSQL_BASE(ls_sql);
         }
     }
     this.txtuids.Value = "";
     //DataPlay(1);
     DataPlay(System.Int32.Parse(this.curpage.Text));
 }
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:23,代码来源:list_tableconfig.aspx.cs


示例4: ddlmudelid_SelectedIndexChanged

 protected void ddlmudelid_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (this.ddlmudelid.SelectedIndex != 0)
     {
         this.ddltableid.Items.Clear();
         //根据模块ID得到表单ID
         HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
         DataTable dt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
         if (dt.Rows.Count > 0)
         {
             for (var i = 0; i < dt.Rows.Count; i++)
             {
                 this.ddltableid.Items.Insert(i, new ListItem(dt.Rows[i]["hy_name"].ToString(), dt.Rows[i]["ID"].ToString()));
             }
             this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
             this.ddltableid.Attributes.Add("onchange ", "mudelidonchang() ");
         }
     }
     else
     {
         //清空
         this.ddltableid.Items.Clear();
     }
 }
开发者ID:wjszxli,项目名称:Webapp,代码行数:24,代码来源:main_listconfig.aspx.cs


示例5: DataPlay


//.........这里部分代码省略.........
            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();
                }
            }
        }
    }
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:main_ml2.aspx.cs


示例6: Page_Load

    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.txttablerole.Value = dt_tableconfig.Rows[0]["hy_tablerole"].ToString();
                dt_tableconfig.Clear();
            }
            if (this.Request.QueryString["listid"] != null)
            {
                string ls_listid = "";
                ls_listid = this.Request.QueryString["listid"].ToString();
                if (ls_listid.Contains(","))
                    ls_listid = ls_listid.Substring(0, ls_listid.IndexOf(","));

                this.txtlistid.Text = ls_listid;
            }
            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 + "&listid=" + this.txtlistid.Text;
                getreturnurl(); //特殊返回地址
            }
        }
        DataPlay();
        //add by wjs 20141103 start 给合同加matherid
        if (this.Request.QueryString["motherid"] != null)
        {
            this.hy_motherid.Text = this.Request.QueryString["motherid"].ToString();
        }
        // add by wjs 20141112 在付款流程结束时将提交改为付款
        //最后一环节
        if (this.txtiflasttache.Value == "1" && this.hy_tableid.Text == "Tablefpbd")
        {
            this.btn_nextstep.Value = "付款";
        }
    }
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:84,代码来源:main.aspx.cs


示例7: DataPlay

    //加载主表单    Written by xf 20110515
    private void DataPlay()
    {
        txtsavefields.Text = "";
        txtsavefields_sx.Text = "";

        if (this.Request.QueryString["op"] != null)
        {
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();

            #region 新文档
            if (this.Request.QueryString["op"] == "add")
            {
                this.td_ydry.Visible = false; //新文档时,“已读人员”按钮隐藏
                this.txtiffirsttache.Value = "1"; //新文档时,“是否第一环节”置为1

                //文档ID(保存POST到当前页面时,DOCID不重新加载)
                if (!this.IsPostBack)
                {
                    this.txtdocid.Value = Hyoa_global.GetRandom();
                    this.hy_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                }
                this.hy_djrid.Text = this.Session["hyuid"].ToString();
                this.hy_djrname.Text = this.Session["hyuname"].ToString();
                this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
                this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();

                HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
                if (dt_tableconfig.Rows.Count > 0)
                {
                    if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
                    {
                        //根据模块ID得到流程信息
                        HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
                        DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
                        if (dt.Rows.Count > 0)
                        {
                            //判断当前用户是否有登记权限
                            //得到第一环节ID
                            string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
                            if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
                            {
                                this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
                                this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
                                this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
                                this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
                                this.hy_curclrid.Text = this.Session["hyuid"].ToString();
                                this.hy_curclrname.Text = this.Session["hyuname"].ToString();
                                this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
                                this.txtSystemClRight.Value = "1";

                                //-------条件流程start-------
                                HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
                                DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
                                if (dt_firsttache.Rows.Count > 0)
                                {
                                    if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
                                        ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
                                }
                                //-------条件流程end-------
                            }
                            else
                            {
                                if (this.txtifpop.Value == "")
                                {
                                    this.td_submit.Visible = false;
                                    this.td_nextstep.Visible = false;
                                    Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');window.location='" + this.txturl.Value + "';</script>");
                                    return;
                                }
                                else
                                {
                                    this.td_submit.Visible = false;
                                    this.td_nextstep.Visible = false;
                                    Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>");
                                    return;
                                }
                            }
                        }
                        dt.Clear();
                        this.td_nextstep.Visible = true; //提交
                    }
                }
                //加载页面
                if (this.hy_tableid.Text == "Tablefpbd")
                {
                        this.td_dc.Visible = true;
                }
                GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
                this.td_submit.Visible = true; //保存
                hywebopen_newdoc();     //新文档OPEN时的特殊处理

            }
            #endregion

            #region 旧文档
            if (this.Request.QueryString["op"] == "modify")
            {
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:101,代码来源:main.aspx.cs


示例8: DataPlay

    //打开文档显示
    private void DataPlay()
    {
        HyoaClass.DAO db = new HyoaClass.DAO();
        StringBuilder sb = new StringBuilder();

        string ls_flag = "0";  //是否为授权人员
        string ls_uid = this.Session["hyuid"].ToString();
        HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
        if (Hyoa_global.isHaveRole("Role_search", ls_uid))
        {
            ls_flag = "1";
        }
        int ls_Container = 1;
        string ls_docids = "";
        string sql1 = "";
        //查询关键字按|分割
        string[] lv_key = ls_keywords.Split('|');

        //读取待查模块的字段
        if (ls_Modelid != "--请选择--")
        {
            sql1 = "select *,(select hy_mudelname from hyt_mudel where hy_mudelid=a.hy_mudelid) as hy_name from hyt_searchconfig a where hy_ifsearch='是' and hy_mudelid='" + ls_Modelid + "'";
            sql1 += " order by hy_sort ";
        }
        else
        {
            sql1 = "select *,(select hy_mudelname from hyt_mudel where hy_mudelid=a.hy_mudelid) as hy_name from hyt_searchconfig a where hy_ifsearch='是'";
            sql1 += " order by hy_sort ";
        }
        //Response.Write(sql1);
        //return;

        DataTable dt = db.GetDataTable(sql1);
        if (dt.Rows.Count > 0)
        {
            //循环查询模块
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string sql2 = "";
                string ls_or = "";
                string ls_mid = dt.Rows[i]["hy_mudelid"].ToString();
                string ls_mname = dt.Rows[i]["hy_name"].ToString();
                string ls_tid = dt.Rows[i]["hy_tableid"].ToString();
                string ls_cid = dt.Rows[i]["hy_columnshowid"].ToString();  //hy_field1,hy_bt,hy_content1
                string ls_xsid = dt.Rows[i]["hy_xszdid"].ToString();
                string ls_kckryid = "+" + dt.Rows[i]["hy_kckryid"].ToString() + "+";

                //根据表单ID得到表单信息
                string ls_tname = "", ls_ifflow = "", ls_ifgk = "", ls_ifxssy = "";
                HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(ls_tid);
                if (dt_tableconfig.Rows.Count > 0)
                {
                    ls_tname = dt_tableconfig.Rows[0]["hy_name"].ToString(); //表单名称
                    ls_ifflow = dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString();//是否为流程表单
                    ls_ifgk = dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString();  //流程结束后是否公开
                    ls_ifxssy = dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString();  //是否显示所有记录
                }
                dt_tableconfig.Clear();

                if (ls_flag == "1")
                {
                    //授权查看所有人员
                    sql2 = "select * from hyp_flowmain a where 1=1 ";
                }
                else
                {
                    //某模块是否授权为可查看人员
                    if (ls_kckryid.IndexOf("+" + ls_uid + "+") >= 0)
                    {
                        sql2 = "select * from hyp_flowmain a where 1=1 ";
                    }
                    else
                    {
                        //未授权人员根据表单配置判断模块的数据显示情况
                        if (ls_ifflow == "是")
                        {
                            sql2 = "select * from hyp_flowmain a,hyp_flowhistoryinfo_cl b  where a.DOCID=b.DOCID ";

                            //流程模块
                            if (ls_ifgk == "是")
                            {
                                //流程结束后公开
                                sql2 += " and (','+b.hy_clrid+',' like '%," + ls_uid + ",%' or ','+b.hy_cyrid+',' like '%," + ls_uid + ",%' or a.hy_curtacheid='**' ) ";
                            }
                            if (ls_ifgk == "否")
                            {
                                //流程结束后不公开
                                sql2 += " and (','+b.hy_clrid+',' like '%," + ls_uid + ",%' or ','+b.hy_cyrid+',' like '%," + ls_uid + ",%') ";
                            }
                        }
                        if (ls_ifflow == "否")
                        {
                            //非流程模块
                            if (ls_ifxssy == "是")
                            {
                                //非流程显示所有记录
                                sql2 = "select * from hyp_flowmain a where 1=1 ";
                            }
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:Search_All.aspx.cs


示例9: Page_Load

    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["listid"] != null)
            {
                string ls_listid = "";
                ls_listid = this.Request.QueryString["listid"].ToString();
                if (ls_listid.Contains(","))
                    ls_listid = ls_listid.Substring(0, ls_listid.IndexOf(","));

                this.txtlistid.Text = ls_listid;
            }
            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 + "&listid=" + this.txtlistid.Text;
            }
        }
        DataPlay();
    }
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:74,代码来源:main_print.aspx.cs


示例10: Button_Save_Click

    //保存
    protected void Button_Save_Click(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() == "")
            this.Response.Redirect("../login.aspx");

        string ls_tip = "保存成功!";

        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
        HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
        HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();

        //判断目的表单ID是否重复
        DataTable dt_table = Hyoa_tableconfig.GetTable(txttableidbymd.Text);
        if (dt_table.Rows.Count > 0)
        {
            Response.Write("<script>alert('目的表单ID已存在!');</script>");
            return;
        }

        //插入TABLE配置
        DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.lbmudelidbysource.Text);
        if (tableconfigdt.Rows.Count > 0)
        {
            Hyoa_tableconfig.ID = txttableidbymd.Text;
            Hyoa_tableconfig.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
            Hyoa_tableconfig.hy_name = this.txttablenamebymd.Text;
            Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
            Hyoa_tableconfig.hy_sort = float.Parse(this.txttablesortbymd.Text);
            Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
            Hyoa_tableconfig.hy_ifdisplayall = tableconfigdt.Rows[0]["hy_ifdisplayall"].ToString();
            Hyoa_tableconfig.hy_ispuballByflowYB = tableconfigdt.Rows[0]["hy_ispuballByflowYB"].ToString();
            Hyoa_tableconfig.hy_tablerole = tableconfigdt.Rows[0]["hy_tablerole"].ToString();
            Hyoa_tableconfig.hy_ifcomment = tableconfigdt.Rows[0]["hy_ifcomment"].ToString();
            Hyoa_tableconfig.hy_colnum = float.Parse(tableconfigdt.Rows[0]["hy_colnum"].ToString());
            Hyoa_tableconfig.hy_field1 = tableconfigdt.Rows[0]["hy_field1"].ToString();
            Hyoa_tableconfig.hy_field2 = tableconfigdt.Rows[0]["hy_field2"].ToString();
            Hyoa_tableconfig.hy_field3 = tableconfigdt.Rows[0]["hy_field3"].ToString();
            Hyoa_tableconfig.hy_field4 = tableconfigdt.Rows[0]["hy_field4"].ToString();
            Hyoa_tableconfig.hy_field5 = tableconfigdt.Rows[0]["hy_field5"].ToString();
            Hyoa_tableconfig.Insert();
        }

        //插入FIELD配置
        int i;
        DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.lbtableidbysorce.Text);
        if (flowfielddt.Rows.Count > 0)
        {
            for (i = 0; i < flowfielddt.Rows.Count; i++)
            {
                Hyoa_flowfield.ID = Hyoa_global.GetRandom();
                Hyoa_flowfield.hy_tableid = txttableidbymd.Text;
                Hyoa_flowfield.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
                Hyoa_flowfield.hy_flowid = this.txtflowidbymd.Text;
                Hyoa_flowfield.hy_fieldid = flowfielddt.Rows[i]["hy_fieldid"].ToString();
                Hyoa_flowfield.hy_fieldname = flowfielddt.Rows[i]["hy_fieldname"].ToString();
                Hyoa_flowfield.hy_fieldtype = flowfielddt.Rows[i]["hy_fieldtype"].ToString();
                Hyoa_flowfield.hy_ifreadonly = flowfielddt.Rows[i]["hy_ifreadonly"].ToString();
                Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(flowfielddt.Rows[i]["hy_defaultvaluetype"].ToString());
                Hyoa_flowfield.hy_defaultvalue = flowfielddt.Rows[i]["hy_defaultvalue"].ToString();
                Hyoa_flowfield.hy_optiontype = System.Int32.Parse(flowfielddt.Rows[i]["hy_optiontype"].ToString());
                Hyoa_flowfield.hy_options = flowfielddt.Rows[i]["hy_options"].ToString();
                Hyoa_flowfield.hy_onclick = flowfielddt.Rows[i]["hy_onclick"].ToString();
                Hyoa_flowfield.hy_ondblclick = flowfielddt.Rows[i]["hy_ondblclick"].ToString();
                Hyoa_flowfield.hy_onchange = flowfielddt.Rows[i]["hy_onchange"].ToString();
                Hyoa_flowfield.hy_onkeydown = flowfielddt.Rows[i]["hy_onkeydown"].ToString();
                Hyoa_flowfield.hy_onkeyup = flowfielddt.Rows[i]["hy_onkeyup"].ToString();
                Hyoa_flowfield.hy_sqlfield = flowfielddt.Rows[i]["hy_sqlfield"].ToString();
                Hyoa_flowfield.hy_class = flowfielddt.Rows[i]["hy_class"].ToString();
                Hyoa_flowfield.hy_width = flowfielddt.Rows[i]["hy_width"].ToString();
                Hyoa_flowfield.hy_height = flowfielddt.Rows[i]["hy_height"].ToString();
                Hyoa_flowfield.hy_tdnums = System.Int32.Parse(flowfielddt.Rows[i]["hy_tdnums"].ToString());
                Hyoa_flowfield.hy_config = flowfielddt.Rows[i]["hy_config"].ToString();
                Hyoa_flowfield.hy_sort = float.Parse(flowfielddt.Rows[i]["hy_sort"].ToString());
                Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(flowfielddt.Rows[i]["hy_wordlimit"].ToString());
                Hyoa_flowfield.hy_required = flowfielddt.Rows[i]["hy_required"].ToString();
                Hyoa_flowfield.hy_align = flowfielddt.Rows[i]["hy_align"].ToString();
                Hyoa_flowfield.hy_ifhiddle = flowfielddt.Rows[i]["hy_ifhiddle"].ToString();
                Hyoa_flowfield.hy_ifdbsybt = flowfielddt.Rows[i]["hy_ifdbsybt"].ToString();
                Hyoa_flowfield.hy_field1 = flowfielddt.Rows[i]["hy_field1"].ToString();
                Hyoa_flowfield.hy_field2 = flowfielddt.Rows[i]["hy_field2"].ToString();
                Hyoa_flowfield.hy_field3 = flowfielddt.Rows[i]["hy_field3"].ToString();
                Hyoa_flowfield.hy_field4 = flowfielddt.Rows[i]["hy_field4"].ToString();
                Hyoa_flowfield.hy_field5 = flowfielddt.Rows[i]["hy_field5"].ToString();
                Hyoa_flowfield.Insert();
            }
        }

        //生成SQL/ORACLE中的表
        string sql = "";
        if (Session["conntype"].ToString() == "SQL")
        {
            sql = "select * into hyc_" + txttableidbymd.Text + " from hyc_" + this.lbtableidbysorce.Text + " where 1=0";
        }
        if (Session["conntype"].ToString() == "ORACLE")
        {
            sql = "create table hyc_" + txttableidbymd.Text + " as select * from hyc_" + this.lbtableidbysorce.Text + " where 1=2";
        }
        Hyoa_global.ExcuteSQL(sql);

//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:101,代码来源:main_tablecopy.aspx.cs


示例11: Page_Load

    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;
            }

        }
    }
开发者ID:wjszxli,项目名称:Webapp,代码行数:69,代码来源:list_db.aspx.cs


示例12: onloadjs

    //加载当前表单执行的onload代码      Written by xf 20110621
    public string onloadjs()
    {
        string ls_mid = "";
        if (this.Request.QueryString["mid"] != null)
        {
            ls_mid = this.Request.QueryString["mid"].ToString();
            if (ls_mid.Contains(","))
                ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
        }
        string ls_tableid = "";
        if (this.Request.QueryString["tableid"] != null)
        {
            ls_tableid = this.Request.QueryString["tableid"].ToString();
            if (ls_tableid.Contains(","))
                ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
        }
        string ls_return = "";
        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
        DataTable dt = Hyoa_tableconfig.GetTablesbymudelidandtableid(ls_mid, ls_tableid);
        if (dt.Rows.Count > 0)
            ls_return = dt.Rows[0]["hy_onload"].ToString();

        return ls_return;
    }
开发者ID:wjszxli,项目名称:hyoav10_gdcrm,代码行数:25,代码来源:main_look.aspx.cs


示例13: DataPlay

    //加载主表单    Written by xf 20110515
    private void DataPlay()
    {
        txtsavefields.Text = "";
        txtsavefields_sx.Text = "";

        if (this.Request.QueryString["op"] != null)
        {
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            //旧文档
            if (this.Request.QueryString["op"] == "modify")
            {
                this.td_browseflow.Visible = true;  //查看流程
                if (this.Request.QueryString["docid"] != null)
                {
                    this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
                    string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
                    DataTable dt = Hyoa_global.GetDataTable(sql);
                    if (dt.Rows.Count > 0)
                    {
                        this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
                        this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
                        this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
                        this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
                        this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
                        this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
                        this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
                        this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
                        this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
                        this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
                        this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
                        this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
                        this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
                        this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
                        this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
                        this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
                        this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
                        this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
                        this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
                        this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
                        this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
                        UpdateReadFlag();  //打开时添加阅读情况
                    }
                    dt.Clear();

                    //流程文档
                    if (this.txtifhaveflow.Value == "是")
                    {
                        //流程已结束
                        if (this.hy_curtacheid.Text == "**")
                        {
                            this.lblcurtachenameshow.Text = "流程已结束";
                        }
                        //加载页面
                        GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
                    }
                    else
                    {
                        this.lblcurtachenameshow.Text = this.lbltablename.Text;
                        //非流程表单
                        this.td_browseflow.Visible = false;

                        //加载主表单页面
                        GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");

                        //----加载评论页面 s add by xf 2011-11-19-----
                        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
                        DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
                        if (dt_tableconfig_forpinglun.Rows.Count > 0)
                        {
                            if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
                            {
                                if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
                                {
  

鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# HyperEdgeId类代码示例发布时间:2022-05-24
下一篇:
C# HyoaClass.Hyoa_mudel类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap