public bool AddBendadmindMSG(Tadmin model)
{
var result = false;
const string AddBendadmindMSGsql = @"
INSERT INTO dbo.Tadmin
( AdAccount,AdPassWord,AdName,AdPhone,AdSection, AdIdCard,AdSetTime,AdRemark)
VALUES (
@AdAccount,
@AdPassWord,
@AdName,
@AdPhone,
@AdSection,
@AdIdCard,
@AdSetTime,
@AdRemark
)";
try
{
using (DbConnection conn = DbFactory.CreateConnection())
{
result = conn.Execute(AddBendadmindMSGsql, model) > 0;
return(result);
}
}
catch (System.Exception ex)
{
throw;
}
}
public ActionResult UpdateBendadmindMSG(Tadmin model)
{
var result = false;
result = _bendadmindBll.UpdateBendadmindMSG(model);
return(RedirectToAction("BendadminIndex", "Bendadmin"));
}
public bool AddBendadmindMSG(Tadmin model)
{
var NowTime = DateTime.Now;
model.AdSetTime = NowTime;
return(_bendadmindDal.AddBendadmindMSG(model));
}
public ActionResult Login(Tadmin avm)
{
Tadmin ad = db.Tadmin.Where(x => x.admin_username == avm.admin_username && x.admin_password == avm.admin_password).SingleOrDefault();
if (ad != null)
{
Session["admin_id"] = ad.admin_id.ToString();
return(RedirectToAction("Create"));
}
else
{
ViewBag.error = "Invalid username or password";
}
return(View());
}
public bool UpdateBendadmindMSG(Tadmin model)
{
const string UpdateGuestbookMSGsql = @"
UPDATE dbo.Tadmin
SET
AdAccount = @AdAccount,
AdPassWord = @AdPassWord,
AdName = @AdName,
AdPhone = @AdPhone,
AdSection = @AdSection,
AdIdCard = @AdIdCard,
AdSetTime = @AdSetTime,
AdRemark = @AdRemark
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(UpdateGuestbookMSGsql, model) > 0;
return(result);
}
}
public ActionResult BendadminAritialIndex(int Id = 0)
{
if (Id == 0)
{
Tadmin NoneModel = new Tadmin();
NoneModel.ID = 0;
NoneModel.AdSetTime = DateTime.Now;
NoneModel.AdSection = "什么都没有";
NoneModel.AdRemark = "什么也没有";
NoneModel.AdPhone = "什么也没有";
NoneModel.AdPassWord = "******";
NoneModel.AdName = "什么也没有";
NoneModel.AdIdCard = "什么也没有";
NoneModel.AdAccount = "什么也没有";
return(View(NoneModel));
}
else
{
var queryResult = _bendadmindBll.Query_Bendadmind(Id);
ViewData.Model = queryResult;
return(View(ViewData.Model));
}
}
public bool UpdateBendadmindMSG(Tadmin model)
{
return(_bendadmindDal.UpdateBendadmindMSG(model));
}
