public ActionResult Save(ImageManageViewModel mode)
{
ImageManageBLL bll = new ImageManageBLL();
string msg = string.Empty;
bool b = bll.Save(mode, out msg);
return(Json(new { success = b, message = msg }, JsonRequestBehavior.AllowGet));
}
public ImageManageList getList(ImageManageViewModel model)
{
ImageManageList list = new ImageManageList();
DataTable dt = dal.getList(model);
list.rows = dt.toList <ImageManageModel>();
list.total = dal.getCount(model);
return(list);
}
public ActionResult SearchImage(ImageManageViewModel model)
{
model.page = int.Parse(Request["page"]);
model.rows = int.Parse(Request["rows"]);
ImageManageBLL bll = new ImageManageBLL();
ImageManageList list = bll.getList(model);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public bool Update(ImageManageViewModel mode)
{
StringBuilder sbAddUser = new StringBuilder();
string GetSessionWithDsmId = string.Format(@"update ImageManage set ImageName='{0}',ImagePosition ='{1}',
ImageURL ='{2}' ,CreateDate ='{3}' where Id ='{4}'
", mode.ImageName, mode.ImagePosition, mode.ImageURL, mode.CreateDate, mode.Id);
int iResult = DBHelper.ExcuteNoQuerySql(GetSessionWithDsmId);
if (iResult == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert(ImageManageViewModel mode)
{
StringBuilder sbAddUser = new StringBuilder();
string GetSessionWithDsmId = string.Format(@"INSERT INTO ImageManage
(ImageName,ImagePosition,ImageURL,CreateDate)
VALUES('{0}','{1}','{2}','{3}')",
mode.ImageName, mode.ImagePosition, mode.ImageURL, DateTime.Now);
int iResult = DBHelper.ExcuteNoQuerySql(GetSessionWithDsmId);
if (iResult == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool Save(ImageManageViewModel mode, out string msg)
{
bool b = false;
msg = string.Empty;
bool isvail = dal.IsVaildtion(mode.ImagePosition);
if (mode.Id > 0)
{
if (isvail)
{
b = dal.Update(mode);
}
else
{
switch (mode.ImagePosition)
{
case "0":
msg = "轮播已存在3张图片!";
break;
case "1":
msg = "最新已存在1张图片!";
break;
case "2":
msg = "热点已存在1张图片!";
break;
case "3":
msg = "已存在1张图片!";
break;
case "4":
msg = "Logo已存在1张图片!";
break;
default:
msg = string.Empty;
break;
}
}
}
else
{
if (isvail)
{
b = dal.Insert(mode);
}
else
{
switch (mode.ImagePosition)
{
case "0":
msg = "轮播已存在3张图片,只能进行修改";
break;
case "1":
msg = "最新已存在1张图片,只能进行修改";
break;
case "2":
msg = "热点已存在1张图片,只能进行修改";
break;
case "3":
msg = "已存在1张图片,只能进行修改";
break;
case "4":
msg = "Logo已存在1张图片,只能进行修改";
break;
default:
msg = string.Empty;
break;
}
}
}
return(b);
}