コード例 #1
0
    private void DataPlay()
    {
        //加载可选择的表
        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();

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

            //判断当前用户是否有保存的权限
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
            {
                this.btn_submit.Visible = true; //保存
            }
            else
            {
                this.btn_submit.Visible = false; //保存
            }
            //旧文档
            HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
            if (this.Request.QueryString["op"] == "modify")
            {
                this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
                DataTable dt = Hyoa_flowfield.Getflowfield(this.txtdocid.Value);
                if (dt.Rows.Count > 0)
                {
                    this.txttableid.Text = dt.Rows[0]["hy_tableid"].ToString();
                    this.txtmudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();

                    //得到流程编号(如果当前字段所在的表单是流程表单,则需要读取FLOWID)
                    DataTable dt_table = Hyoa_tableconfig.GetTable(this.txttableid.Text);
                    if (dt_table.Rows.Count > 0)
                    {
                        if (dt_table.Rows[0]["hy_ifflowdoc"].ToString() == "是")
                        {
                            HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
                            DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
                            if (dt_flow.Rows.Count > 0)
                            {
                                this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
                            }
                        }
                        else
                        {
                            this.txtflowid.Text = "";
                        }
                    }

                    this.txtfieldid.Text = dt.Rows[0]["hy_fieldid"].ToString();
                    this.txtfieldid.Enabled = false;
                    this.txtfieldname.Text = dt.Rows[0]["hy_fieldname"].ToString();
                    this.ddlfieldtype.SelectedValue = dt.Rows[0]["hy_fieldtype"].ToString();
                    this.txtfieldtype_old.Text = dt.Rows[0]["hy_fieldtype"].ToString();
                    this.ddlifreadonly.SelectedValue = dt.Rows[0]["hy_ifreadonly"].ToString();
                    this.ddldefaultvaluetype.SelectedValue = dt.Rows[0]["hy_defaultvaluetype"].ToString();
                    this.txtdefaultvalue.Text = dt.Rows[0]["hy_defaultvalue"].ToString();
                    this.ddloptiontype.SelectedValue = dt.Rows[0]["hy_optiontype"].ToString();
                    this.txtoptions.Text = dt.Rows[0]["hy_options"].ToString();
                    this.txtonclick.Text = dt.Rows[0]["hy_onclick"].ToString();
                    this.txtondblclick.Text = dt.Rows[0]["hy_ondblclick"].ToString();
                    this.txtonchange.Text = dt.Rows[0]["hy_onchange"].ToString();
                    this.txtonkeydown.Text = dt.Rows[0]["hy_onkeydown"].ToString();
                    this.txtonkeyup.Text = dt.Rows[0]["hy_onkeyup"].ToString();
                    this.txtonfocus.Text = dt.Rows[0]["hy_onfocus"].ToString();
                    this.txtonblur.Text = dt.Rows[0]["hy_onblur"].ToString();
                    this.txtclass.Text = dt.Rows[0]["hy_class"].ToString();
                    this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();
                    this.txtheight.Text = dt.Rows[0]["hy_height"].ToString();
                    this.ddltdnums.SelectedValue = dt.Rows[0]["hy_tdnums"].ToString();
                    this.txtsort.Text = dt.Rows[0]["hy_sort"].ToString();
                    this.txtwordlimit.Text = dt.Rows[0]["hy_wordlimit"].ToString();
                    this.ddlrequired.SelectedValue = dt.Rows[0]["hy_required"].ToString();
                    this.ddlalign.SelectedValue = dt.Rows[0]["hy_align"].ToString();
                    this.ddlifhiddle.SelectedValue = dt.Rows[0]["hy_ifhiddle"].ToString();
                    this.ddlifdbsybt.SelectedValue = dt.Rows[0]["hy_ifdbsybt"].ToString();
                }
                dt.Clear();
            }
            else
            {
                //得到模块ID
                DataTable dt = Hyoa_tableconfig.GetTable(this.txttableid.Text);
                if (dt.Rows.Count > 0)
                {
                    this.txtmudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
                }
                else
                {
                    Response.Write("<script>alert('读取表单信息出错!');history.back();</script>");
                }
                //得到流程编号(如果当前字段所在的表单是流程表单,则需要读取FLOWID)
                if (dt.Rows[0]["hy_ifflowdoc"].ToString() == "是")
                {
                    HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
                    DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.txtmudelid.Text);
                    if (dt_flow.Rows.Count > 0)
                    {
                        this.txtflowid.Text = dt_flow.Rows[0]["hy_flowid"].ToString();
                    }
                }
                else
                {
                    this.txtflowid.Text = "";
                }

                //自动获取最大排序号,然后+2
                DataTable dt_maxsort = Hyoa_flowfield.GetMaxfieldsortbytable(this.txttableid.Text);
                if (dt_maxsort.Rows.Count > 0)
                    txtsort.Text = (int.Parse(dt_maxsort.Rows[0]["hy_sort"].ToString()) + 2).ToString();
                else
                    txtsort.Text = "1";
            }
        }
    }