public JsonResult Add(T_EC_KeyWords keyword)
{
keyword.ID = RandomHelper.GetUUID();
MsgEntity me = _keywordService.Add(keyword);
return(Json(me, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据ID查找对象
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public T_EC_KeyWords Get(string ID)
{
T_EC_KeyWords keyword = new T_EC_KeyWords();
try
{
keyword = dao.GetById <T_EC_KeyWords>(ID);
}
catch (Exception ex)
{
throw ex;
}
return(keyword);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public MsgEntity Add(T_EC_KeyWords keyword)
{
MsgEntity me = new MsgEntity();
if (keyword == null || string.IsNullOrEmpty(keyword.KEY_WORD))
{
me.MsgCode = MsgEntity.MsgCodeEnum.Failure;
me.MsgDes = "名称不能为空";
return(me);
}
//查找关键字是否有相同值（不同plate_type的name不能相同）
PredicateGroup pg = new PredicateGroup {
Operator = GroupOperator.And, Predicates = new List <IPredicate>()
};
pg.Predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KEY_WORD, Operator.Eq, keyword.KEY_WORD));
pg.Predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.PLAT_TYPE, Operator.Eq, keyword.PLAT_TYPE));
int count = dao.Count <T_EC_KeyWords>(pg);
if (count > 0)
{
me.MsgCode = MsgEntity.MsgCodeEnum.Failure;
me.MsgDes = "同一平台名称重复";
return(me);
}
dynamic result = null;
try
{
result = dao.Insert <T_EC_KeyWords>(keyword);
}
catch (Exception ex)
{
throw ex;
}
if (result != null)
{
me.MsgCode = MsgEntity.MsgCodeEnum.Success;
me.MsgDes = MsgEntity.MsgCodeEnum.Success.GetDescription();
}
return(me);
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public MsgEntity Edit(T_EC_KeyWords keyword)
{
MsgEntity me = new MsgEntity();
if (keyword == null || string.IsNullOrEmpty(keyword.KEY_WORD))
{
me.MsgCode = MsgEntity.MsgCodeEnum.Failure;
me.MsgDes = "名称不能为空";
return(me);
}
//查找关键字是否有相同值（不同id的dict_code不能相同）
PredicateGroup pg = new PredicateGroup {
Operator = GroupOperator.And, Predicates = new List <IPredicate>()
};
pg.Predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KEY_WORD, Operator.Eq, keyword.KEY_WORD));
pg.Predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.PLAT_TYPE, Operator.Eq, keyword.PLAT_TYPE));
pg.Predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.ID, Operator.Eq, keyword.ID, true));
int count = dao.Count <T_EC_KeyWords>(pg);
if (count > 0)
{
me.MsgCode = MsgEntity.MsgCodeEnum.Failure;
me.MsgDes = "同一平台名称重复";
return(me);
}
bool result = false;
try
{
result = dao.Update <T_EC_KeyWords>(keyword);
me.MsgCode = MsgEntity.MsgCodeEnum.Success;
me.MsgDes = "编辑成功";
}
catch (Exception ex)
{
me.MsgCode = MsgEntity.MsgCodeEnum.Failure;
me.MsgDes = ex.Message;
}
return(me);
}
/// <summary>
/// 谓词组装，全部字段以And组装
/// </summary>
/// <param name="keywordEntity">对象</param>
/// <returns></returns>
public PredicateGroup PredicateFactory(T_EC_KeyWords keywordEntity)
{
PredicateGroup predicateGroup = null;
if (keywordEntity == null)
{
return(predicateGroup);
}
List <IPredicate> predicates = new List <IPredicate>();
//ID
if (!string.IsNullOrEmpty(keywordEntity.ID) && !string.IsNullOrEmpty(keywordEntity.ID.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.ID, Operator.Eq, keywordEntity.ID));
}
//PLAT_TYPE
if (!string.IsNullOrEmpty(keywordEntity.PLAT_TYPE) && !string.IsNullOrEmpty(keywordEntity.PLAT_TYPE.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.PLAT_TYPE, Operator.Eq, keywordEntity.PLAT_TYPE));
}
//KEYWORD_TYPE
if (!string.IsNullOrEmpty(keywordEntity.KEYWORD_TYPE) && !string.IsNullOrEmpty(keywordEntity.KEYWORD_TYPE.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KEYWORD_TYPE, Operator.Eq, keywordEntity.KEYWORD_TYPE));
}
//GOODS_TYPE
if (!string.IsNullOrEmpty(keywordEntity.GOODS_TYPE) && !string.IsNullOrEmpty(keywordEntity.GOODS_TYPE.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.GOODS_TYPE, Operator.Eq, keywordEntity.GOODS_TYPE));
}
//KEY_WORD
if (!string.IsNullOrEmpty(keywordEntity.KEY_WORD) && !string.IsNullOrEmpty(keywordEntity.KEY_WORD.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KEY_WORD, Operator.Eq, keywordEntity.KEY_WORD));
}
//KW_CN
if (!string.IsNullOrEmpty(keywordEntity.KW_CN) && !string.IsNullOrEmpty(keywordEntity.KW_CN.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KW_CN, Operator.Eq, keywordEntity.KW_CN));
}
//KW_DES
if (!string.IsNullOrEmpty(keywordEntity.KW_DES) && !string.IsNullOrEmpty(keywordEntity.KW_DES.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KW_DES, Operator.Eq, keywordEntity.KW_DES));
}
//KW_VOLUME
if (keywordEntity.KW_VOLUME != null)
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.KW_VOLUME, Operator.Eq, keywordEntity.KW_VOLUME));
}
//C_DATA_TIME
if (keywordEntity.C_DATA_TIME != null)
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.C_DATA_TIME, Operator.Eq, keywordEntity.C_DATA_TIME));
}
//C_DATA_UID
if (!string.IsNullOrEmpty(keywordEntity.C_DATA_UID) && !string.IsNullOrEmpty(keywordEntity.C_DATA_UID.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.C_DATA_UID, Operator.Eq, keywordEntity.C_DATA_UID));
}
//U_DATA_TIME
if (keywordEntity.U_DATA_TIME != null)
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.U_DATA_TIME, Operator.Eq, keywordEntity.U_DATA_TIME));
}
//U_DATA_UID
if (!string.IsNullOrEmpty(keywordEntity.U_DATA_UID) && !string.IsNullOrEmpty(keywordEntity.U_DATA_UID.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.U_DATA_UID, Operator.Eq, keywordEntity.U_DATA_UID));
}
//RESERVE1
if (!string.IsNullOrEmpty(keywordEntity.RESERVE1) && !string.IsNullOrEmpty(keywordEntity.RESERVE1.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.RESERVE1, Operator.Eq, keywordEntity.RESERVE1));
}
//RESERVE2
if (!string.IsNullOrEmpty(keywordEntity.RESERVE2) && !string.IsNullOrEmpty(keywordEntity.RESERVE2.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.RESERVE2, Operator.Eq, keywordEntity.RESERVE2));
}
//RESERVE3
if (!string.IsNullOrEmpty(keywordEntity.RESERVE3) && !string.IsNullOrEmpty(keywordEntity.RESERVE3.Trim()))
{
predicates.Add(Predicates.Field <T_EC_KeyWords>(f => f.RESERVE3, Operator.Eq, keywordEntity.RESERVE3));
}
predicateGroup = new PredicateGroup {
Operator = GroupOperator.And, Predicates = predicates
};
return(predicateGroup);
}
/// <summary>
/// 根据前台传递的参数，对"字典项"数据进行分页，搜索
/// </summary>
/// <param name="pageNumber">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="number">返回的total总数</param>
/// <param name="sort">排序字段</param>
/// <param name="sortOrder">排序标识asc或desc</param>
/// <returns></returns>
public List <T_EC_KeyWords> GetKeyWordsPages(int pageNumber, int pageSize, out long number, string sort = null, string sortOrder = null, T_EC_KeyWords keywordEntity = null)
{
string orderby = string.Empty;
if (sort != null && sortOrder != null)
{
orderby = "ORDER BY tkeywords." + sort + " " + sortOrder;
}
string query = @"SELECT tkeywords.*,
tPlatType.DI_NAME AS PLAT_TYPE_NAME,
tcategory.CATEGORY_NAME AS CATEGORY_NAME
FROM T_EC_KeyWords AS tkeywords
LEFT JOIN T_Sys_DictItem AS tPlatType
ON tkeywords.PLAT_TYPE=tPlatType.ID
LEFT JOIN T_EC_KWCategory AS tcategory
ON tkeywords.GOODS_TYPE = tcategory.ID
";
DynamicParameters dp = new DynamicParameters();
query = Where(query, "tkeywords", ref dp, keywordEntity);
query += orderby;
var list = this.GetPage <T_EC_KeyWords>(pageNumber, pageSize, out number, query, dp).ToList();
return(list);
}
public string Where(string sSql, string primaryTableName, ref DynamicParameters p, T_EC_KeyWords keywordEntity)
{
StringBuilder sb = new StringBuilder();
if (string.IsNullOrEmpty(sSql) || keywordEntity == null)
{
sb.ToString();
}
//主表名
string stn = string.Empty;
if (!string.IsNullOrEmpty(primaryTableName))
{
stn = primaryTableName + ".";
}
sb.Append(sSql + " where 1=1 ");
//ID
if (!string.IsNullOrEmpty(keywordEntity.ID) && !string.IsNullOrEmpty(keywordEntity.ID.Trim()))
{
sb.Append(" and " + stn + "ID = @ID");
p.Add("ID", keywordEntity.ID);
}
//PLAT_TYPE
if (!string.IsNullOrEmpty(keywordEntity.PLAT_TYPE) && !string.IsNullOrEmpty(keywordEntity.PLAT_TYPE.Trim()))
{
sb.Append(" and " + stn + "PLAT_TYPE = @PLAT_TYPE");
p.Add("PLAT_TYPE", keywordEntity.PLAT_TYPE);
}
//KEYWORD_TYPE
if (!string.IsNullOrEmpty(keywordEntity.KEYWORD_TYPE) && !string.IsNullOrEmpty(keywordEntity.KEYWORD_TYPE.Trim()))
{
sb.Append(" and " + stn + "KEYWORD_TYPE = @KEYWORD_TYPE");
p.Add("KEYWORD_TYPE", keywordEntity.KEYWORD_TYPE);
}
//GOODS_TYPE
if (!string.IsNullOrEmpty(keywordEntity.GOODS_TYPE) && !string.IsNullOrEmpty(keywordEntity.GOODS_TYPE.Trim()))
{
sb.Append(" and " + stn + "GOODS_TYPE = @GOODS_TYPE");
p.Add("GOODS_TYPE", keywordEntity.GOODS_TYPE);
}
//KEY_WORD
if (!string.IsNullOrEmpty(keywordEntity.KEY_WORD) && !string.IsNullOrEmpty(keywordEntity.KEY_WORD.Trim()))
{
sb.Append(" and " + stn + "KEY_WORD like @KEY_WORD");
p.Add("KEY_WORD", "%" + keywordEntity.KEY_WORD + "%");
}
//KW_CN
if (!string.IsNullOrEmpty(keywordEntity.KW_CN) && !string.IsNullOrEmpty(keywordEntity.KW_CN.Trim()))
{
sb.Append(" and " + stn + "KW_CN = @KW_CN");
p.Add("KW_CN", keywordEntity.KW_CN);
}
//KW_DES
if (!string.IsNullOrEmpty(keywordEntity.KW_DES) && !string.IsNullOrEmpty(keywordEntity.KW_DES.Trim()))
{
sb.Append(" and " + stn + "KW_DES = @KW_DES");
p.Add("KW_DES", keywordEntity.KW_DES);
}
//KW_VOLUME
if (keywordEntity.KW_VOLUME != null)
{
sb.Append(" and " + stn + "KW_VOLUME = @KW_VOLUME");
p.Add("KW_VOLUME", keywordEntity.KW_VOLUME);
}
//C_DATA_TIME
if (keywordEntity.C_DATA_TIME != null)
{
sb.Append(" and " + stn + "C_DATA_TIME = @C_DATA_TIME");
p.Add("C_DATA_TIME", keywordEntity.C_DATA_TIME);
}
//C_DATA_UID
if (!string.IsNullOrEmpty(keywordEntity.C_DATA_UID) && !string.IsNullOrEmpty(keywordEntity.C_DATA_UID.Trim()))
{
sb.Append(" and " + stn + "C_DATA_UID = @C_DATA_UID");
p.Add("C_DATA_UID", keywordEntity.C_DATA_UID);
}
//U_DATA_TIME
if (keywordEntity.U_DATA_TIME != null)
{
sb.Append(" and " + stn + "U_DATA_TIME = @U_DATA_TIME");
p.Add("U_DATA_TIME", keywordEntity.U_DATA_TIME);
}
//U_DATA_UID
if (!string.IsNullOrEmpty(keywordEntity.U_DATA_UID) && !string.IsNullOrEmpty(keywordEntity.U_DATA_UID.Trim()))
{
sb.Append(" and " + stn + "U_DATA_UID = @U_DATA_UID");
p.Add("U_DATA_UID", keywordEntity.U_DATA_UID);
}
//RESERVE1
if (!string.IsNullOrEmpty(keywordEntity.RESERVE1) && !string.IsNullOrEmpty(keywordEntity.RESERVE1.Trim()))
{
sb.Append(" and " + stn + "RESERVE1 = @RESERVE1");
p.Add("RESERVE1", keywordEntity.RESERVE1);
}
//RESERVE2
if (!string.IsNullOrEmpty(keywordEntity.RESERVE2) && !string.IsNullOrEmpty(keywordEntity.RESERVE2.Trim()))
{
sb.Append(" and " + stn + "RESERVE2 = @RESERVE2");
p.Add("RESERVE2", keywordEntity.RESERVE2);
}
//RESERVE3
if (!string.IsNullOrEmpty(keywordEntity.RESERVE3) && !string.IsNullOrEmpty(keywordEntity.RESERVE3.Trim()))
{
sb.Append(" and " + stn + "RESERVE3 = @RESERVE3");
p.Add("RESERVE3", keywordEntity.RESERVE3);
}
return(sb.ToString());
}
public JsonResult Edit(T_EC_KeyWords keyword)
{
MsgEntity me = _keywordService.Edit(keyword);
return(Json(me, JsonRequestBehavior.AllowGet));
}
public JsonResult Get(string ID)
{
T_EC_KeyWords keyword = _keywordService.Get(ID);
return(Json(keyword, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="sort"></param>
/// <param name="sortOrder"></param>
/// <param name="viewModel"></param>
/// <returns></returns>
public JsonResult GetKeyWords(int pageNumber, int pageSize, string sort = null, string sortOrder = null, T_EC_KeyWords keywordModel = null)
{
long number = 0;
List <T_EC_KeyWords> keywords = _keywordService.GetKeyWordsPages(pageNumber, pageSize, out number, sort, sortOrder, keywordModel);
return(this.Json(new { total = number, rows = keywords }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据前台传递的参数，对"字典项"数据进行分页，搜索
/// </summary>
/// <param name="pageNumber">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="number">返回的total总数</param>
/// <param name="sort">排序字段</param>
/// <param name="sortOrder">排序标识asc或desc</param>
/// <returns></returns>
public List <T_EC_KeyWords> GetKeyWordsPages(int pageNumber, int pageSize, out long number, string sort = null, string sortOrder = null, T_EC_KeyWords keywordEntity = null)
{
return(dao.GetKeyWordsPages(pageNumber, pageSize, out number, sort, sortOrder, keywordEntity));
}