/// <summary>
/// 验证数据字典分类属性--标题和编码不可重复
/// </summary>
/// <returns></returns>
public static string DPValDicCategoryAttribute(SYS_DicCategory Model)
{
try
{
using (NERPEntities context = new NERPEntities())
{
string flag = string.Empty;
IQueryable <SYS_DicCategory> _name = context.SYS_DicCategory;
_name = _name.Where(c => c.Title == Model.Title || c.Code == Model.Code);
if (Model.DicCategory_Code != "0")
{
_name = _name.Where(c => c.DicCategory_Code != Model.DicCategory_Code);
}
if (_name.Count() > 0)
{
flag = "0";
}
return(flag);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <summary>
/// 验证菜单属性
/// </summary>
/// <returns></returns>
public static string DPValMenuAttribute(SYS_FunctionTree Btn)
{
try
{
using (NERPEntities context = new NERPEntities())
{
string flag = string.Empty;
IQueryable <SYS_FunctionTree> _valbBtn = context.SYS_FunctionTree;
if (Btn.FT_Id != 0)
{
_valbBtn = _valbBtn.Where(c => c.FT_Id != Btn.FT_Id);
}
var _valName = _valbBtn.Where(c => c.FT_Name == Btn.FT_Name);
if (_valName.Count() > 0)
{
flag = "0";
}
return(flag);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <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);
}
}
/// <summary>
/// 获取按钮组
/// </summary>
/// <returns></returns>
public static List <dynamic> DPGetButtonGroup(string BG_Name, string BG_Name_En, int pageSize, int pageIndex, out int allRows, out int allPages)
{
using (NERPEntities contex = new NERPEntities())
{
int skipCount = ((pageIndex - 1) * pageSize);
IQueryable <SYS_ButtonGroup> query = contex.SYS_ButtonGroup;
if (!string.IsNullOrEmpty(BG_Name))
{
query = query.Where(c => c.BG_Name == BG_Name);
}
if (!string.IsNullOrEmpty(BG_Name_En))
{
query = query.Where(c => c.BG_Name_En == BG_Name_En);
}
//表中有无法转换的字段，所以用动态类型进行转换
List <dynamic> list = 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 }).ToList <dynamic>();
//List<SYS_ButtonGroup> list = query.OrderByDescending(c => c.BG_CreatedOn).ToList();
//foreach (var item in list)
//{
// item.BG_RowVersion = null;
//}
allRows = list.Count();
allPages = allRows / pageSize + allRows % pageSize == 0 ? 0 : 1;
return(pageIndex == 0 ? list : list.Skip(skipCount).Take(pageSize).ToList());
}
}
public string Allocate(JObject json)
{
try
{
int AR_AccountId = Convert.ToInt32(json["ACC_ID"].ToString());
using (NERPEntities context = new NERPEntities())
{
//删除已有的数据集合
List <SYS_AccountRole> tempList = context.SYS_AccountRole.Where(c => c.AR_AccountId == AR_AccountId).ToList();
context.SYS_AccountRole.RemoveRange(tempList);
context.SaveChanges();
//循环添加
for (int i = 0; i < json["RoleValueArray"].Count(); i++)
{
string tempRoleName = json["RoleValueArray"][i].ToString();
SYS_AccountRole _role = new SYS_AccountRole();
_role.AR_AccountId = AR_AccountId;
int AR_SystemRoleId = context.SYS_SystemRole.Where(c => c.ROLE_Name == tempRoleName).FirstOrDefault().ROLE_Id;
_role.AR_SystemRoleId = AR_SystemRoleId;
DPBase.Add(_role);
}
return("保存成功！");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
public string GetComboxJson()
{
using (NERPEntities db = new NERPEntities())
{
var d = db.SYS_Button.OrderBy(c => c.BTN_OrderIndex).Select(c => new { name = c.BTN_Name, code = c.BTN_Id }).ToList();
return(JsonConvert.SerializeObject(d));
}
}
public string GetCategoryJson()
{
using (NERPEntities db = new NERPEntities())
{
var d = db.SYS_DicCategory.OrderBy(c => c.Sortnum).ToList();
return(JsonConvert.SerializeObject(d));
}
}
/// <summary>
/// 获取所有手机端菜单-调用存储过程sp_AuthorityWap实现-20150402
/// </summary>
/// <param name="staffId">工号</param>
/// <returns></returns>
public static IList <Menu> GetFunctionMenuWap(string staffId)
{
using (NERPEntities context = new NERPEntities())
{
var query = context.sp_AuthorityWap(staffId).ToList();
var menus = GetChildMenu(query, 0);
return(menus);
}
}
/// <summary>
/// 实体查询
/// </summary>
public List <dynamic> getList(System.Linq.Expressions.Expression <Func <T, bool> > where)
{
using (NERPEntities contex = new NERPEntities())
{
var aa = new { BG_Name = "123", BG_Name_En = "456", BG_OrderIndex = "678", BG_Desc = "789" };
List <dynamic> list = contex.Set <T>().Where(where).Select(c => aa).ToList <dynamic>();
return(list);
}
}
public SYS_DicCategory CategoryGet(JObject json)
{
var model = JsonToObject <SYS_DicCategory>(json);
using (NERPEntities db = new NERPEntities())
{
var d = db.SYS_DicCategory.Where(c => c.DicCategory_Code == model.DicCategory_Code).ToList().FirstOrDefault();
return(d);
}
}
public string CategoryUpdate(JObject json)
{
var model = JsonToObject <SYS_DicCategory>(json);
using (NERPEntities db = new NERPEntities())
{
db.SYS_DicCategory.Attach(model);
db.Entry(model).State = EntityState.Modified;
return((db.SaveChanges() > 0) ? "修改成功！" : "修改失败");
}
}
public string CategoryAdd(JObject json)
{
var model = JsonToObject <SYS_DicCategory>(json);
using (NERPEntities db = new NERPEntities())
{
var d = db.SYS_DicCategory.Select(c => c.DicCategory_Code).ToList().LastOrDefault(); //查询id最大值
model.DicCategory_Code = (int.Parse(d) + 1).ToString(); //新的id为最大值id++
db.SYS_DicCategory.Add(model);
return((db.SaveChanges() > 0) ? "新增成功！" : "新增失败");
}
}
public int Update(JObject json)
{
var model = JsonToObject <SYS_FunctionItem>(json);
model.FI_CreatedOn = DateTime.Now;
using (NERPEntities db = new NERPEntities())
{
db.SYS_FunctionItem.Attach(model);
db.Entry(model).State = EntityState.Modified;
return((db.SaveChanges() > 0) ? 1 : -2); //成功1，失败-2
}
}
public string Delete(JObject json)
{
var model = JsonToObject <SYS_Dics>(json);
using (NERPEntities db = new NERPEntities())
{
var d = db.SYS_Dics.Where(c => c.Dics_Code == model.Dics_Code).FirstOrDefault();
db.SYS_Dics.Remove(d);
return((db.SaveChanges() > 0) ? "删除成功！" : "删除失败");
}
}
/// <summary>
/// 更改密码
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
public static int ChangePassWord(string userName, string password)
{
var newPassWord = StringHelper.CreateMD5(password);//md5加密
using (NERPEntities context = new NERPEntities())
{
var result = context.SYS_Account.First(c => c.ACC_Account == userName);
result.ACC_Password = newPassWord;
var d = context.SaveChanges();
return(d);
}
}
public string GetButtonJson(JObject json)
{
var model = JsonToObject <vw_FunctionItem>(json);
using (NERPEntities db = new NERPEntities())
{
var d = db.vw_FunctionItem.OrderBy(c => c.FI_Id).
OrderBy(c => c.FI_ButtonGroupOrderIndex).
Where(c => c.FI_TreeId == model.FI_TreeId && c.FI_ButtonGroupId == model.FI_ButtonGroupId).
Select(c => new { name = c.BTN_Name, code = c.FI_ButtonId, OrderIndex = c.FI_ButtonOrderIndex, TreeId = c.FI_TreeId, FI_Id = c.FI_Id }).ToList();
return(JsonConvert.SerializeObject(d));
}
}
public static void SaveAlltheRights()
{
try
{
using (NERPEntities context = new NERPEntities())
{
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转化的过程中发生了错误!");
}
}
public int Delete(JObject json)
{
var model = JsonToObject <SYS_FunctionItem>(json);
using (NERPEntities db = new NERPEntities())
{
db.Configuration.ValidateOnSaveEnabled = false;
var d = db.SYS_FunctionItem.Where(c => c.FI_TreeId == model.FI_TreeId && c.FI_ButtonGroupId == model.FI_ButtonGroupId && c.FI_ButtonId == model.FI_ButtonId).FirstOrDefault();
db.SYS_FunctionItem.Remove(d);
return((db.SaveChanges() > 0) ? 1 : -2); //成功1，失败-2
}
}
public string Add(JObject json)
{
SetDefaultValue(json);
var model = JsonToObject <SYS_FunctionTree>(json);
//model.FT_IsSuspended = false; //默认为false
model.FT_CreatedBy = UserSession.username; //当前用户
model.FT_CreatedOn = DateTime.Now;
using (NERPEntities db = new NERPEntities())
{
db.SYS_FunctionTree.Add(model);
return((db.SaveChanges() > 0)? "新增成功！" : "新增失败");
}
}
public string GetJson(JObject json)
{
var model = JsonToObject <vw_FunctionItem>(json);
using (NERPEntities db = new NERPEntities())
{
var d = db.vw_FunctionItem.
OrderBy(c => c.FI_ButtonGroupOrderIndex).
Where(c => c.FI_TreeId == model.FI_TreeId).
Select(c => new { name = c.BG_Name, code = c.FI_ButtonGroupId, OrderIndex = c.FI_ButtonGroupOrderIndex, TreeId = c.FI_TreeId, FI_Id = c.FI_Id }).
DistinctBy(p => new { p.code }); //过滤重复字段
return(JsonConvert.SerializeObject(d));
}
}
public string ValACCAttribute(JObject json)
{
SYS_Account model = JsonToObject <SYS_Account>(json);
using (NERPEntities context = new NERPEntities())
{
IQueryable <SYS_Account> _Account = context.SYS_Account.Where(c => c.ACC_Account == model.ACC_Account);
if (_Account.Count() > 0)
{
return("1");
}
return("0");
}
}
/// <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>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
public static List <SYS_Account> Login(string userName, string password)
{
try
{
var newPassWord = StringHelper.CreateMD5(password);//md5加密
using (NERPEntities context = new NERPEntities())
{
var result = context.SYS_Account.Where(c => c.ACC_Account == userName && c.ACC_Password == newPassWord).ToList();
return(result);
}
}
catch (Exception ex)
{
return(null);
}
}
public Array GetRoleChecked(string accout)
{
try
{
using (NERPEntities context = new NERPEntities())
{
// var _list = context.vw_AccountRole.Where(c => c.staffid == accout).Select(o => new { ROLE_Name = o.ROLE_Name }).ToArray();
var _list = context.vw_AccountRole.Where(c => c.staffid == accout).Select(o => o.ROLE_Name).ToArray();
//return JsonConvert.SerializeObject(_list);
return(_list);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
public string CategoryDelete(JObject json)
{
var model = JsonToObject <SYS_DicCategory>(json);
using (NERPEntities db = new NERPEntities())
{
var count = db.SYS_Dics.Count(c => c.CategoryId.ToString() == model.DicCategory_Code);
if (count > 0)
{
return("删除失败，因为该分类下有数据字典，请先删除数据字典！");
}
var d = db.SYS_DicCategory.Where(c => c.DicCategory_Code == model.DicCategory_Code).FirstOrDefault();
db.SYS_DicCategory.Remove(d);
return((db.SaveChanges() > 0) ? "删除成功！" : "删除失败");
}
}
/// <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 + "转换的过程中发生了错误！");
}
}
public string ValRolAttribute(JObject json)
{
if (string.IsNullOrEmpty(json["ROLE_Level"].ToString()) || string.IsNullOrEmpty(json["ROLE_OrderIndex"].ToString()))
{
json["ROLE_Level"] = 0;
json["ROLE_OrderIndex"] = 0;
}
SYS_SystemRole model = JsonToObject <SYS_SystemRole>(json);
using (NERPEntities context = new NERPEntities())
{
IQueryable <SYS_SystemRole> _role = context.SYS_SystemRole.Where(c => c.ROLE_Name == model.ROLE_Name);
if (_role.Count() > 0)
{
return("1");
}
return("0");
}
}
/// <summary>
/// 验证按钮属性
/// </summary>
/// <returns></returns>
public static string DPValBtnAttribute(SYS_Button Btn)
{
try
{
using (NERPEntities context = new NERPEntities())
{
string flag = string.Empty;
IQueryable <SYS_Button> _valbBtn = context.SYS_Button;
if (Btn.BTN_Id != 0)
{
_valbBtn = _valbBtn.Where(c => c.BTN_Id != Btn.BTN_Id);
}
var _valName = _valbBtn.Where(c => c.BTN_Name == Btn.BTN_Name);
if (_valName.Count() != 0)
{
flag = "0";
}
else
{
var _valName_En = _valbBtn.Where(c => c.BTN_Name_En == Btn.BTN_Name_En);
if (_valName_En.Count() != 0)
{
flag = "1";
}
else
{
var _valMark = _valbBtn.Where(c => c.BTN_Mark == Btn.BTN_Mark);
if (_valMark.Count() != 0)
{
flag = "3";
}
//}
}
}
return(flag);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "转换的过程中发生了错误！");
}
}
/// <summary>
/// 通用查询
/// </summary>
/// <param name="BtnG"></param>
/// <param name="rp"></param>
/// <param name="page"></param>
/// <param name="allRows"></param>
/// <param name="allPages"></param>
/// <returns></returns>
public static List <dynamic> DPGetQueryLst <T>(SearchMod <T> aa)
{
using (NERPEntities contex = new NERPEntities())
{
int skipCount = ((aa.page - 1) * aa.rp);
string afg = typeof(T).ToString();
IQueryable <T> query = null;
ParameterExpression left = Expression.Parameter(typeof(T), "c"); //c=>
ConstantExpression _constExp = Expression.Constant("aaa", typeof(string)); //一个常量
MethodCallExpression _methodCallexp = Expression.Call(typeof(Console).GetMethod("WriteLine", new Type[] { typeof(string) }), _constExp);
Expression <Action> consoleLambdaExp = Expression.Lambda <Action>(_methodCallexp);
//表中有无法转换的字段，所以用动态类型进行转换
List <dynamic> list = query.Select(c => new { BG_Name = "123", BG_Name_En = "456", BG_OrderIndex = "678", BG_Desc = "789" }).ToList <dynamic>();
aa.total = list.Count();
aa.total = aa.total / aa.rp + aa.total % aa.rp == 0 ? 0 : 1;
return(aa.page == 0 ? list : list.Skip(skipCount).Take(aa.rp).ToList());
}
}