public void Insert(News_Datail model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@"INSERT INTO [dbo].[News_Datail]
([NewsSortId]
,[NewsTitle]
,[CreatedTime]
,[NewsContent]
,[CreatedBy])
VALUES
(@NewsSortId
,@NewsTitle
,@CreatedTime
,@NewsContent
,@CreatedBy
)");
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@NewsSortId", model.NewsSortId),
new SqlParameter("@NewsTitle", model.NewsTitle),
new SqlParameter("@CreatedTime", DateTime.Now),
new SqlParameter("@NewsContent", model.NewsContent),
new SqlParameter("@CreatedBy", model.CreatedBy)
};
new SqlHelper().ExecuteNonQuery(sql.ToString(), paras);
}
public void Update(News_Datail model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@"UPDATE [dbo].[News_Datail]
SET [NewsTitle] = @NewsTitle
,[CreatedTime] = @CreatedTime
,[NewsSortId] = @NewsSortId
,NewsContent = @NewsContent
,LastUpdatedBy = @LastUpdatedBy
,LastCreatedTime = @LastCreatedTime
WHERE ID = @ID
");
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@NewsTitle", model.NewsTitle),
new SqlParameter("@CreatedTime", model.CreatedTime),
new SqlParameter("@NewsSortId", model.NewsSortId),
new SqlParameter("@NewsContent", model.NewsContent),
new SqlParameter("@ID", model.ID),
new SqlParameter("@LastUpdatedBy", model.LastUpdatedBy),
new SqlParameter("@LastCreatedTime", model.LastCreatedTime)
};
new SqlHelper().ExecuteNonQuery(sql.ToString(), pars);
}
protected void btnSelect_Click(object sender, EventArgs e)
{
var title = txtTitle.Text.Trim();
var sort = ddlSort.Text.Trim();
if (sort == "全部" && title != null)
{
News_Datail model = new News_Datail
{
NewsTitle = title
};
DataSet ds = new NewsMgr().Select4(model);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
else if (sort != "全部" && title != null)
{
var id = Convert.ToInt32(sort);
News_Datail model = new News_Datail
{
NewsTitle = title,
NewsSortId = id
};
DataSet ds = new NewsMgr().Select3(model);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
public void Insert()
{
var user = (UserInfo)Session["User"];
string userName = user.UserName;
if (tbTitle.Text != "" && ddlSort.Text != "全部")
{
var id = Convert.ToInt32(ddlSort.Text.Trim());
News_Datail model = new News_Datail
{
NewsTitle = tbTitle.Text,
NewsSortId = id,
CreatedTime = DateTime.Now,
NewsContent = CKEditorControl1.Text,
CreatedBy = userName
};
new NewsMgr().Insert(model);
Response.Write("<script>alert('保存成功!')</script>");
Response.Write("<script>window.location.href='NewsList.aspx';</script>");
}
else
{
Response.Write("<script>alert('请把所有信息填写完成!!')</script>");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
var user = (UserInfo)Session["User"];
if (user == null)
{
Response.Redirect("Login.aspx");
}
for (int i = 0; i < GridView1.Rows.Count - 1; i++)
{
CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("cbChoose");
if (cbox != null)
{
if (cbox.Checked)
{
int id = Convert.ToInt32(GridView1.Rows[i].Cells[1].Text.Trim());
News_Datail model = new News_Datail
{
ID = id
};
new NewsMgr().Delete(model);
}
}
}
newsBind();
Response.Write("<script>alert('删除成功！')</script>");
}
public void Delete(News_Datail model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@"DELETE FROM [dbo].[News_Datail]
WHERE ID=@ID
");
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@ID", model.ID)
};
new SqlHelper().ExecuteNonQuery(sql.ToString(), pars);
}
public DataSet SelectNewsContentById(News_Datail model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@"select NewsContent
,NewsTitle
,CreatedTime
from News_Datail
where ID = @ID
");
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@ID", model.ID)
};
DataSet ds = new SqlHelper().ExecuteQuery(sql.ToString(), pars);
return(ds);
}
public List <News_Datail> SelectTitleInf(NewsSort model)
{
var list = new List <News_Datail>();
DataSet ds = new DalNewsSort().Select2(model);
DataTable dt = new DataTable();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
foreach (DataRow dr in dt.Rows)
{
var mod = new News_Datail();
mod.NewsTitle = Convert.ToString(dr["NewsTitle"]);
mod.CreatedTime = Convert.ToDateTime(dr["CreatedTime"]);
list.Add(mod);
}
return(list);
}
public DataSet Select3(News_Datail model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@"SELECT News_Datail.ID
,News_Sort.NewsSortName
,News_Datail.NewsTitle
,News_Datail.CreatedTime
FROM dbo.News_Datail inner join News_Sort on News_Datail.NewsSortId = News_Sort.ID
WHERE NewsTitle like @NewsTitle
");
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@NewsTitle", "%" + model.NewsTitle + "%")
};
DataSet ds = new SqlHelper().ExecuteQuery(sql.ToString(), pars);
return(ds);
}
public List <News_Datail> Select()
{
var list = new List <News_Datail>();
var ds = dn.SelectSortList();
var dt = new DataTable();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
foreach (DataRow dr in dt.Rows)
{
var mod = new News_Datail();
mod.ID = Convert.ToInt32(dr["ID"]);
mod.NewsSortId = Convert.ToInt32(dr["NewsSortId"]);
mod.NewsTitle = Convert.ToString(dr["NewsTitle"]);
mod.CreatedTime = Convert.ToDateTime(dr["CreatedTime"]);
list.Add(mod);
}
return(list);
}
public void contentBind()
{
if (Request["id"] == null)
{
DataSet ds = new NewsMgr().Select6();
lbContent.Text = ds.Tables[0].Rows[0]["NewsContent"].ToString();
lbCreatedTime.Text = Convert.ToString(ds.Tables[0].Rows[0]["CreatedTime"]);
lbTitle.Text = ds.Tables[0].Rows[0]["NewsTitle"].ToString();
}
else
{
var id = Convert.ToInt32(Request["id"]);
News_Datail model = new News_Datail
{
ID = id
};
DataSet ds = new NewsMgr().SelectNewsContentById(model);
lbContent.Text = ds.Tables[0].Rows[0]["NewsContent"].ToString();
lbTitle.Text = ds.Tables[0].Rows[0]["NewsTitle"].ToString();
lbCreatedTime.Text = ds.Tables[0].Rows[0]["CreatedTime"].ToString();
}
}
public void Update()
{
var user = (UserInfo)Session["User"];
string userName = user.UserName;
var text = tbTitle.Text;
var text2 = CKEditorControl1.Text;
News_Datail model = new News_Datail
{
NewsTitle = tbTitle.Text,
NewsSortId = Convert.ToInt32(ddlSort.Text.Trim()),
NewsContent = CKEditorControl1.Text,
CreatedTime = DateTime.Now,
ID = Convert.ToInt32(Request["id"]),
LastUpdatedBy = userName,
LastCreatedTime = DateTime.Now
};
new NewsMgr().Update(model);
LasetUpdated();
Response.Write("<script>alert('保存成功！')</script>");
Response.Write("<script>window.location.href='NewsList.aspx';</script>");
}
public void Update(News_Datail model)
{
dn.Update(model);
}
public DataSet SelectNewsContentById(News_Datail model)
{
DataSet ds = dn.SelectNewsContentById(model);
return(ds);
}
public void Insert(News_Datail model)
{
dn.Insert(model);
}
public void Delete(News_Datail model)
{
dn.Delete(model);
}
public DataSet Select4(News_Datail model)
{
return(dn.Select3(model));
}
