/// <summary>
/// 修改ArticleTypeInfo
/// </summary>
/// <param name="articletype"></param>
/// <returns></returns>
public static int UpdateArticleType(ArticleTypeInfo articletype)
{
string sql = @"UPDATE [ArticleType] SET
Name=@Name,
PId=@PId,
Sort=@Sort,
PinYin=@PinYin,
IsHomeMenu=@IsHomeMenu,
CreateTime=@CreateTime,
Ico=@Ico,
IsShow=@IsShow
WHERE Id=@Id";
var par = new DynamicParameters();
par.Add("@Id", articletype.Id, DbType.Int32);
par.Add("@Name", articletype.Name, DbType.AnsiString);
par.Add("@PId", articletype.PId, DbType.Int32);
par.Add("@Sort", articletype.Sort, DbType.Int32);
par.Add("@PinYin", articletype.PinYin, DbType.AnsiString);
par.Add("@IsHomeMenu", articletype.IsHomeMenu, DbType.Boolean);
par.Add("@CreateTime", articletype.CreateTime, DbType.DateTime);
par.Add("@Ico", articletype.Ico, DbType.AnsiString);
par.Add("@IsShow", articletype.IsShow, DbType.Boolean);
return(DapWrapper.InnerExecuteSql(DbConfig.ArticleManagerConnString, sql, par));
}
public ActionResult PostCategData()
{
int parentId = DoRequest.GetFormInt("parentId");
int itemId = DoRequest.GetFormInt("itemId");
string name = DoRequest.GetFormString("name").Trim();
int sort = DoRequest.GetFormInt("sort", 0);
#region Checking
if (name.Length < 1)
{
return(Json(new { error = true, message = "【名称】不能为空" }));
}
if (name.Length > 50)
{
return(Json(new { error = true, message = "【名称】不能多于50个字符" }));
}
#endregion
List <ArticleTypeInfo> tList = new List <ArticleTypeInfo>();
var resart = GetArticleType.Do(0, 2, -1);
if (resart != null && resart.Body != null && resart.Body.article_type_list != null)
{
tList = resart.Body.article_type_list;
}
ArticleTypeInfo tInfo = tList.Find(delegate(ArticleTypeInfo em)
{
return(em.article_type_id == itemId);
});
if (tInfo == null)
{
tInfo = new ArticleTypeInfo();
}
tInfo.article_type_id = itemId;
tInfo.parent_id = parentId;
tInfo.article_type_name = name;
tInfo.sort_no = sort;
int returnValue = -1;
var res = OpArticleType.Do(tInfo);
if (res != null && res.Header != null && res.Header.Result != null && res.Header.Result.Code != null)
{
returnValue = Utils.StrToInt(res.Header.Result.Code, -1);
}
if (returnValue == 0)
{
return(Json(new { error = false, message = "操作成功" }));
}
return(Json(new { error = true, message = "操作失败" }));
}
/// <summary>
/// DataModel 转 ViewModel
/// </summary>
/// <param name="articletype"></param>
/// <returns></returns>
public static ArticleTypeVModel ArticleTypeInfoToVModel(ArticleTypeInfo articletype)
{
if (articletype == null)
{
return(new ArticleTypeVModel());
}
return(new ArticleTypeVModel
{
Id = articletype.Id,
Name = articletype.Name,
PId = articletype.PId,
Sort = articletype.Sort,
PinYin = articletype.PinYin,
IsHomeMenu = articletype.IsHomeMenu,
CreateTime = articletype.CreateTime,
Ico = articletype.Ico,
IsShow = articletype.IsShow
});
}
/// <summary>
/// 添加ArticleTypeInfo
/// </summary>
/// <param name="articletype"></param>
/// <returns></returns>
public static int AddArticleType(ArticleTypeInfo articletype)
{
string sql = @"INSERT INTO [ArticleType]
([Name],[PId],[Sort],[PinYin],[IsHomeMenu],[Ico],[IsShow])
VALUES
(@Name,@PId,@Sort,@PinYin,@IsHomeMenu,@Ico,@IsShow)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Name", articletype.Name, DbType.AnsiString);
par.Add("@PId", articletype.PId, DbType.Int32);
par.Add("@Sort", articletype.Sort, DbType.Int32);
par.Add("@PinYin", articletype.PinYin, DbType.AnsiString);
par.Add("@IsHomeMenu", articletype.IsHomeMenu, DbType.Boolean);
par.Add("@Ico", articletype.Ico, DbType.AnsiString);
par.Add("@IsShow", articletype.IsShow, DbType.Boolean);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 修改ArticleTypeInfo
/// </summary>
/// <param name="articletype"></param>
/// <returns></returns>
public static int UpdateArticleType(ArticleTypeInfo articletype)
{
return(DataProvider.ArticleTypes.UpdateArticleType(articletype));
}
/// <summary>
/// 添加ArticleTypeInfo
/// </summary>
/// <param name="articletype"></param>
/// <returns></returns>
public static int AddArticleType(ArticleTypeInfo articletype)
{
return(DataProvider.ArticleTypes.AddArticleType(articletype));
}
public ActionResult PostArticleData()
{
int id = DoRequest.GetFormInt("id");
int classId = DoRequest.GetFormInt("ClassID");
ArticleInfo article = new ArticleInfo();
var resarticle = GetArticleInfo.Do(id, "curr");
if (resarticle != null && resarticle.Body != null)
{
article = resarticle.Body;
}
List <ArticleTypeInfo> categs = new List <ArticleTypeInfo>();;//分类信息
var restype = GetArticleType.Do(0, 2, -1);
if (restype != null && restype.Body != null && restype.Body.article_type_list != null)
{
categs = restype.Body.article_type_list;
}
ArticleTypeInfo categ = categs.Find(delegate(ArticleTypeInfo em) {
return(em.article_type_id == classId);
});
if (categ == null)
{
categ = new ArticleTypeInfo();
}
if (categ.article_type_id < 1)
{
return(Json(new { error = true, input = "message", message = "请选择分类" }));
}
#region 获取参数
article.article_type_id = categ.article_type_id;
article.title_color = DoRequest.GetFormString("titlecolor");
article.is_top = DoRequest.GetFormInt("istop") > 0 ? 1 : 0;
article.article_title = DoRequest.GetFormString("title").Trim();
article.click_count = DoRequest.GetFormInt("clickcount");
article.key_word = DoRequest.GetFormString("keyword").Trim();
article.article_source = DoRequest.GetFormString("source").Trim();
article.author_name = DoRequest.GetFormString("author").Trim();
article.title_img = DoRequest.GetFormString("titleimg");
article.article_content = DoRequest.GetFormString("content", false).Trim();
#endregion
#region Checking
if (article.article_type_id < 1)
{
return(Json(new { error = true, input = "message", message = "请选择分类" }));
}
if (article.article_title.Length < 1)
{
return(Json(new { error = true, input = "message", message = "请填写标题" }));
}
if (article.article_title.Length > 200)
{
return(Json(new { error = true, input = "message", message = "标题不能大于200个字符" }));
}
if (article.click_count < 0)
{
return(Json(new { error = true, input = "message", message = "点击数不能小于0！" }));
}
#endregion
int returnValue = -1;
var res = OpArticle.Do(article);
if (res != null && res.Header != null && res.Header.Result != null && res.Header.Result.Code != null)
{
returnValue = Utils.StrToInt(res.Header.Result.Code, -1);
}
#region 判断是否操作成功
string msgText = "";
switch (returnValue)
{
case 0:
msgText = "操作成功 ^_^";
break;
case -1:
default:
msgText = "操作失败";
break;
}
#endregion
return(Json(new { error = returnValue == 0 ? false : true, message = msgText }));
}
public ActionResult GetArticleTypeInfo()
{
int parentId = DoRequest.GetFormInt("parentId");
int itemId = DoRequest.GetFormInt("itemId");
List <ArticleTypeInfo> tList = new List <ArticleTypeInfo>();
var res = GetArticleType.Do(0, 2, -1);
if (res != null && res.Body != null && res.Body.article_type_list != null)
{
tList = res.Body.article_type_list;
}
ArticleTypeInfo pInfo = new ArticleTypeInfo();
ArticleTypeInfo tInfo = new ArticleTypeInfo();
List <ArticleTypeInfo> temList = tList.FindAll(
delegate(ArticleTypeInfo item)
{
return(item.article_type_id == parentId);
});
if (temList.Count > 0)
{
pInfo = temList[0];
}
//子分类
temList = tList.FindAll(
delegate(ArticleTypeInfo item)
{
return(item.article_type_id == itemId);
});
if (temList.Count > 0)
{
tInfo = temList[0];
}
#region 设置排序
if (tInfo.article_type_id < 1)
{
temList = tList.FindAll(
delegate(ArticleTypeInfo item)
{
return(item.parent_id == parentId);
});
int sort = 0;
foreach (ArticleTypeInfo em in temList)
{
if (em.sort_no > sort)
{
sort = em.sort_no;
}
}
sort++;
tInfo.sort_no = sort;
}
#endregion
#region 分类名路径
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (pInfo.type_path == null)
{
pInfo.type_path = "";
}
string[] arr = pInfo.type_path.Split(',');
sb.Append("根");
foreach (string s in arr)
{
if (string.IsNullOrEmpty(s))
{
continue;
}
int val = Utils.StrToInt(s.Trim());
List <ArticleTypeInfo> list = tList.FindAll(
delegate(ArticleTypeInfo item)
{
return(item.article_type_id == val);
});
if (list.Count > 0)
{
sb.Append(" >> " + list[0].article_type_name);
}
}
#endregion
return(Json(new { parent = pInfo, type = tInfo, parentName = sb.ToString() }, JsonRequestBehavior.AllowGet));
}