|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/6b11be23/e503b68d/ |
?#pragma checksum "D:\wwwroot\keman\wwwroot\App_Code\yingshi.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "0E0AEFCF51FF23B61DA8781E779E9CE2"
#line 1 "D:\wwwroot\keman\wwwroot\App_Code\yingshi.cs"
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Text.RegularExpressions;
using System.Text;
/// <summary>
/// yingshi 的提要注明
/// </summary>
public class yingshi
{
#region 域界说
public string Connectionstring;
#endregion
#region 机关函数
public yingshi()
{
//
// TODO: 在此处增长机关函数逻辑
//
this.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["strConn"].ConnectionString);
if (HttpContext.Current.Request.Url.ToString().ToLower().IndexOf("/en/") > -1)
{
this.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["strConnEn"].ConnectionString);
}
}
#endregion
//private static readonly string Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("/App_Data/ycdata.mdb");
OleDbConnection cn;
OleDbCommand cmd;
OleDbDataAdapter da;
OleDbDataReader read;
/// <summary>
/// 对用户表的增,删,改,操作
/// </summary>
/// <param name="sql">要执行的sql语句</param>
public void user(string sql)
{
cn = new OleDbConnection(Connectionstring);
cmd = new OleDbCommand(sql, cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
cn.Dispose();
}
/// <summary>
/// 对用户表的增,删,改,操作
/// </summary>
/// <param name="sql">要执行的sql语句</param>
public string shuju(string sql)
{
cn = new OleDbConnection(Connectionstring);
cmd = new OleDbCommand(sql, cn);
cn.Open();
string ff=cmd.ExecuteScalar().ToString();
cn.Close();
cn.Dispose();
return ff;
}
/// <summary>
/// 对datalist的绑定
/// </summary>
/// <param name="sql">要执行的查问sql语句</param>
/// <returns>返回了局集</returns>
public DataSet chaxun(string sql)
{
cn = new OleDbConnection(Connectionstring);
da = new OleDbDataAdapter(sql, cn);
DataSet dt = new DataSet();
da.Fill(dt);
return dt;
dt.Dispose();
}
public DataTable dttable(string sql)
{
cn = new OleDbConnection(Connectionstring);
da = new OleDbDataAdapter(sql, cn);
DataSet dt = new DataSet();
da.Fill(dt);
return dt.Tables[0];
}
//erjifenlei 判断是否 拥有 类此外直接链接 (空和0：无图新闻列表，1：有图新闻列表 2：带图课程信息列表 3：专家教授带图列表 4：关于918博天堂 单页面 ，也可直接输入地址)
public string pdejfllianjie(string tedian, string classid)
{
//string urlsss = "#";
//if (tedian == "" || tedian == "0")
//{
// urlsss = "redianzixun.aspx?classid=" + classid + "";
//}
//else if (tedian == "1")
//{
// urlsss = "qiyefangtan.aspx?classid=" + classid + "";
//}
//else if (tedian == "2")
//{
// urlsss = "jingpingkecheng.aspx?classid=" + classid + "";
//}
//else if (tedian == "3")
//{
// urlsss = "zhuanjiajiaoshou.aspx?classid=" + classid + "";
//}
//else if (tedian == "4")
//{
// urlsss = "about.aspx?classid=" + classid + "";
//}
//else if (tedian != "" && tedian != "0" && tedian != "1" && tedian != "2" && tedian != "3" && tedian != "4")
//{
// urlsss = tedian;
//}
//return urlsss;
string urlsss = "#";
if (tedian == "" || tedian == "0")
{
urlsss = "news.aspx?classid=" + classid + "";
}
else if (tedian == "1")
{
urlsss = "news.aspx?classid=" + classid + "";
}
else if (tedian == "2")
{
urlsss = "huangjing.aspx?classid=" + classid + "";
}
else if (tedian == "3")
{
urlsss = "huangjing.aspx?classid=" + classid + "";
}
else if (tedian == "4")
{
urlsss = "about.aspx?classid=" + classid + "";
}
else if (tedian != "" && tedian != "0" && tedian != "1" && tedian != "2" && tedian != "3" && tedian != "4")
{
urlsss = tedian;
}
return urlsss;
}
/// <summary>
/// 对datalist的绑定
/// </summary>
/// <param name="sql">要执行的查问sql语句</param>
/// <returns>返回了局集</returns>
public DataSet chaxun2(string sql)
{
cn = new OleDbConnection(Connectionstring);
da = new OleDbDataAdapter(sql, cn);
DataSet dt = new DataSet();
da.Fill(dt);
return dt;
}
/// <summary>
/// 截取字符串
/// </summary>
/// <param name="stringToSub"></param>
/// <param name="length"></param>
/// <returns></returns>
public static string CutString(string stringToSub, int length)
{
Regex regex = new Regex("[\u4e00-\u9fa5]+", RegexOptions.Compiled);
char[] stringChar = stringToSub.ToCharArray();
StringBuilder sb = new StringBuilder();
int nLength = 0;
bool isCut = false;
for (int i = 0; i < stringChar.Length; i++)
{
if (regex.IsMatch((stringChar[i]).ToString()))
{
sb.Append(stringChar[i]);
nLength += 2;
}
else
{
sb.Append(stringChar[i]);
nLength = nLength + 1;
}
if (nLength > length)
{
isCut = true;
break;
}
}
if (isCut)
return sb.ToString() + "...";
else
return sb.ToString();
}
/// <summary>
/// 对表的读去
/// </summary>
/// <param name="sql">执行的sql语句</param>
/// <returns>返回的了局</returns>
public OleDbDataReader charead(string sql)
{
cn = new OleDbConnection(Connectionstring);
cmd = new OleDbCommand(sql, cn);
cn.Open();
read = cmd.ExecuteReader();
return read;
}
/// <summary>
/// 绑定gridview
/// </summary>
/// <param name="sql">查问语句sql语句</param>
/// <param name="gridview">绑定的内容</param>
public void bind(string sql, GridView gridview)
{
cn = new OleDbConnection(Connectionstring);
da = new OleDbDataAdapter(sql, cn);
DataSet dt = new DataSet();
da.Fill(dt);
gridview.DataSource = dt.Tables[0].DefaultView;
gridview.DataBind();
cn.Close();
cn.Dispose();
}
/// <summary>
/// 弹出对话信息
/// </summary>
/// <param name="ss">弹出的对话内容</param>
public void MSG(string ss)
{
HttpContext.Current.Response.Write("<script>alert('" + ss + "')</script>");
}
/// <summary>
/// 绑定dropdownlist
/// </summary>
/// <param name="dropdownlist">绑定的控件的名称</param>
public void bingding(string sql, DropDownList dropdownlist, string id, string title)
{
cn = new OleDbConnection(Connectionstring);
da = new OleDbDataAdapter(sql, cn);
DataSet dt = new DataSet();
da.Fill(dt);
dropdownlist.DataSource = dt.Tables[0].DefaultView;
dropdownlist.DataValueField = id;
dropdownlist.DataTextField = title;
dropdownlist.DataBind();
cn.Close();
cn.Dispose();
}
public string MD5(string pwd)
{
return FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5");
}
public void javascript(string font)
{
HttpContext.Current.Response.Write("<script>alert('" + font + "')</script>");
}
public void java(string font, string yemian)
{
HttpContext.Current.Response.Write("<script>alert('" + font + "');location.href='" + yemian + "'</script>");
}
//写成一个步骤,以便多处挪用:
public void Alert(Page page, string msg)
{
page.ClientScript.RegisterClientScriptBlock(GetType(), "_error", " <script language=javascript>window.alert('" + msg + "') </script>");
}
//判断是否整型
public bool checkIsNum(string TestString)
{
string SpecSign = "0123456789";
for (int i = 0; i < TestString.Length; i++)
{
while (SpecSign.IndexOf(TestString[i]) == -1)
return false;
}
return true;
}
}
#line default
#line hidden