Example #1
0
        public bool Update(ZoomLa.Model.M_ModelField MField)
        {
            string strSql = "PR_ModelField_Update";

            SqlParameter[] cmdParams = GetParameters(MField);
            return(SqlHelper.ExecuteProc(strSql, cmdParams));
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            this.GetIsOk();
            int ModelID = DataConverter.CLng(this.HdfModelID.Value);
            int FieldID = DataConverter.CLng(this.HdfFieldID.Value);
            string text = this.Name.Text;
            string str2 = this.Alias.Text;
            string str3 = this.Description.Text;
            bool flag = DataConverter.CBool(this.IsNotNull.SelectedValue);
            bool flag2 = DataConverter.CBool(this.IsSearchForm.SelectedValue);
            string selectedValue = this.Type.SelectedValue;
            string str7 = "";
            switch (selectedValue)
            {
                //单行文本
                case "TextType":
                    str7 = "TitleSize=" + this.TitleSize.Text + ",IsPassword="******",DefaultValue=" + this.TextType_DefaultValue.Text + "";
                    break;
                //多行文本(不支持Html)
                case "MultipleTextType":
                    str7 = "Width=" + this.MultipleTextType_Width.Text + ",Height=" + this.MultipleTextType_Height.Text + "";
                    break;
                //多行文本(支持Html)
                case "MultipleHtmlType":
                    str7 = "Width=" + this.MultipleHtmlType_Width.Text + ",Height=" + this.MultipleHtmlType_Height.Text + ",IsEditor=" + this.IsEditor.SelectedValue + "";
                    break;
                //单选项
                case "OptionType":
                    str7 = "" + this.RadioType_Type.SelectedValue + "=" + this.RadioType_Content.Text.Trim().Replace(" ", "").Replace("\r\n", "|") + ",Property=" + this.RadioType_Property.Text + ",Default=" + this.RadioType_Default.Text + "";
                    break;
                //多选项
                case "ListBoxType":
                    str7 = "" + this.ListBoxType_Type.SelectedValue + "=" + this.ListBoxType_Content.Text.Trim().Replace(" ", "").Replace("\r\n", "|") + "";
                    break;
                //数字
                case "NumType":
                    str7 = "TitleSize=" + this.NumberType_TitleSize.Text + ",NumberType=" + this.NumberType_Style.SelectedValue + ",DefaultValue=" + this.NumberType_DefaultValue.Text + "";
                    break;
                //日期时间
                case "DateType":
                    str7 = "";
                    break;
                //图片
                case "PicType":
                    str7 = "Warter=" + this.RBLPicWaterMark.SelectedValue + ",MaxPicSize=" + this.TxtSPicSize.Text + ",PicFileExt=" + this.TxtPicExt.Text;
                    break;
                //多图片
                case "MultiPicType":
                    str7 = "ChkThumb=" + (this.ChkThumb.Checked ? "1" : "0") + ",ThumbField=" + this.TxtThumb.Text + ",Warter=" + this.RBLPicWaterMark.SelectedValue + ",MaxPicSize=" + this.TxtSPicSize.Text + ",PicFileExt=" + this.TextImageType.Text;
                    break;
                //文件
                case "FileType":
                    str7 = "ChkFileSize=" + (this.ChkFileSize.Checked ? "1" : "0") + ",FileSizeField=" + this.TxtFileSizeField.Text + ",MaxFileSize=" + this.TxtMaxFileSize.Text + ",UploadFileExt=" + this.TxtUploadFileType.Text;

                    break;
                //运行平台
                case "OperatingType":
                    str7 = "TitleSize=" + this.OperatingType_TitleSize.Text + ",OperatingList=" + this.TxtOperatingOption.Text.Trim().Replace(" ", "").Replace("\r\n", "|") + ",DefaultValue=" + this.OperatingType_DefaultValue.Text;
                    break;
                //超链接
                case "SuperLinkType":
                    str7 = "TitleSize=" + this.SuperLinkType_TitleSize.Text + ",DefaultValue=" + this.SuperLinkType_DefaultValue.Text;
                    break;
                default:
                    str7 = "";
                    break;
            }
            M_ModelField modelfield = new M_ModelField();
            modelfield.ModelID = ModelID;
            modelfield.FieldID = FieldID;
            modelfield.FieldName = text;
            modelfield.FieldAlias = str2;
            modelfield.Description = str3;
            modelfield.FieldTips = this.Tips.Text.Trim();
            modelfield.FieldType = selectedValue;
            modelfield.Content = str7;
            modelfield.IsNotNull = flag;
            modelfield.IsSearchForm = flag2;
            //modelfield.OrderID = DataConverter.CLng(this.hdfOrder.Value);

            this.bll.Update(modelfield);
            //this.bll.ModelFieldHtml(ModelID);
            Response.Redirect("ModelField.aspx?ModelID=" + ModelID.ToString());
        }
Example #3
0
        private void InitFileExtArr()
        {
            this.m_ModelId = DataConverter.CLng(this.ViewState["ModelId"].ToString());
            this.m_FieldName = this.ViewState["FieldName"].ToString();
            this.m_ModelField = bfield.GetModelByFieldName(this.m_ModelId, this.m_FieldName);
            string[] Setting = this.m_ModelField.Content.Split(new char[] { ',' });
            string ChkThumb = Setting[0].Split(new char[] { '=' })[1];

            string ThumbField = Setting[1].Split(new char[] { '=' })[1];
            this.ViewState["ThumbField"] = ThumbField;
            this.m_MaxFileSize = DataConverter.CLng(Setting[2].Split(new char[] { '=' })[1]);
            this.ViewState["MaxFileSize"] = Setting[3].Split(new char[] { '=' })[1];
            this.m_FileExtArr = Setting[4].Split(new char[] { '=' })[1];
            this.ViewState["FileExtArr"] = Setting[4].Split(new char[] { '=' })[1];
        }
Example #4
0
 /// <summary>
 /// 将模型信息的各属性值传递到参数中
 /// </summary>
 /// <param name="administratorInfo"></param>
 /// <returns></returns>
 private static SqlParameter[] GetParameters(M_ModelField ModelField)
 {
     SqlParameter[] parameter = new SqlParameter[] {
         new SqlParameter("@FieldID", SqlDbType.Int, 4),
         new SqlParameter("@ModelID", SqlDbType.Int, 4),
         new SqlParameter("@FieldName", SqlDbType.NVarChar, 50),
         new SqlParameter("@FieldAlias", SqlDbType.NVarChar, 20),
         new SqlParameter("@FieldTips", SqlDbType.NVarChar, 50),
         new SqlParameter("@FieldType", SqlDbType.NVarChar, 50),
         new SqlParameter("@Description", SqlDbType.NVarChar, 255),
         new SqlParameter("@Content", SqlDbType.NText),
         new SqlParameter("@IsNotNull", SqlDbType.Bit),
         new SqlParameter("@IsSearchForm", SqlDbType.Bit)
     };
     parameter[0].Value = ModelField.FieldID;
     parameter[1].Value = ModelField.ModelID;
     parameter[2].Value = ModelField.FieldName;
     parameter[3].Value = ModelField.FieldAlias;
     parameter[4].Value = ModelField.FieldTips;
     parameter[5].Value = ModelField.FieldType;
     parameter[6].Value = ModelField.Description;
     parameter[7].Value = ModelField.Content;
     parameter[8].Value = ModelField.IsNotNull;
     parameter[9].Value = ModelField.IsSearchForm;
     return parameter;
 }
 private void GetShow(M_ModelField field)
 {
     this.Name.Text = field.FieldName;
     this.Name.Enabled = false;
     this.Alias.Text = field.FieldAlias;
     this.Description.Text = field.Description;
     this.Tips.Text = field.FieldTips;
     this.IsNotNull.SelectedValue = field.IsNotNull.ToString();
     this.IsSearchForm.SelectedValue = field.IsSearchForm.ToString();
     string type = field.FieldType;
     string content = field.Content;
     this.Type.SelectedValue = type;
     this.Type.Enabled = false;
     this.hdfOrder.Value = field.OrderID.ToString();
     switch (type)
     {
         //单行文本
         case "TextType":
             this.TitleSize.Text = this.bll.GetFieldContent(content, 0, 1);
             this.IsPassword.SelectedValue = this.bll.GetFieldContent(content, 1, 1);
             this.TextType_DefaultValue.Text = this.bll.GetFieldContent(content, 2, 1);
             break;
         //多行文本(不支持Html)
         case "MultipleTextType":
             this.MultipleTextType_Width.Text = this.bll.GetFieldContent(content, 0, 1);
             this.MultipleTextType_Height.Text = this.bll.GetFieldContent(content, 1, 1);
             this.DivMultipleTextType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //多行文本(支持Html)
         case "MultipleHtmlType":
             this.MultipleHtmlType_Width.Text = this.bll.GetFieldContent(content, 0, 1);
             this.MultipleHtmlType_Height.Text = this.bll.GetFieldContent(content, 1, 1);
             this.IsEditor.SelectedValue = this.bll.GetFieldContent(content, 2, 1);
             this.DivMultipleHtmlType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //单选项
         case "OptionType":
             this.RadioType_Content.Text = this.bll.GetFieldContent(content, 0, 1).Replace("|", "\r\n");
             this.RadioType_Type.SelectedValue = this.bll.GetFieldContent(content, 0, 0);
             this.RadioType_Property.SelectedValue = this.bll.GetFieldContent(content, 1, 1).ToString();
             this.RadioType_Default.Text = this.bll.GetFieldContent(content, 2, 1).ToString();
             this.DivOptionType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //多选项
         case "ListBoxType":
             this.ListBoxType_Content.Text = this.bll.GetFieldContent(content, 0, 1).Replace("|", "\r\n");
             this.ListBoxType_Type.SelectedValue = this.bll.GetFieldContent(content, 0, 0);
             this.DivListBoxType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //数字
         case "NumType":
             this.NumberType_TitleSize.Text = this.bll.GetFieldContent(content, 0, 1);
             this.NumberType_Style.SelectedValue = this.bll.GetFieldContent(content, 1, 1);
             this.NumberType_Style.Enabled = false;
             this.NumberType_DefaultValue.Text = this.bll.GetFieldContent(content, 2, 1);
             this.DivNumType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //日期时间
         case "DateType":
             this.DivDateType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //图片
         case "PicType":
             this.RBLPicWaterMark.SelectedValue = this.bll.GetFieldContent(content, 0, 1);
             this.TxtSPicSize.Text = this.bll.GetFieldContent(content, 1, 1);
             this.TxtPicExt.Text = this.bll.GetFieldContent(content, 2, 1);
             this.DivPicType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //多图片
         case "MultiPicType":
             if (DataConverter.CBool(this.bll.GetFieldContent(content, 0, 1)))
             {
                 this.ChkThumb.Checked = true;
                 this.TxtThumb.Text = this.bll.GetFieldContent(content, 1, 1);
             }
             else
             {
                 this.ChkThumb.Checked = false;
                 this.TxtThumb.Text = "";
             }
             this.ChkThumb.Enabled = false;
             this.TxtThumb.Enabled = false;
             this.RBLWaterMark.SelectedValue = this.bll.GetFieldContent(content, 2, 1);
             this.TxtPicSize.Text = this.bll.GetFieldContent(content, 3, 1);
             this.TextImageType.Text = this.bll.GetFieldContent(content, 4, 1);
             this.DivMultiPicType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //文件
         case "FileType":
             if (DataConverter.CBool(this.bll.GetFieldContent(content, 0, 1)))
             {
                 this.ChkFileSize.Checked = true;
                 this.TxtFileSizeField.Text = this.bll.GetFieldContent(content, 1, 1);
             }
             else
             {
                 this.ChkFileSize.Checked = false;
                 this.TxtFileSizeField.Text = "";
             }
             this.ChkFileSize.Enabled = false;
             this.TxtFileSizeField.Enabled = false;
             this.TxtMaxFileSize.Text = this.bll.GetFieldContent(content, 2, 1);
             this.TxtUploadFileType.Text = this.bll.GetFieldContent(content, 3, 1);
             this.DivFileType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //运行平台
         case "OperatingType":
             this.TxtOperatingOption.Text = this.bll.GetFieldContent(content, 1, 1).Replace("|", "\r\n");
             this.OperatingType_TitleSize.Text = this.bll.GetFieldContent(content, 0, 1);
             this.OperatingType_DefaultValue.Text = this.bll.GetFieldContent(content, 2, 1);
             this.DivOperatingType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
         //超链接
         case "SuperLinkType":
             this.SuperLinkType_TitleSize.Text = this.bll.GetFieldContent(content, 0, 1);
             this.SuperLinkType_DefaultValue.Text = this.bll.GetFieldContent(content, 1, 1);
             this.DivSuperLinkType.Style["display"] = "";
             this.DivTextType.Style["display"] = "none";
             break;
     }
 }
Example #6
0
 /// <summary>
 /// 从DataReader中读取模型记录
 /// </summary>
 /// <param name="rdr">DataReader</param>
 /// <returns>M_ModelField 模型信息</returns>
 private static M_ModelField GetFieldFromReader(SqlDataReader rdr)
 {
     M_ModelField info = new M_ModelField();
     info.FieldID = DataConverter.CLng(rdr["FieldID"]);
     info.ModelID = DataConverter.CLng(rdr["ModelID"]);
     info.FieldName = rdr["FieldName"].ToString();
     info.FieldAlias = rdr["FieldAlias"].ToString();
     info.FieldTips = rdr["FieldTips"].ToString();
     info.Description = rdr["Description"].ToString();
     info.IsNotNull = DataConverter.CBool(rdr["IsNotNull"].ToString());
     info.IsSearchForm = DataConverter.CBool(rdr["IsSearchForm"].ToString());
     info.FieldType = rdr["FieldType"].ToString();
     info.Content = rdr["Content"].ToString();
     info.OrderID = DataConverter.CLng(rdr["OrderID"]);
     return info;
 }
Example #7
0
 public bool UpdateOrder(M_ModelField info)
 {
     string strSql = "Update ZL_ModelField Set OrderId=@OrderId Where FieldID=@FieldID";
     SqlParameter[] cmdParams = new SqlParameter[] {
         new SqlParameter("@OrderId", SqlDbType.Int),
         new SqlParameter("@FieldID", SqlDbType.Int)
     };
     cmdParams[0].Value = info.OrderID;
     cmdParams[1].Value = info.FieldID;
     return SqlHelper.ExecuteSql(strSql, cmdParams);
 }
Example #8
0
 public void Add(M_ModelField info)
 {
     this.dal.Add(info);
 }
Example #9
0
 public void UpdateOrder(M_ModelField info)
 {
     this.dal.UpdateOrder(info);
 }
Example #10
0
 private void InitFileExtArr()
 {
     this.m_ModelId = DataConverter.CLng(this.ViewState["ModelId"].ToString());
     this.m_FieldName=this.ViewState["FieldName"].ToString();
     this.m_ModelField = bfield.GetModelByFieldName(this.m_ModelId, this.m_FieldName);
     string[] Setting=this.m_ModelField.Content.Split(new char[]{','});
     if (this.m_ModelField.FieldType == "PicType")
     {
         this.m_MaxFileSize = DataConverter.CLng(Setting[1].Split(new char[] { '=' })[1]);
         this.ViewState["MaxFileSize"] = Setting[1].Split(new char[] { '=' })[1];
         this.m_FileExtArr = Setting[2].Split(new char[] { '=' })[1];
         this.ViewState["FileExtArr"] = Setting[2].Split(new char[] { '=' })[1];
         this.ViewState["UploadType"] = "PicType";
     }
     if (this.m_ModelField.FieldType == "FileType")
     {
         string chkSize = Setting[0].Split(new char[] { '=' })[1];
         string SizeField = Setting[1].Split(new char[] { '=' })[1];
         this.ViewState["SizeField"] = SizeField;
         this.m_MaxFileSize = DataConverter.CLng(Setting[2].Split(new char[] { '=' })[1]);
         this.ViewState["MaxFileSize"] = Setting[2].Split(new char[] { '=' })[1];
         this.m_FileExtArr = Setting[3].Split(new char[] { '=' })[1];
         this.ViewState["FileExtArr"] = Setting[3].Split(new char[] { '=' })[1];
         this.ViewState["UploadType"] = "FileType";
     }
 }