/// <summary>
/// 新增角色
/// </summary>
/// <param name="group"></param>
/// <returns></returns>
public bool AddGroup(Ajax.Model.Group group)
{
if (string.IsNullOrEmpty(group.ID))
{
group.ID = Guid.NewGuid().ToString("N");
}
return(groupDal.AddGroup(group));
}
/// <summary>
/// ��ɫ��ѯjson
/// </summary>
/// <param name="param"></param>
/// <param name="g"></param>
/// <param name="itemCount"></param>
/// <returns></returns>
public List<dynamic> SearchGroup(EasyUIGridParamModel param, Group g, out int itemCount)
{
StringBuilder strSql = new StringBuilder("select ID,Name from T_group g ");
strSql.Append("where 1=1 ");
Dictionary<string, object> paramLists = new Dictionary<string, object>();
if (!string.IsNullOrEmpty(g.NAME))
{
strSql.Append("and Name like @Name ");
paramLists.Add("Name", string.Format("%{0}%", g.NAME));
}
int pageIndex = Convert.ToInt32(param.page) - 1;
int pageSize = Convert.ToInt32(param.rows);
using (DBHelper db = DBHelper.Create())
{
string sql = strSql.ToString();
itemCount = db.GetCount(sql, paramLists);
return db.GetDynaminObjectList(sql, pageIndex, pageSize, "ID", paramLists);
}
}
/// <summary>
/// �༭��ɫ
/// </summary>
/// <param name="g"></param>
public void ModifyGroup(Group g)
{
using (DBHelper db = DBHelper.Create())
{
db.Update<Group>(g);
}
}
public ActionResult AddGroup(Group g)
{
AjaxResult result = new AjaxResult();
try
{
new GroupRule().AddGroup(g);
result.Success = true;
result.Message = "添加成功";
}
catch
{
result.Success = false;
result.Message = "添加失败";
}
return Json(result, JsonRequestBehavior.AllowGet);
}
public ActionResult SearchGroup(EasyUIGridParamModel param, Group group)
{
int itemCount = 0;
List<dynamic> groupList = new GroupRule().SearchGroup(param, group, out itemCount);
var showList = from groups in groupList
select new
{
ID = groups.ID,
NAME = groups.NAME
};
return Json(new { total = itemCount, rows = showList }, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// ��ɫ��ѯjson
/// </summary>
/// <param name="param"></param>
/// <param name="g"></param>
/// <returns></returns>
public List<dynamic> SearchGroup(EasyUIGridParamModel param, Group g,out int itemCount)
{
return groupDal.SearchGroup(param, g,out itemCount);
}
/// <summary>
/// �༭��ɫ
/// </summary>
/// <param name="g"></param>
public void ModifyGroup(Group g)
{
groupDal.ModifyGroup(g);
}
