/// <summary> /// 创建一个人员 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据库上下文</param> /// <param name="entity">一个人员</param> /// <returns></returns> public bool Create(ref ValidationErrors validationErrors, SysEntities db, SysPerson entity) { int count = 1; foreach (string item in entity.SysRoleId.GetIdSort()) { SysRole sys = new SysRole { Id = item }; db.SysRole.Attach(sys); entity.SysRole.Add(sys); count++; } foreach (string item in entity.SysDocumentId.GetIdSort()) { SysDocument sys = new SysDocument { Id = item }; db.SysDocument.Attach(sys); entity.SysDocument.Add(sys); count++; } repository.Create(db, entity); if (count == repository.Save(db)) { return true; } else { validationErrors.Add("创建出错了"); } return false; }
/// <summary> /// 创建一个菜单 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据库上下文</param> /// <param name="entity">一个菜单</param> /// <returns></returns> public bool Create(ref ValidationErrors validationErrors, SysEntities db, SysMenu entity) { int count = 1; foreach (string item in entity.SysOperationId.GetIdSort()) { SysOperation sys = new SysOperation { Id = item }; db.SysOperation.Attach(sys); entity.SysOperation.Add(sys); count++; } repository.Create(db, entity); if (count == repository.Save(db)) { //创建后重置菜单编码 List<int> flags = new List<int>();//层级 GetMenus2(null, flags); db.SaveChanges(); return true; } else { validationErrors.Add("创建出错了"); } return false; }
public SysAnnouncement GetTop(int num) { using (SysEntities db = new SysEntities()) { return db.SysAnnouncement.Where(w=>w.State=="开启").OrderBy(o => o.CreateTime).Take(num).SingleOrDefault(); } }
/// <summary> /// 验证用户名和密码是否正确 /// </summary> /// <param name="userName">用户名</param> /// <param name="password">密码</param> /// <returns>登录成功后的用户信息</returns> public SysPerson ValidateUser(string userName, string password) { if (String.IsNullOrWhiteSpace(userName) || String.IsNullOrWhiteSpace(password)) return null; //获取用户信息,请确定web.config中的连接字符串正确 using (SysEntities db = new SysEntities()) { var person = (from p in db.SysPerson where p.Name == userName && p.Password == password && p.State == "开启" select p).FirstOrDefault(); if (person != null) {//登录成功 person.LastLogonTime = person.LogonTime; person.LastLogonIP = person.LogonIP; person.LogonNum++; person.LogonTime = DateTime.Now; person.LogonIP = Common.IP.GetIP(); db.SaveChanges(); return person; } } return null; }
/// <summary> /// 修改密码 /// </summary> /// <param name="personName">用户名</param> /// <param name="oldPassword">旧密码</param> /// <param name="newPassword">新密码</param> /// <returns>修改密码是否成功</returns> public bool ChangePassword(string personName, string oldPassword, string newPassword) { if (!string.IsNullOrWhiteSpace(personName) && !string.IsNullOrWhiteSpace(oldPassword) && !string.IsNullOrWhiteSpace(newPassword)) { try { string oldPasswordEncryptString = EncryptAndDecrypte.EncryptString(oldPassword); string newPasswordEncryptString = EncryptAndDecrypte.EncryptString(newPassword); using (SysEntities db = new SysEntities()) { var person = db.SysPerson.FirstOrDefault(p => (p.Name == personName) && (p.Password == oldPasswordEncryptString)); person.Password = newPasswordEncryptString; person.SurePassword = newPasswordEncryptString; if (!string.IsNullOrWhiteSpace(person.EmailAddress)) { NetSendMail.MailSendChangePassword(db, person.EmailAddress, personName, newPassword); //发送通知的邮件 } db.SaveChanges(); return true; } } catch (Exception ex) { ExceptionsHander.WriteExceptions(ex); } } return false; }
/// <summary> /// 根据SysMenuId,获取所有角色菜单操作数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable<SysOperation> GetByRefSysMenuIdAndSysRoleId(SysEntities db, string id, List<string> sysRoleIds) { //兼容oracle return ( from o in db.SysOperation from m in db.SysMenuSysRoleSysOperation.Where(c => sysRoleIds.Any(a => a == c.SysRoleId) && c.SysMenuId == id && c.SysOperationId != null).Select(s => s.SysOperationId) where o.Id == m select o).Distinct().OrderBy(o=>o.Sort).AsQueryable() ; }
public static void MailSendChangePassword(SysEntities db, string mailTo, string name, string psw) { string tempName = "修改密码发送的邮件通知"; var data = db.SysEmailTemp.Where(w => w.Mail_name == tempName).FirstOrDefault(); if (data != null) { SysEmail email = new SysEmail(); email.CreateTime = DateTime.Now; email.Id = Common.Result.GetNewId(); email.SysMailId = data.Id; email.Subject = data.Subject.Replace("{{用户名}}", name).Replace("{{密码}}", psw); email.Content = data.Content.Replace("{{用户名}}", name).Replace("{{密码}}", psw); email.Mail_type = mailTo; email.Reply_email = data.Reply_email; db.SysEmail.Add(email); string mailFromPwd = "langben123", mailSmtpServer = "smtp.exmail.qq.com"; SendSMTPEMail(mailSmtpServer, 25, email.Reply_email, "服务", "*****@*****.**", mailFromPwd, mailTo, email.Subject, email.Content); } }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public CompanyBLL(SysEntities entities) { db = entities; }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public FileUploaderBLL(SysEntities entities) { db = entities; }
/// <summary> /// 通过主键id,获取变送器频率相位---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>变送器频率相位</returns> public TRANSMITTER_FREQUENCY_PHASE GetById(SysEntities db, string id) { return(db.TRANSMITTER_FREQUENCY_PHASE.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public GenZongBLL(SysEntities entities) { db = entities; }
/// <summary> /// 编辑一个人员 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个人员</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysPerson entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return false; } int count = 1; List<string> addSysRoleId = new List<string>(); List<string> deleteSysRoleId = new List<string>(); DataOfDiffrent.GetDiffrent(entity.SysRoleId.GetIdSort(), entity.SysRoleIdOld.GetIdSort(), ref addSysRoleId, ref deleteSysRoleId); List<SysRole> listEntitySysRole = new List<SysRole>(); if (deleteSysRoleId != null && deleteSysRoleId.Count() > 0) { foreach (var item in deleteSysRoleId) { SysRole sys = new SysRole { Id = item }; listEntitySysRole.Add(sys); entity.SysRole.Add(sys); } } List<string> addSysDocumentId = new List<string>(); List<string> deleteSysDocumentId = new List<string>(); DataOfDiffrent.GetDiffrent(entity.SysDocumentId.GetIdSort(), entity.SysDocumentIdOld.GetIdSort(), ref addSysDocumentId, ref deleteSysDocumentId); List<SysDocument> listEntitySysDocument = new List<SysDocument>(); if (deleteSysDocumentId != null && deleteSysDocumentId.Count() > 0) { foreach (var item in deleteSysDocumentId) { SysDocument sys = new SysDocument { Id = item }; listEntitySysDocument.Add(sys); entity.SysDocument.Add(sys); } } SysPerson editEntity = repository.Edit(db, entity); if (addSysRoleId != null && addSysRoleId.Count() > 0) { foreach (var item in addSysRoleId) { SysRole sys = new SysRole { Id = item }; db.SysRole.Attach(sys); editEntity.SysRole.Add(sys); count++; } } if (deleteSysRoleId != null && deleteSysRoleId.Count() > 0) { foreach (SysRole item in listEntitySysRole) { editEntity.SysRole.Remove(item); count++; } } if (addSysDocumentId != null && addSysDocumentId.Count() > 0) { foreach (var item in addSysDocumentId) { SysDocument sys = new SysDocument { Id = item }; db.SysDocument.Attach(sys); editEntity.SysDocument.Add(sys); count++; } } if (deleteSysDocumentId != null && deleteSysDocumentId.Count() > 0) { foreach (SysDocument item in listEntitySysDocument) { editEntity.SysDocument.Remove(item); count++; } } if (count == repository.Save(db)) { return true; } else { validationErrors.Add("编辑人员出错了"); } return false; }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public SysEmailBLL() { db = new SysEntities(); }
/// <summary> /// 根据PREPARE_SCHEMEID,获取所有标准器选择数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <STANDARDCHOICE> GetByRefPREPARE_SCHEMEID(SysEntities db, string id) { return(from c in db.STANDARDCHOICE where c.PREPARE_SCHEMEID == id select c); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public SysMessageBLL() { db = new SysEntities(); }
/// <summary> /// 根据UNDERTAKE_LABORATORYID,获取所有方案数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <SCHEME> GetByRefUNDERTAKE_LABORATORYID(SysEntities db, string id) { return(from c in db.SCHEME where c.UNDERTAKE_LABORATORYID == id select c); }
/// <summary> /// 通过主键id,获取标准器选择---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>标准器选择</returns> public STANDARDCHOICE GetById(SysEntities db, string id) { return(db.STANDARDCHOICE.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 通过主键id,获取方案---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>方案</returns> public SCHEME GetById(SysEntities db, string id) { return(db.SCHEME.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 查询的数据 /// </summary> /// <param name="SysEntities">数据访问的上下文</param> /// <param name="order">升序asc(默认)还是降序desc</param> /// <param name="sort">排序字段</param> /// <param name="search">查询条件</param> /// <param name="listQuery">额外的参数</param> /// <returns></returns> public IQueryable <VRUKU> GetDataX(SysEntities db, string order, string sort, string search, params object[] listQuery) { string where = string.Empty; int flagWhere = 0; string EQUIPMENT_STATUS_VALUUMN = string.Empty; string REPORTSTATUSZI = string.Empty; DateTime?startTime = null; DateTime?endTime = null; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (!string.IsNullOrEmpty(item.Key) && !string.IsNullOrEmpty(item.Value) && item.Key == "EQUIPMENT_STATUS_VALUUMN") { EQUIPMENT_STATUS_VALUUMN = item.Value; continue; } if (!string.IsNullOrEmpty(item.Key) && !string.IsNullOrEmpty(item.Value) && item.Key == "REPORTSTATUSZI") { REPORTSTATUSZI = item.Value; continue; } //oracle数据库使用linq对时间段查询 if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Time)) //开始时间 { startTime = Convert.ToDateTime(item.Value); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Time)) //结束时间+1 { endTime = Convert.ToDateTime(item.Value).AddDays(1); continue; } if (flagWhere != 0) { where += " and "; } flagWhere++; if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Int)) //开始数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(Start_Int)) + "] >= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Int)) //结束数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(End_Int)) + "] <= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_Int)) //精确查询数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_Int)) + "] =" + item.Value; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_String)) //精确查询字符串 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_String)) + "] = '" + item.Value + "'"; continue; } where += "it.[" + item.Key + "] like '%" + item.Value + "%'";//模糊查询 } } string[] EQUIPMENT_STATUS_VALUUMNarr = null; if (!string.IsNullOrEmpty(EQUIPMENT_STATUS_VALUUMN)) { EQUIPMENT_STATUS_VALUUMNarr = EQUIPMENT_STATUS_VALUUMN.Split('*'); } string[] REPORTSTATUSZIarr = null; if (!string.IsNullOrEmpty(REPORTSTATUSZI)) { REPORTSTATUSZIarr = REPORTSTATUSZI.Split('*'); } if (REPORTSTATUSZIarr == null) { var data = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext .CreateObjectSet <VRUKU>().Where(string.IsNullOrEmpty(where) ? "true" : where) .OrderBy("it.[" + sort.GetString() + "] " + order.GetString()) //.OrderBy("it.[UPDATETIME] " + "desc") .Where(w => EQUIPMENT_STATUS_VALUUMNarr.Contains(w.EQUIPMENT_STATUS_VALUUMN)) .AsQueryable(); if (null != startTime) { data = data.Where(m => startTime <= m.APPROVALDATE); } if (null != endTime) { data = data.Where(m => endTime >= m.APPROVALDATE); } return(data); } else { var data = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext .CreateObjectSet <VRUKU>().Where(string.IsNullOrEmpty(where) ? "true" : where) .OrderBy("it.[" + sort.GetString() + "] " + order.GetString()) //.OrderBy("it.[UPDATETIME] " + "desc") .Where(w => EQUIPMENT_STATUS_VALUUMNarr.Contains(w.EQUIPMENT_STATUS_VALUUMN) || REPORTSTATUSZIarr.Contains(w.REPORTSTATUSZI)) .AsQueryable(); if (null != startTime) { data = data.Where(m => startTime <= m.APPROVALDATE); } if (null != endTime) { data = data.Where(m => endTime >= m.APPROVALDATE); } return(data); } }
/// <summary> /// 根据TRANSMITTER_HEADID,获取所有变送器频率相位数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <TRANSMITTER_FREQUENCY_PHASE> GetByRefTRANSMITTER_HEADID(SysEntities db, string id) { return(from c in db.TRANSMITTER_FREQUENCY_PHASE where c.TRANSMITTER_HEADID == id select c); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public SysFieldBLL() { db = new SysEntities(); }
/// <summary> /// 通过主键id,获取客户_企业信息---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>客户_企业信息</returns> public CRM_Company GetById(SysEntities db, int id) { return(db.CRM_Company.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public DepartmentBLL() { db = new SysEntities(); }
/// <summary> /// 通过主键id,获取公告管理---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>公告管理</returns> public SysAnnouncement GetById(SysEntities db, string id) { return(db.SysAnnouncement.SingleOrDefault(s => s.Id == id)); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public ShenQingBLL() { db = new SysEntities(); }
/// <summary> /// 通过主键id,获取客服社保种类---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>客服社保种类</returns> public ORG_UserInsuranceKind GetById(SysEntities db, int id) { return(db.ORG_UserInsuranceKind.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public SysPersonBLL(SysEntities entities) { db = entities; }
/// <summary> /// 根据InsuranceKindId,获取所有客服社保种类数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <ORG_UserInsuranceKind> GetByRefInsuranceKindId(SysEntities db, int id) { return(from c in db.ORG_UserInsuranceKind where c.InsuranceKindId == id select c); }
/// <summary> /// 通过主键id,获取附件---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>附件</returns> public FileUploader GetById(SysEntities db, string id) { return(db.FileUploader.SingleOrDefault(s => s.Id == id)); }
/// <summary> /// 通过主键id,获取客户_企业银行账户_待审核---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>客户_企业银行账户_待审核</returns> public CRM_CompanyBankAccount_Audit GetById(SysEntities db, int id) { return(db.CRM_CompanyBankAccount_Audit.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public GenZongBLL() { db = new SysEntities(); }
/// <summary> /// 通过主键id,获取菜单---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>菜单</returns> public SysMenu GetById(SysEntities db, string id) { return(db.SysMenu.SingleOrDefault(s => s.Id == id)); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public CompanyBLL() { db = new SysEntities(); }
/// <summary> /// 查询的数据 /// </summary> /// <param name="SysEntities">数据访问的上下文</param> /// <param name="order">排序字段</param> /// <param name="sort">升序asc(默认)还是降序desc</param> /// <param name="search">查询条件</param> /// <param name="listQuery">额外的参数</param> /// <returns></returns> public IQueryable <SysMenu> DaoChuData(SysEntities db, string order, string sort, string search, params object[] listQuery) { string where = string.Empty; int flagWhere = 0; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (flagWhere != 0) { where += " and "; } flagWhere++; if (queryDic.ContainsKey("SysOperation") && !string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key == "SysOperation") {//查询多对多关系的列名 where += "EXISTS(select p from it.SysOperation as p where p.Id='" + item.Value + "')"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Time)) //需要查询的列名 { where += "it. " + item.Key.Remove(item.Key.IndexOf(Start_Time)) + " >= CAST('" + item.Value + "' as System.DateTime)"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Time)) //需要查询的列名 { where += "it." + item.Key.Remove(item.Key.IndexOf(End_Time)) + " < CAST('" + Convert.ToDateTime(item.Value).AddDays(1) + "' as System.DateTime)"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Int)) //需要查询的列名 { where += "it." + item.Key.Remove(item.Key.IndexOf(Start_Int)) + " >= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Int)) //需要查询的列名 { where += "it." + item.Key.Remove(item.Key.IndexOf(End_Int)) + " <= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_String)) //需要查询的列名 { where += "it." + item.Key.Remove(item.Key.IndexOf(End_String)) + " = '" + item.Value + "'"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_String)) //需要查询的列名 { where += "it." + item.Key.Remove(item.Key.IndexOf(DDL_String)) + " = '" + item.Value + "'"; continue; } where += "it." + item.Key + " like '%" + item.Value + "%'"; } } return(db.SysMenu .Where(string.IsNullOrEmpty(where) ? "true" : where) .OrderBy("it." + sort.GetString() + " " + order.GetString()) .AsQueryable()); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public FileUploaderBLL() { db = new SysEntities(); }
/// <summary> /// 通过主键id,获取直流电压输出---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>直流电压输出</returns> public DC_VOLTAGE_OUTPUT GetById(SysEntities db, string id) { return(db.DC_VOLTAGE_OUTPUT.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 根据ResumeId,获取所有实习经验数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <InternshipExperience> GetByRefResumeId(SysEntities db, string id) { return(from c in db.InternshipExperience where c.ResumeId == id select c); }
/// <summary> /// 根据OVERALL_TABLEID,获取所有直流电压输出数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <DC_VOLTAGE_OUTPUT> GetByRefOVERALL_TABLEID(SysEntities db, string id) { return(from c in db.DC_VOLTAGE_OUTPUT where c.OVERALL_TABLEID == id select c); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public SysFieldBLL(SysEntities entities) { db = entities; }
/// <summary> /// 通过主键id,获取费用_社保支出医疗大额---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>费用_社保支出医疗大额</returns> public COST_PayYiLiaoDaE GetById(SysEntities db, int id) { return(db.COST_PayYiLiaoDaE.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public DepartmentBLL(SysEntities entities) { db = entities; }
/// <summary> /// 通过主键id,获取不确定度参数管理---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>不确定度参数管理</returns> public UNCERTAINTYPARAMETERMANAGEMENT GetById(SysEntities db, string id) { return(db.UNCERTAINTYPARAMETERMANAGEMENT.SingleOrDefault(s => s.ID == id)); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public SysMessageBLL(SysEntities entities) { db = entities; }
/// <summary> /// 根据RULEID,获取所有不确定度参数管理数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <UNCERTAINTYPARAMETERMANAGEMENT> GetByRefRULEID(SysEntities db, string id) { return(from c in db.UNCERTAINTYPARAMETERMANAGEMENT where c.RULEID == id select c); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public ShenQingBLL(SysEntities entities) { db = entities; }
/// <summary> /// 通过主键id,获取员工补缴---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>员工补缴</returns> public EmployeeGoonPayment GetById(SysEntities db, int id) { return(db.EmployeeGoonPayment.SingleOrDefault(s => s.Id == id)); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public SysPersonBLL() { db = new SysEntities(); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public ChuLiBLL(SysEntities entities) { db = entities; }
/// <summary> /// 通过主键id,获取实习经验---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>实习经验</returns> public InternshipExperience GetById(SysEntities db, string id) { return(db.InternshipExperience.SingleOrDefault(s => s.Id == id)); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public SysDocumentTalkBLL() { db = new SysEntities(); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public SysEmailBLL(SysEntities entities) { db = entities; }
/// <summary> /// 查询的数据 /// </summary> /// <param name="SysEntities">数据访问的上下文</param> /// <param name="order">排序字段</param> /// <param name="sort">升序asc(默认)还是降序desc</param> /// <param name="search">查询条件</param> /// <param name="listQuery">额外的参数</param> /// <returns></returns> public IQueryable <VBUHEGE> GetData(SysEntities db, string order, string sort, string search, params object[] listQuery) { string where = string.Empty; int flagWhere = 0; DateTime?startTime = null; DateTime?endTime = null; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { //oracle数据库使用linq对时间段查询 if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key == "BAOGAOPIZHUNTONGGUOSHIJIANStart_Time") //开始时间 { startTime = Convert.ToDateTime(item.Value); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key == "BAOGAOPIZHUNTONGGUOSHIJIANEnd_Time") //结束时间+1 { endTime = Convert.ToDateTime(item.Value).AddDays(1); continue; } if (flagWhere != 0) { where += " and "; } flagWhere++; if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Int)) //开始数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(Start_Int)) + "] >= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Int)) //结束数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(End_Int)) + "] <= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_Int)) //精确查询数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_Int)) + "] =" + item.Value; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_String)) //精确查询字符串 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_String)) + "] = '" + item.Value + "'"; continue; } where += "it.[" + item.Key + "] like '%" + item.Value + "%'";//模糊查询 } } var data = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext .CreateObjectSet <VBUHEGE>().Where(string.IsNullOrEmpty(where) ? "true" : where) .OrderBy("it.[" + sort.GetString() + "] " + order.GetString()) .AsQueryable(); if (null != startTime) { data = data.Where(m => startTime <= m.BAOGAOPIZHUNTONGGUOSHIJIAN); } if (null != endTime) { data = data.Where(m => endTime >= m.BAOGAOPIZHUNTONGGUOSHIJIAN); } return(data); }
/// <summary> /// 通过主键id,获取评论---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>评论</returns> public Comment GetById(SysEntities db, string id) { return db.Comment.SingleOrDefault(s => s.Id == id); }
/// <summary> /// 根据EmployeeAddId,获取所有员工补缴数据 /// </summary> /// <param name="id">外键的主键</param> /// <returns></returns> public IQueryable <EmployeeGoonPayment> GetByRefEmployeeAddId(SysEntities db, int id) { return(from c in db.EmployeeGoonPayment where c.EmployeeAddId == id select c); }
/// <summary> /// 构造函数,默认加载数据访问上下文 /// </summary> public ChuLiBLL() { db = new SysEntities(); }
/// <summary> /// 通过主键id,获取操作---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>操作</returns> public SysOperation GetById(SysEntities db, string id) { return(db.SysOperation.SingleOrDefault(s => s.Id == id)); }
/// <summary> /// 获取在该表中出现的所有外键实体 /// </summary> /// <param name="id">主键</param> /// <returns>外键实体集合</returns> public IQueryable <SysMenu> GetRefSysMenu(SysEntities db) { return(from m in db.SysOperation from f in m.SysMenu select f); }
/// <summary> /// 查询的数据 /// </summary> /// <param name="SysEntities">数据访问的上下文</param> /// <param name="order">排序字段</param> /// <param name="sort">升序asc(默认)还是降序desc</param> /// <param name="search">查询条件</param> /// <param name="listQuery">额外的参数</param> /// <returns></returns> public IQueryable <SysOperation> DaoChuData(SysEntities db, string order, string sort, string search, params object[] listQuery) { string where = string.Empty; int flagWhere = 0; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (flagWhere != 0) { where += " and "; } flagWhere++; if (queryDic.ContainsKey("SysMenu") && !string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key == "SysMenu") {//查询多对多关系的列名 where += "EXISTS(select p from it.SysMenu as p where p.Id='" + item.Value + "')"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Time)) //开始时间 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(Start_Time)) + "] >= CAST('" + item.Value + "' as System.DateTime)"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Time)) //结束时间+1 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(End_Time)) + "] < CAST('" + Convert.ToDateTime(item.Value).AddDays(1) + "' as System.DateTime)"; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Int)) //开始数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(Start_Int)) + "] >= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Int)) //结束数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(End_Int)) + "] <= " + item.Value.GetInt(); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_Int)) //精确查询数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_Int)) + "] =" + item.Value; continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_String)) //精确查询字符串 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_String)) + "] = '" + item.Value + "'"; continue; } where += "it.[" + item.Key + "] like '%" + item.Value + "%'";//模糊查询 } } return(((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext .CreateObjectSet <SysOperation>().Where(string.IsNullOrEmpty(where) ? "true" : where) .OrderBy("it.[" + sort.GetString() + "] " + order.GetString()) .AsQueryable()); }
/// <summary> /// 已有数据访问上下文的方法中调用 /// </summary> /// <param name="entities">数据访问上下文</param> public SysDocumentTalkBLL(SysEntities entities) { db = entities; }
/// <summary> /// 通过主键id,获取不合格统计分析---查看详细,首次编辑 /// </summary> /// <param name="id">主键</param> /// <returns>不合格统计分析</returns> public VBUHEGE GetById(SysEntities db, string id) { return(db.VBUHEGE.SingleOrDefault(s => s.ID == id)); }