/// <summary> /// 根据字段类型ID显示类型名称和ICO图标 /// </summary> /// <param name="Type">类型ID</param> /// <returns></returns> public static string GetTypeName(object Type) { string Results = ""; switch (StringDeal.ToInt(Type)) { case 1: #region 单行文本 Results = "<img src='../images/SingleLine.gif' align='absmiddle'>单行文本"; break; #endregion case 2: #region 多行文本 Results = "<img src='../images/MultiLine.gif' align='absmiddle'>多行文本"; break; #endregion case 3: #region 编辑器 Results = "<img src='../images/Editor.gif' align='absmiddle'>编辑器"; break; #endregion case 4: #region 拉菜单,多选,单选 Results = "<img src='../images/Select.gif' align='absmiddle'>下拉菜单,多选,单选"; break; #endregion case 5: #region 数字 Results = "<img src='../images/Number.gif' align='absmiddle'>数字"; break; #endregion case 6: #region 日期/时间日期 Results = "<img src='../images/DateTime.gif' align='absmiddle'>日期/时间日期"; break; #endregion case 7: #region 图片上传 Results = "<img src='../images/Image.gif' align='absmiddle'>图片上传"; break; #endregion case 8: #region 文件上传 Results = "<img src='../images/File.gif' align='absmiddle'>文件上传"; break; #endregion } return(Results); }
/// <summary> /// 获取并过滤表单信息 /// </summary> /// <param name="Type">字段类型</param> /// <param name="Val">获取的值</param> /// <returns></returns> public static string FormatField(string Type, string Field) { string Val = System.Web.HttpContext.Current.Request.Form[Field]; switch (Type) { case "1": #region 单行文本 return("'" + StringDeal.ReplaceSql(Val) + "'"); #endregion case "2": #region 多行文本 return("'" + StringDeal.ReplaceSql(Val) + "'"); #endregion case "3": #region 编辑器 return("'" + Val.Replace("'", "''") + "'"); #endregion case "4": #region 拉菜单,多选,单选 return("'" + Val + "'"); #endregion case "5": #region 数字 return(Val); #endregion case "6": #region 日期/时间日期 return("'" + StringDeal.GetDateTime(Val, "yyyy-MM-dd HH:mm") + "'"); #endregion case "7": #region 图片上传 return("'" + StringDeal.ReplaceSql(Val) + "'"); #endregion case "8": #region 文件上传 return("'" + StringDeal.ReplaceSql(Val)); #endregion default: #region 单行文本 return("'" + StringDeal.ReplaceSql(Val) + "'"); #endregion } }
public string gettxt2(string postStr) { //你好! postStr = postStr.Replace("!", ""); postStr = postStr.Replace("!", ""); postStr = StringDeal.RemoveHtml(postStr); if (postStr == "抢月饼" || postStr == "红包") { Repeater += "<MsgType><![CDATA[text]]></MsgType>"; Repeater += "<Content><![CDATA[Hi,格友你好。抢月饼,赢微信红包已经结束,你来晚了。欢迎持续关注我们的微信,格列佛―听的旅行攻略。我们将有更精彩活动,不定期推出哟。]]></Content>"; } else { string strSqlzd1 = "select top 10 * from tb_U_Info where Title like '%" + postStr.Trim() + "%' or title1 like '%" + postStr.Trim() + "%' order by Sort desc"; DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(strSqlzd1); if (ds.Tables[0].Rows.Count > 0) { Repeater += "<MsgType><![CDATA[news]]></MsgType>"; Repeater += "<Content><![CDATA[]]></Content>"; Repeater += "<ArticleCount>" + ds.Tables[0].Rows.Count + "</ArticleCount>"; Repeater += "<Articles>"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { // Repeater += "{"id":1,"short_title":"1","long_title":"1","pic":"" + ds.Tables[0].Rows[i]["Photo"].ToString() + "","type":3,"track_id":1,"uid":"" + ds.Tables[0].Rows[i]["href"].ToString() + ""}"; Repeater += "<item>"; Repeater += "<Title><![CDATA[" + ds.Tables[0].Rows[i]["title"].ToString() + "]]></Title> "; Repeater += "<Description><![CDATA[" + ds.Tables[0].Rows[i]["note"].ToString() + "]]></Description>"; Repeater += "<PicUrl><![CDATA[http://geliefofm.com/" + ds.Tables[0].Rows[i]["Photo"].ToString() + "]]></PicUrl>"; Repeater += "<Url><![CDATA[http://geliefofm.com/sound/" + ds.Tables[0].Rows[i]["id"].ToString() + ".html]]></Url>"; Repeater += "</item>"; } Repeater += "</Articles>"; } else { //select COUNT(id) from tb_U_weixin where Msg like '%巴厘%' string strSql2 = "select count(*) from tb_U_weixin where Msg like '%" + postStr.Trim() + "%'"; int count = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(strSql2).ToString()); count = count + 1; Repeater += "<MsgType><![CDATA[text]]></MsgType>"; Repeater += "<Content><![CDATA[已有" + count + "人搜索" + postStr.Trim() + ",格君会将您的需求,马上告知编导。给我点时间,一定会为您精彩呈现的!旅行路上,听格列佛。格列佛,听的旅行攻略。]]></Content>"; } } return(Repeater); }
/// <summary> /// 根据字段的XML获取不同类型字段显示到页面 /// </summary> /// <param name="Val">此字段的值</param> /// <param name="Xml">xml文档信息</param> /// <returns></returns> public static string GetType(object Val, object Xml) { string Results = ""; XmlDoc xml = new XmlDoc(); xml.xmlfileInfo = Xml.ToString(); int Type = StringDeal.ToInt(xml.GetValue("/FieldInfo/FieldType")); string Field = xml.GetValue("/FieldInfo/FieldName"); string CssClass = xml.GetValue("/FieldInfo/Validator"); string useTitles = xml.GetValue("/FieldInfo/useTitles"); if (String.IsNullOrEmpty(Val.ToString())) { Val = xml.GetValue("/FieldInfo/Default"); } switch (Type) { case 1: #region 单行文本 Results = "<input id='" + Field + "' name='" + Field + "' class='input " + CssClass + "' title='" + useTitles + "' value=\"" + StringDeal.StrFormat(Val) + "\" maxlength='" + xml.GetValue("/FieldInfo/MaxLength") + "' size='" + xml.GetValue("/FieldInfo/Size") + "' />"; break; #endregion case 2: #region 多行文本 Results = "<textarea name='" + Field + "' id='" + Field + "' style='width:" + xml.GetValue("/FieldInfo/Width") + "px; height:" + xml.GetValue("/FieldInfo/Height") + "px;' class='" + CssClass + "' title='" + useTitles + "'>" + Val + "</textarea>"; break; #endregion case 3: #region 编辑器 string Editor = ""; if (xml.GetValue("/FieldInfo/Editor") == "1") { Editor = "Mini"; } else if (xml.GetValue("/FieldInfo/Editor") == "2") { Editor = "Simple"; } else { Editor = "Default"; } Results = "<script type='text/javascript'>\n"; Results += "window.onload = function()\n"; Results += "{"; Results += " var sBasePath = '/WebEditor/';\n"; Results += " var oFCKeditor = new FCKeditor( '" + Field + "' );\n"; Results += " oFCKeditor.BasePath = sBasePath ;\n"; Results += " oFCKeditor.ToolbarSet = '" + Editor + "';\n"; Results += " oFCKeditor.Config['SkinPath'] = sBasePath+'editor/skins/silver/';\n"; Results += " oFCKeditor.Width = '" + xml.GetValue("/FieldInfo/Width") + "';\n"; Results += " oFCKeditor.Height = '" + xml.GetValue("/FieldInfo/Height") + "';\n"; Results += " oFCKeditor.ReplaceTextarea();\n"; Results += "}\n"; Results += " </script>\n"; Results += "<textarea name='" + Field + "' id='" + Field + "' class='" + CssClass + "' title='" + useTitles + "'>" + Val + "</textarea>"; break; #endregion case 4: #region 拉菜单,多选,单选 string[] Arry = xml.GetValue("/FieldInfo/Options").Split('|'); string OptionsType = xml.GetValue("/FieldInfo/OptionsType"); if (Arry.Length > 0 && !String.IsNullOrEmpty(OptionsType)) { if (OptionsType == "select") { Results += "<select name='" + Field + "' id='" + Field + "' class='" + CssClass + "' title='" + useTitles + "'>"; Results += "<option value=''>请选择</option>"; foreach (string I in Arry) { Results += "<option value=\"" + I + "\"" + StringDeal.GetSelected(Val, I); Results += ">" + I + "</option>/n"; } Results += "</select>"; } else { for (int I = 0; I < Arry.Length; I++) { Results += "<input type='" + OptionsType + "' id='" + Field + I + "' name='" + Field + "' value=\"" + Arry[I] + "\"" + StringDeal.GetChecked(Val, Arry[I]) + ">" + Arry[I]; } } } break; #endregion case 5: #region 数字 Results += "<input type='text' class='input " + CssClass + "' title='" + useTitles + "' maxlength='16' size='5' name='" + Field + "' id='" + Field + "' value=\"" + Val + "\" />"; break; #endregion case 6: #region 日期/时间日期 string onFocus = ""; if (xml.GetValue("/FieldInfo/DateTime") == "yyyy-mm-dd") { onFocus = "setDay(this);"; if (Val.ToString() == "getdate()") { Val = DateTime.Today.ToString("yyyy-MM-dd"); } else { Val = StringDeal.GetDateTime(Val, "yyyy-MM-dd"); } } else { onFocus = "setDayHM(this);"; if (Val.ToString() == "getdate()") { Val = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } else { Val = StringDeal.GetDateTime(Val, "yyyy-MM-dd HH:mm"); } } Results += "<input readonly='readonly' type='text' onclick=\"" + onFocus + "\" class='input " + CssClass + "' title='" + useTitles + "' maxlength='25' size='25' name='" + Field + "' id='" + Field + "' value=\"" + Val + "\" />"; Results += "<script language=\"javascript\" type=\"text/javascript\" src='../js/calendar.js'></script>"; break; #endregion case 7: #region 图片上传 //string UploadPhotoPath = xml.GetValue("/FieldInfo/UploadPhotoPath"); //string UploadPhotoSize = xml.GetValue("/FieldInfo/UploadPhotoSize"); //string UploadPhotoType = xml.GetValue("/FieldInfo/UploadPhotoType"); //string Mark = xml.GetValue("/FieldInfo/Mark"); //string Thumb = xml.GetValue("/FieldInfo/Thumb"); Results += "<input type='text' id='" + Field + "' readonly='readonly' class='input2 " + CssClass + "' name='" + Field + "' value=\"" + StringDeal.StrFormat(Val) + "\" /> <input type=\"button\" class=\"divbutton\" value=\"图片上传\" onclick=\"UploadImage('" + Field + "','" + GetConfig.System("ManagePath") + "');\" />"; break; #endregion case 8: #region 文件上传 //string UploadFilePath = xml.GetValue("/FieldInfo/UploadPhotoPath"); //string UploadFileSize = xml.GetValue("/FieldInfo/UploadPhotoSize"); string UploadFileType = xml.GetValue("/FieldInfo/UploadImageType"); Results += "<input type=\"text\" id=\"" + Field + "\" readonly=\"readonly\" class=\"input2 " + CssClass + "\" name=\"" + Field + "\" value=\"" + StringDeal.StrFormat(Val) + "\" /> <input type=\"button\" class=\"divbutton\" value=\"文件上传\" onclick=\"UploadFile('" + Field + "','" + GetConfig.System("ManagePath") + "','" + UploadFileType + "');\" />"; break; #endregion } return(Results); }