private articleInfo GetInfoByDr(SqlDataReader dr)
{
articleInfo info = new articleInfo();
info.id = int.Parse(dr["id"] != DBNull.Value ? dr["id"].ToString() : "");
info.seo_description = dr["seo_description"] != DBNull.Value ? dr["seo_description"].ToString() : "";
info.zhaiyao = dr["zhaiyao"] != DBNull.Value ? dr["zhaiyao"].ToString() : "";
info.content = dr["content"] != DBNull.Value ? dr["content"].ToString() : "";
info.orderby = int.Parse(dr["orderby"] != DBNull.Value ? dr["orderby"].ToString() : "");
info.click = int.Parse(dr["click"] != DBNull.Value ? dr["click"].ToString() : "");
info.status = int.Parse(dr["status"] != DBNull.Value ? dr["status"].ToString() : "0");
info.is_top = int.Parse(dr["is_top"] != DBNull.Value ? dr["is_top"].ToString() : "0");
info.is_red = int.Parse(dr["is_red"] != DBNull.Value ? dr["is_red"].ToString() : "0");
info.is_hot = int.Parse(dr["is_hot"] != DBNull.Value ? dr["is_hot"].ToString() : "0");
info.channel_id = int.Parse(dr["channel_id"] != DBNull.Value ? dr["channel_id"].ToString() : "");
info.is_slide = int.Parse(dr["is_slide"] != DBNull.Value ? dr["is_slide"].ToString() : "");
info.userid = int.Parse(dr["userid"] != DBNull.Value ? dr["userid"].ToString() : "");
info.username = dr["username"] != DBNull.Value ? dr["username"].ToString() : "";
info.add_time = DateTime.Parse(dr["add_time"] != DBNull.Value ? dr["add_time"].ToString() : "");
info.update_time = DateTime.Parse(dr["update_time"] != DBNull.Value ? dr["update_time"].ToString() : "");
info.category_id = int.Parse(dr["category_id"] != DBNull.Value ? dr["category_id"].ToString() : "");
info.call_index = dr["call_index"] != DBNull.Value ? dr["call_index"].ToString() : "";
info.title = dr["title"] != DBNull.Value ? dr["title"].ToString() : "";
info.link_url = dr["link_url"] != DBNull.Value ? dr["link_url"].ToString() : "";
info.img_url = dr["img_url"] != DBNull.Value ? dr["img_url"].ToString() : "";
info.seo_title = dr["seo_title"] != DBNull.Value ? dr["seo_title"].ToString() : "";
info.seo_keywords = dr["seo_keywords"] != DBNull.Value ? dr["seo_keywords"].ToString() : "";
info.companyid = int.Parse(dr["companyid"] != DBNull.Value ? dr["companyid"].ToString() : "0");
return(info);
}
public articleInfo GetModel(int id)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from article ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
articleInfo info = new articleInfo();
using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters))
{
if (dr.Read())
{
info = GetInfoByDr(dr);
}
}
return(info);
}
catch { }
return(null);
}
public List <articleInfo> GetList(int Top, string strWhere, string filedOrder)
{
List <articleInfo> list = new List <articleInfo>();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" * ");
strSql.Append(" FROM article ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
if (filedOrder.Trim() != "")
{
strSql.Append(" order by " + filedOrder);
}
using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection, strSql.ToString(), CommandType.Text))
{
while (dr.Read())
{
articleInfo info = GetInfoByDr(dr);
list.Add(info);
}
}
return(list);
}
catch { }
return(null);
}
private void bind()
{
if (id > 0)
{
string where = "id=" + id;
List <articleInfo> list = BLL.articleBLL.GetList(1, where, "");
if (list == null || list.Count == 0)
{
Response.Write("<script>alert('无对应的数据！');history.go(-1);</script>");
return;
}
articleInfo info = list[0];
hfid.Value = info.id.ToString();
txbtitle.Text = info.title;
txblink_url.Text = info.link_url;
txbseo_description.Text = info.seo_description;
txbzhaiyao.Text = info.zhaiyao;
content = info.content;
txborderby.Text = info.orderby.ToString();
txbclick.Text = info.click.ToString();
//txbstatus.Text = info.status;//0正常1未审核2锁定
if (info.status == 0)
{
rbtnstatus0.Checked = true;
}
else if (info.status == 1)
{
rbtnstatus1.Checked = true;
}
else if (info.status == 2)
{
rbtnstatus2.Checked = true;
}
ckbis_top.Checked = info.is_hot == 1 ? true : false;
ckbis_red.Checked = info.is_red == 1 ? true : false;
ckbis_hot.Checked = info.is_hot == 1 ? true : false;
ckbis_slide.Checked = info.is_slide == 1 ? true : false;
try
{
ddlcategory.SelectedValue = info.category_id.ToString();
}
catch { }
txbcall_index.Text = info.call_index;
if (info.img_url != null && info.img_url.Trim().Length > 0)
{
img = "<img src=\"" + info.img_url + "\" height=\"50\"/><br/>";
}
img_url = info.img_url;
txbseo_title.Text = info.seo_title;
txbseo_keywords.Text = info.seo_keywords;
}
else
{
txbclick.Text = "1";
txborderby.Text = "99";
}
}
protected void bind(string call_index)
{
if (call_index.Trim().Length == 0)
{
return;
}
string where = " call_index='" + call_index + "'";
//string where = "companyid=" + base.companyid + " and call_index='" + call_index + "'";
List <articleInfo> list = BLL.articleBLL.GetList(1, where, "");
if (list == null || list.Count == 0)
{
return;
}
articleInfo info = list[0];
title = info.title;
content = info.content;
header.title = title;
}
protected void btnsave_Click(object sender, EventArgs e)
{
//HttpFileCollection files = HttpContext.Current.Request.Files;
//if (files != null && files.Count > 0)
//{
// for (int i = 0; i < files.Count; i++)
// {
// System.Web.HttpPostedFile file = files[i];
// if (file.ContentLength > 500 * 1024)
// {
// //Page.ClientScript.RegisterClientScriptBlock(this.GetType(), DateTime.Now.ToString(), "alert('图片大小不能超过300K！');", true);
// Response.Write("<script>parent.fail('图片大小不能超过500K！');</script>");
// return;
// }
// }
//}
articleInfo model = new articleInfo();
model.id = id;
id = model.id;
model.seo_description = txbseo_description.Text;
model.zhaiyao = txbzhaiyao.Text;
model.orderby = int.Parse(txborderby.Text);
model.click = int.Parse(txbclick.Text);
if (rbtnstatus1.Checked)
{
model.status = 1;
}
else if (rbtnstatus2.Checked)
{
model.status = 2;
}
model.is_top = ckbis_top.Checked ? 1 : 0;
model.is_red = ckbis_red.Checked ? 1 : 0;
model.is_hot = ckbis_hot.Checked ? 1 : 0;
model.is_slide = ckbis_slide.Checked ? 1 : 0;
model.userid = base.UserID;
model.username = base.UserName;
model.add_time = DateTime.Now;
model.update_time = DateTime.Now;
model.category_id = int.Parse(ddlcategory.SelectedValue);
model.call_index = txbcall_index.Text;
model.title = txbtitle.Text;
model.link_url = txblink_url.Text;
model.img_url = Common.Utils.ObjectToStr(Request["img_url"]);
model.seo_title = txbseo_title.Text;
model.seo_keywords = txbseo_keywords.Text;
model.content = Request["content"].ToString();
int result = 0;
string resultMsg = "";
if (id > 0)
{
result = BLL.articleBLL.Update(model, ref resultMsg);
if (result > 0)
{
//Components.EventLogController.AddEventLog("修改文章", "修改文章-" + model.title, base.UserID);
Response.Write("<script>parent.success('提交成功！');</script>");
}
else
{
Response.Write("<script>parent.fail('提交失败！" + resultMsg.Replace("'", "").Replace("\r", "").Replace("\n", "") + "');</script>");
}
}
else
{
result = BLL.articleBLL.Add(model, ref resultMsg);
if (result > 0)
{
//Components.EventLogController.AddEventLog("添加文章", "添加文章-" + model.title, base.UserID);
Response.Write("<script>parent.success('提交成功！');</script>");
}
else
{
Response.Write("<script>parent.fail('提交失败！" + resultMsg.Replace("'", "").Replace("\r", "").Replace("\n", "") + "');</script>");
}
}
}
public void LoadDetails(IBaseDB baseDB, articleInfo articleinfo)
{
articleinfo.article_content = baseDB.Table <articleContent>().FirstOrDefault(x => x.article_info_id == articleinfo.id);
articleinfo.article_comments = baseDB.Table <articleComment>().Where(x => x.article_info_id == articleinfo.id).ToList();
}
public int Update(articleInfo model, ref string resultMsg)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update article set ");
strSql.Append(" seo_description = @seo_description , ");
strSql.Append(" zhaiyao = @zhaiyao , ");
strSql.Append(" content = @content , ");
strSql.Append(" orderby = @orderby , ");
strSql.Append(" click = @click , ");
strSql.Append(" status = @status , ");
strSql.Append(" is_top = @is_top , ");
strSql.Append(" is_red = @is_red , ");
strSql.Append(" is_hot = @is_hot , ");
strSql.Append(" is_slide = @is_slide , ");
strSql.Append(" update_time = @update_time , ");
strSql.Append(" category_id = @category_id , ");
strSql.Append(" call_index = @call_index , ");
strSql.Append(" title = @title , ");
strSql.Append(" link_url = @link_url , ");
strSql.Append((model.img_url != null && model.img_url.Trim().Length > 0 ? "[img_url]='" + model.img_url + "'," : ""));
strSql.Append(" seo_title = @seo_title , ");
strSql.Append(" seo_keywords = @seo_keywords, ");
strSql.Append(" companyid = @companyid ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@seo_description", SqlDbType.NVarChar, 255),
new SqlParameter("@zhaiyao", SqlDbType.NVarChar, 255),
new SqlParameter("@content", SqlDbType.Text),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@click", SqlDbType.Int, 4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@is_top", SqlDbType.TinyInt, 1),
new SqlParameter("@is_red", SqlDbType.TinyInt, 1),
new SqlParameter("@is_hot", SqlDbType.TinyInt, 1),
new SqlParameter("@is_slide", SqlDbType.TinyInt, 1),
new SqlParameter("@update_time", SqlDbType.DateTime),
new SqlParameter("@category_id", SqlDbType.Int, 4),
new SqlParameter("@call_index", SqlDbType.NVarChar, 50),
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@link_url", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_title", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255),
new SqlParameter("@companyid", SqlDbType.Int, 4),
};
parameters[0].Value = model.id;
parameters[1].Value = model.seo_description;
parameters[2].Value = model.zhaiyao;
parameters[3].Value = model.content;
parameters[4].Value = model.orderby;
parameters[5].Value = model.click;
parameters[6].Value = model.status;
parameters[7].Value = model.is_top;
parameters[8].Value = model.is_red;
parameters[9].Value = model.is_hot;
parameters[10].Value = model.is_slide;
parameters[11].Value = DateTime.Now;
parameters[12].Value = model.category_id;
parameters[13].Value = model.call_index;
parameters[14].Value = model.title;
parameters[15].Value = model.link_url;
parameters[16].Value = model.seo_title;
parameters[17].Value = model.seo_keywords;
parameters[18].Value = model.companyid;
int rows = SqlDbHelper.ExecuteNonQuery(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
return(rows);
}
catch (Exception exc)
{ resultMsg = exc.Message; }
return(0);
}
public int Add(articleInfo model, ref string resultMsg)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into article(");
strSql.Append("seo_description,zhaiyao,content,orderby,click,status,is_top,is_red,is_hot,channel_id,is_slide,userid,username,add_time,update_time,category_id,call_index,title,link_url,img_url,seo_title,seo_keywords,companyid");
strSql.Append(") values (");
strSql.Append("@seo_description,@zhaiyao,@content,@orderby,@click,@status,@is_top,@is_red,@is_hot,@channel_id,@is_slide,@userid,@username,@add_time,@update_time,@category_id,@call_index,@title,@link_url,@img_url,@seo_title,@seo_keywords,@companyid");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@seo_description", SqlDbType.NVarChar, 255),
new SqlParameter("@zhaiyao", SqlDbType.NVarChar, 255),
new SqlParameter("@content", SqlDbType.Text),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@click", SqlDbType.Int, 4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@is_top", SqlDbType.TinyInt, 1),
new SqlParameter("@is_red", SqlDbType.TinyInt, 1),
new SqlParameter("@is_hot", SqlDbType.TinyInt, 1),
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@is_slide", SqlDbType.TinyInt, 1),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@username", SqlDbType.NVarChar, 100),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@update_time", SqlDbType.DateTime),
new SqlParameter("@category_id", SqlDbType.Int, 4),
new SqlParameter("@call_index", SqlDbType.NVarChar, 50),
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@link_url", SqlDbType.NVarChar, 255),
new SqlParameter("@img_url", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_title", SqlDbType.NVarChar, 255),
new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255),
new SqlParameter("@companyid", SqlDbType.Int, 4),
};
parameters[0].Value = model.seo_description;
parameters[1].Value = model.zhaiyao;
parameters[2].Value = model.content;
parameters[3].Value = model.orderby;
parameters[4].Value = model.click;
parameters[5].Value = model.status;
parameters[6].Value = model.is_top;
parameters[7].Value = model.is_red;
parameters[8].Value = model.is_hot;
parameters[9].Value = model.channel_id;
parameters[10].Value = model.is_slide;
parameters[11].Value = model.userid;
parameters[12].Value = model.username;
parameters[13].Value = model.add_time;
parameters[14].Value = model.update_time;
parameters[15].Value = model.category_id;
parameters[16].Value = model.call_index;
parameters[17].Value = model.title;
parameters[18].Value = model.link_url;
parameters[19].Value = model.img_url;
parameters[20].Value = model.seo_title;
parameters[21].Value = model.seo_keywords;
parameters[22].Value = model.companyid;
object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
catch (Exception exc)
{ resultMsg = exc.Message; }
return(0);
}
