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