public ActionResult DeleteConfirmed(int id, string cid, string cid1)
{
using (Aitag_DBContext con = new Aitag_DBContext())
{
Webmaincontent Webmaincontents = con.Webmaincontents.Find(id);
con.Webmaincontents.Remove(Webmaincontents);
con.SaveChanges();
//系統LOG檔 //================================================= //
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
string syssubname = "網站管理作業 > 網站內容管理";
string sysnote = "名稱:" + Webmaincontents.AC_Mctitle;
string sysflag = "D";
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
if (cid1 == "0")
{
return(RedirectToAction("List", new { cid = cid, cid1 = cid1 }));
}
else
{
return(RedirectToAction("List", new { cid = cid1, cid1 = cid }));
}
}
}
public ActionResult Edit(int id)
{
using (Aitag_DBContext con = new Aitag_DBContext())
{
var data = con.Webmaincontents.Where(r => r.AC_Mcid == id).FirstOrDefault();
Webmaincontent Webmaincontents = con.Webmaincontents.Find(id);
if (Webmaincontents == null)
{
return(HttpNotFound());
}
return(View(Webmaincontents));
}
}
public ActionResult Add(string cid, string cid1)
{
Webmaincontent col = new Webmaincontent();
if (cid1 != "0")
{
col.AC_Cid = int.Parse(cid1);
col.AC_Ccid = int.Parse(cid);
}
else
{
col.AC_Cid = int.Parse(cid);
col.AC_Ccid = 0;
}
ViewBag.cid = cid;
ViewBag.cid1 = cid1;
return(View(col));
}
public ActionResult add(Webmaincontent col, HttpPostedFileBase Mcfile, HttpPostedFileBase Mpic)
{
ViewBag.Cid = col.AC_Cid.ToString();
ViewBag.Ccid = col.AC_Ccid.ToString();
/*
* if (Mcfile == null)
* {
* ModelState.AddModelError("Mcfile", "請選擇檔案");
* }
*/
if (!ModelState.IsValid)
{
return(View(col));
}
Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
//上傳檔案****開始
int sernonum;
if (Mcfile != null)
{
// Uploadfile.SaveAs(Server.MapPath("~/Uploads/") + Apic.FileName);
//上傳檔案
//找序號
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
SqlDataReader dr;
SqlCommand sqlsmd = new SqlCommand();
sqlsmd.Connection = conn;
string sqlstr = "select sno from Serno where sid=1";
sqlsmd.CommandText = sqlstr;
dr = sqlsmd.ExecuteReader();
if (dr.Read())
{
//重新命名，存入檔案
sernonum = int.Parse(dr[0].ToString()) + 1;
string fileName = "contente" + sernonum.ToString() + Mcfile.FileName.Substring(Mcfile.FileName.IndexOf("."), Mcfile.FileName.Length - Mcfile.FileName.IndexOf("."));
Mcfile.SaveAs(Server.MapPath("~/Upload/") + fileName);
col.AC_Mcfile = fileName;
//序號+1後存入
Aitag.Models.NDcommon dbobj1 = new Aitag.Models.NDcommon();
SqlConnection conn1 = dbobj1.get_conn("Aitag_DBContext");
SqlCommand sqlsmd1 = new SqlCommand();
sqlsmd1.Connection = conn1;
string sqlstr1 = "UPDATE Serno SET sno ='" + sernonum + "' where sid=1";
sqlsmd1.CommandText = sqlstr1;
sqlsmd1.ExecuteReader();
sqlsmd1.Dispose();
conn1.Close();
conn1.Dispose();
}
sqlsmd.Dispose();
conn.Close();
conn.Dispose();
}
//上傳圖片****開始
if (Mpic != null)
{
//上傳檔案
//找序號
SqlConnection conn = dbobj.get_conn("Aitag_DBContext");
SqlDataReader dr;
SqlCommand sqlsmd = new SqlCommand();
sqlsmd.Connection = conn;
string sqlstr = "select sno from Serno where sid=1";
sqlsmd.CommandText = sqlstr;
dr = sqlsmd.ExecuteReader();
if (dr.Read())
{
//重新命名，存入檔案
sernonum = int.Parse(dr[0].ToString()) + 1;
string fileName = "contente" + sernonum.ToString() + Mpic.FileName.Substring(Mpic.FileName.IndexOf("."), Mpic.FileName.Length - Mpic.FileName.IndexOf("."));
Mpic.SaveAs(Server.MapPath("~/Upload/") + fileName);
col.AC_Mpic = fileName;
//序號+1後存入
Aitag.Models.NDcommon dbobj1 = new Aitag.Models.NDcommon();
SqlConnection conn1 = dbobj1.get_conn("Aitag_DBContext");
SqlCommand sqlsmd1 = new SqlCommand();
sqlsmd1.Connection = conn1;
string sqlstr1 = "UPDATE Serno SET sno ='" + sernonum + "' where sid=1";
sqlsmd1.CommandText = sqlstr1;
sqlsmd1.ExecuteReader();
sqlsmd1.Dispose();
conn1.Close();
conn1.Dispose();
}
sqlsmd.Dispose();
conn.Close();
conn.Dispose();
}
col.AC_Baddid = Session["tempid"].ToString();
col.AC_Badddate = DateTime.Now;
col.AC_Bmodid = Session["tempid"].ToString();
col.AC_Bmoddate = DateTime.Now;
using (Aitag_DBContext con = new Aitag_DBContext())
{
con.Webmaincontents.Add(col);
con.SaveChanges();
}
//系統LOG檔 //================================================= //
//Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon();
string syssubname = "網站管理作業 > 網站內容管理";
string sysnote = "名稱:" + col.AC_Mctitle;
string sysflag = "A";
SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext");
dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag);
sysconn.Close();
sysconn.Dispose();
//=================================================
if (col.AC_Ccid != 0)
{
return(RedirectToAction("List", new { cid = col.AC_Ccid, cid1 = col.AC_Cid }));
}
else
{
return(RedirectToAction("List", new { cid = col.AC_Cid, cid1 = 0 }));
}
}
