public ActionResult Edit(tbl_news tbl_news, HttpPostedFileBase upload1, HttpPostedFileBase upload2, HttpPostedFileBase upload3, HttpPostedFileBase upload4)
{
if (ModelState.IsValid)
{
//الصورة الاولى
string path1 = Path.Combine(Server.MapPath("~/Uploads"), upload1.FileName);
upload1.SaveAs(path1);
tbl_news.news_img1 = upload1.FileName;
//الصورة الثانية
string path2 = Path.Combine(Server.MapPath("~/Uploads"), upload2.FileName);
upload2.SaveAs(path2);
tbl_news.news_img2 = upload2.FileName;
//الصورة الثالثة
string path3 = Path.Combine(Server.MapPath("~/Uploads"), upload3.FileName);
upload3.SaveAs(path3);
tbl_news.news_img3 = upload3.FileName;
//الصورة الرابعة
string path4 = Path.Combine(Server.MapPath("~/Uploads"), upload4.FileName);
upload4.SaveAs(path4);
tbl_news.news_img4 = upload4.FileName;
db.Entry(tbl_news).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_news));
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
int sucCount = 0; //成功数量
int errorCount = 0; //失败数量
tbl_news bll = new tbl_news();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
if (bll.Delete(id))
{
sucCount++;
}
else
{
errorCount++;
}
}
}
// mym.AddAdminLog("删除", "删除公告成功" + sucCount + "条，失败" + errorCount + "条"); //记录日志
mym.JscriptMsg(this.Page, " 删除公告成功" + sucCount + "条，失败" + errorCount + "条", Utils.CombUrlTxt("al_read1.aspx", "keywords={0}&page={1}", this.keywords, this.page.ToString()), "Success");
}
public bool InsertNews(mNews pNews)
{
try
{
tbl_news vNews = new tbl_news();
var query = from b in Db.tbl_news
orderby b.news_id descending
select b;
vNews = query.FirstOrDefault();
tbl_news n = new tbl_news();
n.news_summery = pNews.news_summery;
n.news_image = pNews.news_image;
n.news_title = pNews.news_title;
n.news_exp = pNews.news_exp;
n.news_date = pNews.news_date;
n.news_writer = pNews.news_writer;
n.news_index = pNews.news_index;
n.news_img_alt = pNews.news_img_alt;
n.news_href = pNews.news_href;
n.news_code = pNews.news_code;
n.news_visit = 200;
n.news_id = vNews.news_id + 1;
n.news_img_alt = pNews.news_img_alt;
Db.tbl_news.Add(n);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
private bool DoEdit(int _id)
{
bool result = false;
tbl_news model = new tbl_news();
model.GetModel(_id);
model.title = txttitle.Text.Trim();
model.memo = txtContent.Value;
model.news_date = Utils.StrToDateTime(txtAddTime.Text.Trim());
model.sort_id = int.Parse(txtSortId.Text.Trim());
if (is_show.Checked == true)
{
model.is_show = 1;
}
else
{
model.is_show = 0;
}
if (model.Update())
{
//mym.AddAdminLog("修改", "修改通知公告:" + txttitle.Text); //记录日志
result = true;
}
return(result);
}
public ActionResult DeleteConfirmed(int id)
{
tbl_news tbl_news = db.tbl_news.Find(id);
db.tbl_news.Remove(tbl_news);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,title,Content,Images")] tbl_news tbl_news)
{
if (ModelState.IsValid)
{
db.Entry(tbl_news).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_news));
}
public ActionResult Create([Bind(Include = "id,title,Content,Images")] tbl_news tbl_news)
{
if (ModelState.IsValid)
{
db.tbl_news.Add(tbl_news);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_news));
}
// 单个删除
protected void lbtnDelCa_Click(object sender, EventArgs e)
{
// 当前点击的按钮
LinkButton lb = (LinkButton)sender;
int caId = int.Parse(lb.CommandArgument);
tbl_news bll = new tbl_news();
bll.GetModel(caId);
string title = bll.title;
bll.Delete(caId);
// mym.AddAdminLog("删除", "删除公告：" + title + ""); //记录日志
mym.JscriptMsg(this.Page, " 成功删除公告：" + title + "", Utils.CombUrlTxt("al_read1.aspx", "keywords={0}&page={1}", this.keywords, this.page.ToString()), "Success");
}
// GET: tbl_news/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_news tbl_news = db.tbl_news.Find(id);
if (tbl_news == null)
{
return(HttpNotFound());
}
return(View(tbl_news));
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = AXRequest.GetQueryInt("page", 1);
tbl_news bll = new tbl_news();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("al_read.aspx", "page={0}", "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void ShowInfo(int _id)
{
tbl_news model = new tbl_news();
model.GetModel(_id);
Littitle.Text = model.title;
LitContent.Text = model.memo;
LitAddTime.Text = Convert.ToDateTime(model.news_date).ToString("yyyy-MM-dd HH:mm:ss");
LitClickCount.Text = model.read_count.ToString();
//更新浏览次数
int click = int.Parse(model.read_count.ToString()) + 1;
model.UpdateField(id, "read_count=" + click);
}
private void ShowInfo(int _id)
{
tbl_news model = new tbl_news();
model.GetModel(_id);
txttitle.Text = model.title;
txtContent.Value = model.memo;
txtAddTime.Text = Convert.ToDateTime(model.news_date).ToString("yyyy-MM-dd HH:mm:ss");
txtSortId.Text = model.sort_id.ToString();
if (model.is_show.ToString() == "1")
{
is_show.Checked = true;
}
else
{
is_show.Checked = false;
}
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
tbl_news bll = new tbl_news();
Repeater rptList = new Repeater();
rptList = this.rptList;
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
mym.JscriptMsg(this.Page, " 排序保存成功", Utils.CombUrlTxt("al_read1.aspx", "keywords={0}&page={1}", this.keywords, this.page.ToString()), "Success");
}
public bool fUpdateNews(mNews pNews)
{
tbl_news n = new tbl_news();
n.news_id = pNews.news_id;
n.news_summery = pNews.news_summery;
n.news_image = pNews.news_image;
n.news_title = pNews.news_title;
n.news_exp = pNews.news_exp;
n.news_date = pNews.news_date;
n.news_writer = pNews.news_writer;
n.news_category = pNews.news_category;
n.news_index = pNews.news_index;
n.news_visit = pNews.news_visit;
n.news_img_alt = pNews.news_img_alt;
n.news_href = pNews.news_href;
n.news_code = pNews.news_code;
Db.tbl_news.Attach(n);
Db.Entry(n).State = System.Data.Entity.EntityState.Modified;
return(Convert.ToBoolean(Db.SaveChanges()));
}
private bool DoAdd()
{
tbl_news model = new tbl_news();
model.title = txttitle.Text.Trim();
model.memo = txtContent.Value;
model.news_date = Utils.StrToDateTime(txtAddTime.Text.Trim());
model.sort_id = int.Parse(txtSortId.Text.Trim());
if (is_show.Checked == true)
{
model.is_show = 1;
}
else
{
model.is_show = 0;
}
if (model.Add() > 0)
{
return(true);
}
return(false);
}
public static tbl_news Createtbl_news(int id)
{
tbl_news tbl_news = new tbl_news();
tbl_news.ID = id;
return tbl_news;
}
public void AddTotbl_news(tbl_news tbl_news)
{
base.AddObject("tbl_news", tbl_news);
}
