public Flexigride GetButtonGroup(JObject json)
{
SearchMod <SYS_ButtonGroup> searchModel = new SearchMod <SYS_ButtonGroup>();
searchModel.page = Convert.ToInt32(json["page"].ToString());
searchModel.rp = Convert.ToInt32(json["rp"].ToString());
SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup)));
IQueryable <SYS_ButtonGroup> query = DPBase.db.SYS_ButtonGroup;
query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortname) : query.OrderBy(c => searchModel.sortname);
if (!string.IsNullOrEmpty(bGroup.BG_Name))
{
query = query.Where(c => c.BG_Name.Contains(bGroup.BG_Name));
}
if (!string.IsNullOrEmpty(bGroup.BG_Name_En))
{
query = query.Where(c => c.BG_Name_En.Contains(bGroup.BG_Name_En));
}
//aa.query = query.Select(c => new { BG_Name = c.BG_Name, BG_Name_En = c.BG_Name_En, BG_OrderIndex = c.BG_OrderIndex, BG_Desc = c.BG_Desc,BG_Id = c.BG_Id });
searchModel.query = query.OrderBy(c => c.BG_CreatedOn);
Flexigride grid = new Flexigride();
grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel);
grid.page = searchModel.page;
grid.total = searchModel.total;
return(grid);
}
/// <summary>
/// 通用查询
/// </summary>
/// <param name="BtnG"></param>
/// <param name="rp"></param>
/// <param name="pageIndex"></param>
/// <param name="allRows"></param>
/// <param name="allPages"></param>
/// <returns></returns>
public static List <dynamic> DPGetQueryLst(SearchMod <T> aa, dynamic expression)
{
using (NERPEntities contex = new NERPEntities())
{
int skipCount = ((aa.page - 1) * aa.rp);
var bb = aa.ret; //匿名对象，用于显示输出
//List<dynamic> list = contex.Set<T>().Select(c => aa).ToList<dynamic>();
IQueryable <dynamic> query = aa.query;
var custom = new SYS_ButtonGroup {
BG_Name = "BG_Name", BG_Name_En = "BG_Name_En"
};
//aa.where.Compile()(custom);
//query.Where(aa.where);
//query = aa.query;
// var custom = expression.Compile()(expression);
// var ww = expression.Compile()(custom);
//表中有无法转换的字段，所以用动态类型进行转换
List <dynamic> list = query.ToList <dynamic>();
aa.total = list.Count();
aa.total = aa.total / aa.rp + aa.total % aa.rp == 0 ? 0 : 1;
List <dynamic> ret = aa.page == 0 ? list : list.Skip(skipCount).Take(aa.rp).ToList();
return(ret);
}
}
public string EditButtonGroup(JObject json)
{
SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup)));
DPBase.Update(bGroup);
return("保存成功！");
}
public string AddNewButtonGroup(JObject json)
{
json["BG_OrderIndex"] = 0;
SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup)));
bGroup.BG_CreatedOn = DateTime.Now;
bGroup.BG_IsSuspended = false;
DPBase.Add(bGroup);
return("保存成功！");
}
public string ValBtnAttribute(JObject json)
{
if (string.IsNullOrEmpty(json["BG_OrderIndex"].ToString()))
{
json["BG_OrderIndex"] = 0;
}
SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup)));
return(DPButton.DPValBtnGroupAttribute(bGroup));
}
public JObject GetBtnInformation(JObject json)
{
//SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup)));
int BG_Id = Convert.ToInt32(json["BG_Id"].ToString());
SYS_ButtonGroup _btnGroup = DPBase.Get <SYS_ButtonGroup>(BG_Id);
JObject ret = new JObject();
ret.Add("group", JObject.FromObject(_btnGroup));
return(ret);
}
/// <summary>
/// 验证按钮组属性
/// </summary>
/// <returns></returns>
public static string DPValBtnGroupAttribute(SYS_ButtonGroup bGroup)
{
try
{
using (NERPEntities context = new NERPEntities())
{
string flag = string.Empty;
IQueryable <SYS_ButtonGroup> _valbGroup = context.SYS_ButtonGroup;
if (bGroup.BG_Id != 0)
{
_valbGroup = _valbGroup.Where(c => c.BG_Id != bGroup.BG_Id);
}
IQueryable <SYS_ButtonGroup> _valName = _valbGroup.Where(c => c.BG_Name == bGroup.BG_Name);
if (_valName.Count() != 0)
{
flag = "0";
}
else
{
IQueryable <SYS_ButtonGroup> _valName_En = _valbGroup.Where(c => c.BG_Name_En == bGroup.BG_Name_En);
if (_valName_En.Count() != 0)
{
flag = "1";
}
else
{
//_valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_OrderIndex == bGroup.BG_OrderIndex);
//if (_valbGroup.Count() != 0)
//{
// flag = "2";
//}
//else
//{
IQueryable <SYS_ButtonGroup> _valMark = _valbGroup.Where(c => c.BG_Mark == bGroup.BG_Mark);
if (_valMark.Count() != 0)
{
flag = "3";
}
//}
}
}
return(flag);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <summary>
/// 获取按钮组
/// </summary>
/// <returns></returns>
public static SYS_ButtonGroup DPGetBtnInformation(SYS_ButtonGroup bGroup)
{
try
{
using (NERPEntities context = new NERPEntities())
{
SYS_ButtonGroup btnGroup = context.SYS_ButtonGroup.Where(c => c.BG_Name_En == bGroup.BG_Name_En).FirstOrDefault();
return(btnGroup);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <summary>
/// 保存按钮组
/// </summary>
/// <returns></returns>
public static void DPSaveButtonModel(SYS_ButtonGroup bGroup)
{
try
{
using (NERPEntities context = new NERPEntities())
{
bGroup.BG_IsSuspended = false;
bGroup.BG_CreatedOn = DateTime.Now;
bGroup.BG_CreatedBy = "SYS";
context.SYS_ButtonGroup.Add(bGroup);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <summary>
/// 获取按钮组列表，列表必须在末尾加Lst
/// </summary>
/// <returns></returns>
public static List <dynamic> DPGetButtonGroupLst(SYS_ButtonGroup BtnG, int rp, int page, out int allRows, out int allPages)
{
using (NERPEntities contex = new NERPEntities())
{
int skipCount = ((page - 1) * rp);
IQueryable <SYS_ButtonGroup> query = contex.SYS_ButtonGroup;
if (!string.IsNullOrEmpty(BtnG.BG_Name))
{
query = query.Where(c => c.BG_Name == BtnG.BG_Name);
}
if (!string.IsNullOrEmpty(BtnG.BG_Name_En))
{
query = query.Where(c => c.BG_Name_En == BtnG.BG_Name_En);
}
//表中有无法转换的字段，所以用动态类型进行转换
List <dynamic> list = query.Select(c => c.BG_Name).ToList <dynamic>();
allRows = list.Count();
allPages = allRows / rp + allRows % rp == 0 ? 0 : 1;
return(page == 0 ? list : list.Skip(skipCount).Take(rp).ToList());
}
}
/// <summary>
/// 验证按钮属性
/// </summary>
/// <returns></returns>
public static string DPValBtnAttribute(SYS_ButtonGroup bGroup)
{
try
{
using (NERPEntities context = new NERPEntities())
{
string flag = string.Empty;
IQueryable <SYS_ButtonGroup> _valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_Name == bGroup.BG_Name);
if (_valbGroup.Count() != 0)
{
flag = "按钮组名称重复请从新输入！";
}
else
{
_valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_Name_En == bGroup.BG_Name_En);
if (_valbGroup.Count() != 0)
{
flag = "按钮组编号重复请从新输入！";
}
else
{
_valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_OrderIndex == bGroup.BG_OrderIndex);
if (_valbGroup.Count() != 0)
{
flag = "按钮组序号重复请从新输入！";
}
}
}
return(flag);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
