//得到网站内容列表
public static List <websitetypeinfo> getwebsite(pageinfo pdata)
{
List <websitetypeinfo> list = new List <websitetypeinfo>();
try
{
DataTable dt = pagehelper.getpagedt(pdata);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
websitetypeinfo item = new websitetypeinfo();
item.wsid = TypeParse.DbObjToInt(dr["wsid"].ToString(), 0);
item.wtid = TypeParse.DbObjToInt(dr["wtid"].ToString(), 0);
item.websitetype = TypeParse.DbObjToString(dr["websitetype"].ToString(), "");
item.websitecontent = TypeParse.DbObjToString(dr["websitecontent"].ToString(), "");
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["wsid"] != null)
{
int id = TypeParse.DbObjToInt(Request.QueryString["wsid"].ToString(), 0);
websitetypeinfo data = websitetype.getwebsiteinfo(id);
websiteinfoDATA = data;
if (!Page.IsPostBack)
{
StringBuilder sb = new StringBuilder();
List <websitetypeinfo> itlist = websitetype.getwebsitetype();
sb.Append("<select id=\"wtid\" name=\"wtid\" style=\"width:120px; border:solid 1px #cacaca; height:20px;\">");
foreach (websitetypeinfo item in itlist)
{
string template;
if (item.wtid == data.wtid)
{
template = "<option value=\"{0}\" selected=\"selected\">{1}</option>";
}
else
{
template = "<option value=\"{0}\">{1}</option>";
}
sb.AppendFormat(template, item.wtid, item.websitetype);
}
sb.Append("</select>");
websitetypeHTML = sb.ToString();
}
}
else
{
Response.Redirect("/Manager/WebSite.aspx");
}
}
//得到网站内容信息通过信息类别
public static websitetypeinfo getwebsiteinfobytype(string type)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@type", SqlDbType.VarChar, 50);
parms[0].Value = type;
websitetypeinfo item = new websitetypeinfo();
string sql = "select website.wsid,website.websitecontent, websitetype.websitetype from website,websitetype where website.wtid=websitetype.wtid AND websitetype.websitetype like'%" + type + "%'";
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms);
if (dr.Read())
{
item.wsid = TypeParse.DbObjToInt(dr["wsid"].ToString(), 0);
item.websitecontent = TypeParse.DbObjToString(dr["websitecontent"].ToString(), "");
item.websitetype = TypeParse.DbObjToString(dr["websitetype"].ToString(), "");
dr.Close();
dr.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(item);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["wsid"] != null)
{
int id = TypeParse.DbObjToInt(Request.QueryString["wsid"].ToString(), 0);
websitetypeinfo data = websitetype.getwebsiteinfo(id);
websiteinfoDATA = data;
if (!Page.IsPostBack)
{
StringBuilder sb = new StringBuilder();
List<websitetypeinfo> itlist = websitetype.getwebsitetype();
sb.Append("<select id=\"wtid\" name=\"wtid\" style=\"width:120px; border:solid 1px #cacaca; height:20px;\">");
foreach (websitetypeinfo item in itlist)
{
string template;
if (item.wtid == data.wtid)
{
template = "<option value=\"{0}\" selected=\"selected\">{1}</option>";
}
else
{
template = "<option value=\"{0}\">{1}</option>";
}
sb.AppendFormat(template, item.wtid, item.websitetype);
}
sb.Append("</select>");
websitetypeHTML = sb.ToString();
}
}
else
{
Response.Redirect("/Manager/WebSite.aspx");
}
}
//得到网站内容类别列表
public static List <websitetypeinfo> getwebsitetype()
{
string sql = "select wtid,websitetype from websitetype";
List <websitetypeinfo> itlist = new List <websitetypeinfo>();
try
{
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
websitetypeinfo item = new websitetypeinfo();
item.wtid = TypeParse.DbObjToInt(dr["wtid"].ToString(), 0);
item.websitetype = TypeParse.DbObjToString(dr["websitetype"].ToString(), "");
itlist.Add(item);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(itlist);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//网站内容目录
List <websitetypeinfo> itlist = websitetype.getwebsitetype();
StringBuilder itsb = new StringBuilder();
foreach (websitetypeinfo item in itlist)
{
string template = "<li><span class=\"newslipoint\"></span><a href=\"/WS/{0}\">{1}</a></li>";
itsb.AppendFormat(template, item.wtid, item.websitetype);
}
categorylistHTML = itsb.ToString();
if (RouteData.Values["contenttype"] != null && RouteData.Values["contenttype"].ToString() != "")
{
string k = RouteData.Values["contenttype"].ToString();
string wstype = "关于我们";
switch (k)
{
case "1":
wstype = "关于我们";
break;
case "3":
wstype = "联系我们";
break;
case "4":
wstype = "人才招聘";
break;
default:
wstype = "关于我们";
break;
}
websitetypeinfo item = websitetype.getwebsiteinfobytype(wstype);
ctitleHTML = item.websitetype;
contentHTML = item.websitecontent;
}
else
{
string wstype = "关于我们";
websitetypeinfo item = websitetype.getwebsiteinfobytype(wstype);
ctitleHTML = item.websitetype;
contentHTML = item.websitecontent;
}
}
}
public string editwebsitetype(string wtid, string swebsitetype)
{
websitetypeinfo data = new websitetypeinfo();
data.websitetype = HttpUtility.UrlDecode(TypeParse.DbObjToString(swebsitetype, ""));
data.wtid = TypeParse.DbObjToInt(wtid, 0);
bool result = websitetype.editwebsitetype(data);
if (result)
{
return("t");
}
else
{
return("f");
}
}
public string addwebsitetype(string swebsitetype)
{
string strit = HttpUtility.UrlDecode(TypeParse.DbObjToString(swebsitetype, ""));
websitetypeinfo data = new websitetypeinfo();
data.websitetype = strit;
bool result = websitetype.addwebsitetype(data);
if (result)
{
return("t");
}
else
{
return("f");
}
}
public string editwebsite(string s_website, string wsid)
{
string strit = HttpUtility.UrlDecode(TypeParse.DbObjToString(s_website, ""));
websitetypeinfo data = new websitetypeinfo();
data.websitecontent = strit;
data.wsid = TypeParse.DbObjToInt(wsid, 0);
bool result = websitetype.editwebsite(data);
if (result)
{
return("t");
}
else
{
return("f");
}
}
//添加网站内容类别
public static bool addwebsitetype(websitetypeinfo data)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@websitetype", SqlDbType.VarChar);
parms[0].Value = data.websitetype;
string sql = "insert into websitetype (websitetype) values(@websitetype)";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return result > 0;
}
//添加网站内容类别
public static bool addwebsitetype(websitetypeinfo data)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@websitetype", SqlDbType.VarChar);
parms[0].Value = data.websitetype;
string sql = "insert into websitetype (websitetype) values(@websitetype)";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(result > 0);
}
//编辑网站内容类别
public static bool editwebsitetype(websitetypeinfo data)
{
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@websitetype", SqlDbType.VarChar, 20);
parms[0].Value = data.websitetype;
parms[1] = new SqlParameter("@wtid", SqlDbType.Int);
parms[1].Value = data.wtid;
string sql = "update websitetype set websitetype=@websitetype where wtid=@wtid";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
}
return(result > 0);
}
//编辑网站内容
public static bool editwebsite(websitetypeinfo data)
{
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@websitecontent", SqlDbType.Text);
parms[0].Value = data.websitecontent;
parms[1] = new SqlParameter("@wsid", SqlDbType.Int);
parms[1].Value = data.wsid;
string sql = "update website set websitecontent=@websitecontent where wsid=@wsid";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(result > 0);
}
//编辑网站内容
public static bool editwebsite(websitetypeinfo data)
{
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@websitecontent", SqlDbType.Text);
parms[0].Value = data.websitecontent;
parms[1] = new SqlParameter("@wsid",SqlDbType.Int);
parms[1].Value = data.wsid;
string sql = "update website set websitecontent=@websitecontent where wsid=@wsid";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return result > 0;
}
//得到网站内容列表
public static List<websitetypeinfo> getwebsite(pageinfo pdata)
{
List<websitetypeinfo> list = new List<websitetypeinfo>();
try
{
DataTable dt = pagehelper.getpagedt(pdata);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
websitetypeinfo item = new websitetypeinfo();
item.wsid = TypeParse.DbObjToInt(dr["wsid"].ToString(), 0);
item.wtid = TypeParse.DbObjToInt(dr["wtid"].ToString(), 0);
item.websitetype = TypeParse.DbObjToString(dr["websitetype"].ToString(), "");
item.websitecontent = TypeParse.DbObjToString(dr["websitecontent"].ToString(), "");
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return list;
}
//得到网站内容信息通过信息类别
public static websitetypeinfo getwebsiteinfobytype(string type)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@type", SqlDbType.VarChar, 50);
parms[0].Value = type;
websitetypeinfo item = new websitetypeinfo();
string sql = "select website.wsid,website.websitecontent, websitetype.websitetype from website,websitetype where website.wtid=websitetype.wtid AND websitetype.websitetype like'%" + type + "%'";
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms);
if (dr.Read())
{
item.wsid = TypeParse.DbObjToInt(dr["wsid"].ToString(), 0);
item.websitecontent = TypeParse.DbObjToString(dr["websitecontent"].ToString(), "");
item.websitetype = TypeParse.DbObjToString(dr["websitetype"].ToString(), "");
dr.Close();
dr.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return item;
}
//得到网站内容类别列表
public static List<websitetypeinfo> getwebsitetype()
{
string sql = "select wtid,websitetype from websitetype";
List<websitetypeinfo> itlist = new List<websitetypeinfo>();
try
{
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
websitetypeinfo item = new websitetypeinfo();
item.wtid = TypeParse.DbObjToInt(dr["wtid"].ToString(), 0);
item.websitetype = TypeParse.DbObjToString(dr["websitetype"].ToString(), "");
itlist.Add(item);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return itlist;
}
//编辑网站内容类别
public static bool editwebsitetype(websitetypeinfo data)
{
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@websitetype", SqlDbType.VarChar, 20);
parms[0].Value = data.websitetype;
parms[1] = new SqlParameter("@wtid",SqlDbType.Int);
parms[1].Value = data.wtid;
string sql = "update websitetype set websitetype=@websitetype where wtid=@wtid";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
}
return result > 0;
}
