protected void Page_Load(object sender, EventArgs e)
{
if (!Utils.CheckRole("9"))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('权限信息','没有权限！','/Systestcomjun/index.aspx',2)</script>");
return;
}
if (!IsPostBack)
{
ZhongLi.Model.siteconfig site = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config"));
imgformat = site.ImgFormat;
ddlNewsType.DataSource = new ZhongLi.BLL.NewsType().GetAllList();
ddlNewsType.DataTextField = "Name";
ddlNewsType.DataValueField = "NewsTypeID";
ddlNewsType.DataBind();
ltlTitle.Text = "新增内容";
if (Request.QueryString["NewsID"] != null)
{
int NewsID = Convert.ToInt32(Request.QueryString["NewsID"]);
ZhongLi.Model.News news = bll.GetModel(NewsID);
txtTitle.Text = news.Title;
if (news.ImgUrl != "")
{
img_Photo.ImageUrl = news.ImgUrl;
}
ddlNewsType.SelectedValue = news.NewsType + "";
ddlhot.SelectedValue = news.Hot == true ? "1" : "2";
txtAbsDes.Text = news.AbsDes;
txtNewsCon.Text = news.NewsCon;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ZhongLi.Model.News model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@NewsID", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@NewsCon", SqlDbType.NVarChar, -1),
new SqlParameter("@Hot", SqlDbType.Bit, 1),
new SqlParameter("@NewsType", SqlDbType.Int, 4),
new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@AbsDes", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.NewsID;
parameters[1].Value = model.Title;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.NewsCon;
parameters[4].Value = model.Hot;
parameters[5].Value = model.NewsType;
parameters[6].Value = model.ImgUrl;
parameters[7].Value = model.AbsDes;
DbHelperSQL.RunProcedure("News_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZhongLi.Model.News model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@NewsID", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@NewsCon", SqlDbType.NVarChar, -1),
new SqlParameter("@Hot", SqlDbType.Bit, 1),
new SqlParameter("@NewsType", SqlDbType.Int, 4),
new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@AbsDes", SqlDbType.NVarChar, 200)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.Title;
parameters[2].Value = model.CreateTime;
parameters[3].Value = model.NewsCon;
parameters[4].Value = model.Hot;
parameters[5].Value = model.NewsType;
parameters[6].Value = model.ImgUrl;
parameters[7].Value = model.AbsDes;
DbHelperSQL.RunProcedure("News_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
protected void btnsave_Click(object sender, EventArgs e)
{
ZhongLi.Model.News news = null;
if (Request.QueryString["NewsID"] != null)
{
news = bll.GetModel(Convert.ToInt32(Request.QueryString["NewsID"]));
}
else
{
news = new ZhongLi.Model.News();
news.CreateTime = DateTime.Now;
news.ImgUrl = "";
}
news.Title = txtTitle.Text;
news.NewsType = Convert.ToInt32(ddlNewsType.SelectedValue);
ZhongLi.Model.siteconfig site = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config"));
if (fileImg.HasFile)
{
if (fileImg.PostedFile.ContentLength <= site.FileSize * 1024)
{
string fileExt = Utils.GetFileExt(fileImg.FileName);
string newname = DateTime.Now.ToString("yyyyMMddHHmmssffff") + "." + fileExt;
string filePath = Utils.GetMapPath("/upload/news/") + newname;
fileImg.SaveAs(filePath);
news.ImgUrl = "/upload/news/" + newname;
}
}
news.Hot = ddlhot.SelectedValue == "1" ? true : false;
news.NewsCon = txtNewsCon.Text;
news.AbsDes = txtAbsDes.Text;
if (news.NewsID == 0)
{
if (bll.Add(news) > 0)
{
webHelper.addLog("新添加了内容“" + news.Title + "”");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('新增内容','保存成功！','',1)</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('新增内容','保存失败','',2)</script>");
}
}
else
{
if (bll.Update(news))
{
webHelper.addLog("修改了内容“" + news.Title + "”");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('编辑内容','保存成功！','',1)</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('编辑内容','保存失败','',2);</script>");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.News DataRowToModel(DataRow row)
{
ZhongLi.Model.News model = new ZhongLi.Model.News();
if (row != null)
{
if (row["NewsID"] != null && row["NewsID"].ToString() != "")
{
model.NewsID = int.Parse(row["NewsID"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["NewsCon"] != null)
{
model.NewsCon = row["NewsCon"].ToString();
}
if (row["Hot"] != null && row["Hot"].ToString() != "")
{
if ((row["Hot"].ToString() == "1") || (row["Hot"].ToString().ToLower() == "true"))
{
model.Hot = true;
}
else
{
model.Hot = false;
}
}
if (row["NewsType"] != null && row["NewsType"].ToString() != "")
{
model.NewsType = int.Parse(row["NewsType"].ToString());
}
if (row["ImgUrl"] != null)
{
model.ImgUrl = row["ImgUrl"].ToString();
}
if (row["AbsDes"] != null)
{
model.AbsDes = row["AbsDes"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.News GetModel(int NewsID)
{
SqlParameter[] parameters =
{
new SqlParameter("@NewsID", SqlDbType.Int, 4)
};
parameters[0].Value = NewsID;
ZhongLi.Model.News model = new ZhongLi.Model.News();
DataSet ds = DbHelperSQL.RunProcedure("News_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
BindNews();
string type = Request["type"];
string id = Request["id"];
switch (type)
{
case "news":
NEWM = NEW.GetModel(Convert.ToInt32(id));
title = NEWM.Title;
count = NEWM.NewsCon;
time = "发表时间：" + NEWM.CreateTime.ToString();
break;
case "jo":
jom = jo.GetModel(Convert.ToInt32(id));
title = jom.JobTraTitle;
count = jom.JobTraDes;
time = "";
break;
case "cp":
cpm = cp.GetModel(Convert.ToInt32(id));
title = cpm.CPTitle;
count = cpm.CPDes;
time = "发表时间：" + cpm.CreateTime.ToString();
break;
}
ZhongLi.Model.siteconfig config = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config"));
log = config.log;
phone = config.phone;
mail = config.mail;
bjtu = config.bgtu;
QRCode = config.QRCode;
}
