public ActionResult Add(ArticleClassModel model)
{
model.CreateOn = DateTime.Now;
var result = articleClassService.CreateModel(model) ? SuccessTip() : ErrorTip();
return(Json(result));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ArticleClassModel GetModel(int ArticleClassId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ArticleClassId, ArticleClassName, MerId, OrderNo, ParentArticleClassId, ArticleClassMemo, ArticleClassImgId, Invalid ");
strSql.Append(" from ArticleClass ");
strSql.Append(" where ArticleClassId=@ArticleClassId");
SqlParameter[] parameters =
{
new SqlParameter("@ArticleClassId", SqlDbType.Int, 4)
};
parameters[0].Value = ArticleClassId;
ArticleClassModel model = new ArticleClassModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ArticleClassId"].ToString() != "")
{
model.ArticleClassId = int.Parse(ds.Tables[0].Rows[0]["ArticleClassId"].ToString());
}
model.ArticleClassName = ds.Tables[0].Rows[0]["ArticleClassName"].ToString();
if (ds.Tables[0].Rows[0]["MerId"].ToString() != "")
{
model.MerId = decimal.Parse(ds.Tables[0].Rows[0]["MerId"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderNo"].ToString() != "")
{
model.OrderNo = int.Parse(ds.Tables[0].Rows[0]["OrderNo"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentArticleClassId"].ToString() != "")
{
model.ParentArticleClassId = int.Parse(ds.Tables[0].Rows[0]["ParentArticleClassId"].ToString());
}
model.ArticleClassMemo = ds.Tables[0].Rows[0]["ArticleClassMemo"].ToString();
model.ArticleClassImgId = ds.Tables[0].Rows[0]["ArticleClassImgId"].ToString();
if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true"))
{
model.Invalid = true;
}
else
{
model.Invalid = false;
}
}
return(model);
}
else
{
return(null);
}
}
public ActionResult Add()
{
ArticleClassModel model = new ArticleClassModel {
ClassType = 2
};
Load();
Loads();
return(View(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ArticleClassModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update ArticleClass set ");
strSql.Append(" ArticleClassName = @ArticleClassName , ");
strSql.Append(" MerId = @MerId , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" ParentArticleClassId = @ParentArticleClassId , ");
strSql.Append(" ArticleClassMemo = @ArticleClassMemo , ");
strSql.Append(" ArticleClassImgId = @ArticleClassImgId , ");
strSql.Append(" Invalid = @Invalid ");
strSql.Append(" where ArticleClassId=@ArticleClassId ");
SqlParameter[] parameters =
{
new SqlParameter("@ArticleClassId", SqlDbType.Int, 4),
new SqlParameter("@ArticleClassName", SqlDbType.VarChar, 50),
new SqlParameter("@MerId", SqlDbType.Decimal, 9),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@ParentArticleClassId", SqlDbType.Int, 4),
new SqlParameter("@ArticleClassMemo", SqlDbType.VarChar, 200),
new SqlParameter("@ArticleClassImgId", SqlDbType.VarChar, 50),
new SqlParameter("@Invalid", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ArticleClassId;
parameters[1].Value = model.ArticleClassName;
parameters[2].Value = model.MerId;
parameters[3].Value = model.OrderNo;
parameters[4].Value = model.ParentArticleClassId;
parameters[5].Value = model.ArticleClassMemo;
parameters[6].Value = model.ArticleClassImgId;
parameters[7].Value = model.Invalid; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ArticleClassModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ArticleClass(");
strSql.Append("ArticleClassName,MerId,OrderNo,ParentArticleClassId,ArticleClassMemo,ArticleClassImgId,Invalid");
strSql.Append(") values (");
strSql.Append("@ArticleClassName,@MerId,@OrderNo,@ParentArticleClassId,@ArticleClassMemo,@ArticleClassImgId,@Invalid");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ArticleClassName", SqlDbType.VarChar, 50),
new SqlParameter("@MerId", SqlDbType.Decimal, 9),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@ParentArticleClassId", SqlDbType.Int, 4),
new SqlParameter("@ArticleClassMemo", SqlDbType.VarChar, 200),
new SqlParameter("@ArticleClassImgId", SqlDbType.VarChar, 50),
new SqlParameter("@Invalid", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ArticleClassName;
parameters[1].Value = model.MerId;
parameters[2].Value = model.OrderNo;
parameters[3].Value = model.ParentArticleClassId;
parameters[4].Value = model.ArticleClassMemo;
parameters[5].Value = model.ArticleClassImgId;
parameters[6].Value = model.Invalid;
bool result = false;
try
{
model.ArticleClassId = int.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "ArticleClassId", parameters));
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
public ActionResult Edit(int id)
{
ArticleClassInfo classinfo = ArticleClass.AdminGetModelById(id);
if (classinfo == null)
{
return(PromptView("分类不存在"));
}
ArticleClassModel model = new ArticleClassModel();
model.ArticleClassID = classinfo.ArticleClassID;
model.ClassName = classinfo.ClassName;
model.ClassType = classinfo.ClassType;
model.ParentArticleClassID = classinfo.ParentArticleClassID;
model.Target = classinfo.Target;
model.IsNav = classinfo.IsNav;
model.IsWeb = classinfo.IsWeb;
model.WebUrl = classinfo.WebUrl;
model.IsAdmin = classinfo.IsAdmin;
model.AdminUrl = classinfo.AdminUrl;
model.DisplayOrder = classinfo.DisplayOrder;
model.IsOpen = classinfo.IsOpen;
model.ListView = classinfo.ListView;
model.ContentView = classinfo.ContentView;
model.Code = classinfo.Code;
model.ImgUrl = classinfo.ImgUrl;
model.Keyword = classinfo.Keyword;
model.Description = classinfo.Description;
model.IsClassBrand = classinfo.IsClassBrand;
model.Subhead = classinfo.Subhead;
model.IsShowNews = classinfo.IsShowNews;
Load();
Loads();
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
public ActionResult Add(ArticleClassModel model)
{
ArticleClassInfo info = new ArticleClassInfo();
//获取当前登录用户信息
string ck = WebHelper.GetCookie("bs", "uname");
PartUserInfo partUserInfo = Users.GetPartUserByName(ck);
if (ModelState.IsValid)
{
info.ClassName = model.ClassName;
info.ParentArticleClassID = model.ParentArticleClassID;
info.ClassType = model.ClassType;
info.Target = model.Target;
info.IsWeb = model.IsWeb;
info.IsNav = model.IsNav;
info.WebUrl = model.WebUrl == null ? "" : model.WebUrl;
info.IsAdmin = model.IsAdmin;
info.AdminUrl = model.AdminUrl == null ? "" : model.AdminUrl;
info.DisplayOrder = model.DisplayOrder;
info.IsOpen = model.IsOpen;
info.ListView = model.ListView;
info.ContentView = model.ContentView;
info.Code = model.Code;
info.ImgUrl = model.ImgUrl;
info.Keyword = model.Keyword == null ? "" : model.Keyword;
info.Description = model.Description == null ? "" : model.Description;
info.IsClassBrand = model.IsClassBrand;
info.Subhead = model.Subhead;
info.Auditor = ck;
info.IsShowNews = model.IsShowNews;
ArticleClass.Create(info);
AddLog(info, "分类新加成功");
//AddAdminOperateLog
return(PromptView("分类新加成功"));
}
Loads();
return(View(model));
}
public ActionResult Edit(ArticleClassModel model)
{
var result = articleClassService.UpdateModel(model) ? SuccessTip() : ErrorTip();
return(Json(result));
}
public JsonResult List(ArticleClassModel filter, PageInfo pageInfo)
{
var result = articleClassService.GetListByFilter(filter, pageInfo);
return(Json(result, JsonRequestBehavior.AllowGet));
}
