public List <WithDringCommitteeEntity> GetList(WithDringCommitteeEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_WithDringCommittee");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
var list = tbl_WithDringCommittee.Query(sql.ToString());
return(EntityConvertTools.CopyToList <tbl_WithDringCommittee, WithDringCommitteeEntity>(list.ToList()));
}
public List <AttachmentPicEntity> GetList(AttachmentPicEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_AttachmentPic");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
var list = tbl_AttachmentPic.Query(sql.ToString());
return(EntityConvertTools.CopyToList <tbl_AttachmentPic, AttachmentPicEntity>(list.ToList()));
}
public List <StudyOrderDetailEntity> GetList(StudyOrderDetailEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_StudyOrderDetail");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
var list = tbl_StudyOrderDetail.Query(sql.ToString());
return(EntityConvertTools.CopyToList <tbl_StudyOrderDetail, StudyOrderDetailEntity>(list.ToList()));
}
public List <ExamPlaceMasterEntity> GetList(ExamPlaceMasterEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_ExamPlaceMaster");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
var list = tbl_ExamPlaceMaster.Query(sql.ToString());
return(EntityConvertTools.CopyToList <tbl_ExamPlaceMaster, ExamPlaceMasterEntity>(list.ToList()));
}
public List <TestEntity> GetList(TestEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from web_test");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
var list = web_test.Query(sql.ToString());
return(EntityConvertTools.CopyToList <web_test, TestEntity>(list.ToList()));
}
public List <TrainingCustomFreeTimeEntity> GetList(TrainingCustomFreeTimeEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_TrainingCustomFreeTime");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
var list = tbl_TrainingCustomFreeTime.Query(sql.ToString());
return(EntityConvertTools.CopyToList <tbl_TrainingCustomFreeTime, TrainingCustomFreeTimeEntity>(list.ToList()));
}
/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <UserEntity> GetPageList(Pagination pagination, UserEntity para)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_User where 1=1 and UserId<>'System' and DeleteMark=0");
//公司主键
if (para.OrganizeId != null)
{
sql.Append(" and OrganizeId=@0", para.OrganizeId);
}
//部门主键
if (para.DepartmentId != null)
{
sql.Append(" and DepartmentId=@0", para.DepartmentId);
}
if (para.DepartmentId != null)
{
sql.Append(" and DepartmentId=@0", para.DepartmentId);
}
if (para.Account != null)
{
sql.Append("and (charindex(@0,Account)>0)", para.Account);
}
if (para.RealName != null)
{
sql.Append("and (charindex(@0,RealName)>0)", para.RealName);
}
if (para.Mobile != null)
{
sql.Append("and (charindex(@0,Mobile)>0)", para.Mobile);
}
if (para.CreateUserId != null)
{
sql.Append("and (CreateUserId=@0 or UserId=@0)", para.CreateUserId);
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.OrderBy(new object[] { pagination.sidx + " " + pagination.sord });
}
var currentpage = Base_User.Page(pagination.page, pagination.rows, sql);
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return(EntityConvertTools.CopyToList <Base_User, UserEntity>(pageList.ToList()));
}
public void SaveForm(string keyValue, UserAuthorizeEntity userAuthorizeEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
Base_UserAuthorize model = Base_UserAuthorize.SingleOrDefault("where UserAuthorizeId=@0", keyValue);
model = EntityConvertTools.CopyToModel <UserAuthorizeEntity, Base_UserAuthorize>(userAuthorizeEntity, model);
model.UserAuthorizeId = keyValue;
model.Update();
}
else
{
Base_UserAuthorize model = EntityConvertTools.CopyToModel <UserAuthorizeEntity, Base_UserAuthorize>(userAuthorizeEntity, null);
model.Insert();
}
}
public void SaveForm(string keyValue, UserRoleEntity userRoleEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
Base_UserRole role = Base_UserRole.SingleOrDefault("where UserRoleId=@0", keyValue);
role = EntityConvertTools.CopyToModel <UserRoleEntity, Base_UserRole>(userRoleEntity, role);
role.UserRoleId = keyValue;
role.Update();
}
else
{
Base_UserRole role = EntityConvertTools.CopyToModel <UserRoleEntity, Base_UserRole>(userRoleEntity, null);
role.Insert();
}
}
public List<MessageEntity> GetList(MessageEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_Message");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
if (!string.IsNullOrWhiteSpace(para.sidx))
{
sql.AppendFormat(" order by {0} {1}", para.sidx, para.sord);
}
var list = tbl_Message.Query(sql.ToString());
return EntityConvertTools.CopyToList<tbl_Message, MessageEntity>(list.ToList());
}
/// <summary>
/// 区域列表
/// </summary>
/// <param name="parentId">节点Id</param>
/// <param name="keyword">关键字查询</param>
/// <returns></returns>
public IEnumerable <AreaEntity> GetList(string parentId, string keyword)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Area where 1=1");
if (!string.IsNullOrEmpty(parentId))
{
sql.Append(" and ParentId=@0", parentId);
}
if (!string.IsNullOrEmpty(keyword))
{
sql.Append(" and (charindex(@0,AreaCode)>0 or (charindex(@0,AreaName)>0", keyword);
}
var list = Base_Area.Query(sql);
return(EntityConvertTools.CopyToList <Base_Area, AreaEntity>(list.ToList()));
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
dataItemDetailEntity.Modify(keyValue);
Base_DataItemDetail detail = Base_DataItemDetail.SingleOrDefault("where ItemDetailId=@0", keyValue);
detail = EntityConvertTools.CopyToModel <DataItemDetailEntity, Base_DataItemDetail>(dataItemDetailEntity, detail);
detail.ItemDetailId = keyValue;
detail.Update();
}
else
{
dataItemDetailEntity.Create();
Base_DataItemDetail detail = EntityConvertTools.CopyToModel <DataItemDetailEntity, Base_DataItemDetail>(dataItemDetailEntity, null);
detail.Insert();
}
}
/// <summary>
/// 保存机构表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="organizeEntity">机构实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, OrganizeEntity organizeEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
organizeEntity.Modify(keyValue);
Base_Organize organize = Base_Organize.SingleOrDefault("where OrganizeId=@0", keyValue);
organize = EntityConvertTools.CopyToModel <OrganizeEntity, Base_Organize>(organizeEntity, organize);
organize.OrganizeId = keyValue;
organize.Update();
}
else
{
organizeEntity.Create();
Base_Organize organize = EntityConvertTools.CopyToModel <OrganizeEntity, Base_Organize>(organizeEntity, null);
organize.Insert();
}
}
/// <summary>
/// 保存部门表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="departmentEntity">机构实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, DepartmentEntity departmentEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
departmentEntity.Modify(keyValue);
Base_Department depart = Base_Department.SingleOrDefault("where DepartmentId=@0", keyValue);
depart = EntityConvertTools.CopyToModel <DepartmentEntity, Base_Department>(departmentEntity, depart);
depart.DepartmentId = keyValue;
depart.Update();
}
else
{
departmentEntity.Create();
Base_Department depart = EntityConvertTools.CopyToModel <DepartmentEntity, Base_Department>(departmentEntity, null);
depart.Insert();
}
}
/// <summary>
/// 保存区域表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="{">区域实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, AreaEntity areaEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
areaEntity.Modify(keyValue);
Base_Area area = Base_Area.SingleOrDefault("where AreaId=@0", keyValue);
area = EntityConvertTools.CopyToModel <AreaEntity, Base_Area>(areaEntity, area);
area.AreaId = keyValue;
area.Update();
}
else
{
areaEntity.Create();
Base_Area area = EntityConvertTools.CopyToModel <AreaEntity, Base_Area>(areaEntity, null);
area.Insert();
}
}
/// <summary>
/// 过滤IP列表
/// </summary>
/// <param name="objectId">对象Id</param>
/// <param name="visitType">访问:0-拒绝，1-允许</param>
/// <returns></returns>
public IEnumerable <FilterIPEntity> GetList(string objectId, string visitType)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_FilterIP where 1=1 ");
if (!string.IsNullOrEmpty(visitType))
{
int _visittype = visitType.ToInt();
sql.Append(" and VisitType=@0", _visittype);
}
if (!string.IsNullOrEmpty(objectId))
{
sql.Append(" and ObjectId=@0", objectId);
}
sql.Append(" order by CreateDate desc");
var list = Base_FilterIP.Query(sql);
return(EntityConvertTools.CopyToList <Base_FilterIP, FilterIPEntity>(list.ToList()));
}
/// <summary>
/// 登陆验证
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public SchoolEntity CheckLogin(string username, string pwd)
{
var sql = new StringBuilder();
sql.AppendFormat(@"select * from tbl_School where MasterAccount='{0}' or ConectTel='{0}'", username);
var list = tbl_School.Query(sql.ToString());
if (list != null)
{
var account = list.FirstOrDefault();
if (account != null && account.Pwd == pwd)
{
var model = EntityConvertTools.CopyToModel <tbl_School, SchoolEntity>(account, null);
return(model);
}
}
return(null);
}
/// <summary>
/// 登陆验证
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public MemberEntity CheckLogin(string username, string pwd)
{
var sql = new StringBuilder();
sql.AppendFormat(@"select * from tbl_Member where MemberName='{0}' or Mobile='{0}'", username);
var list = tbl_Member.Query(sql.ToString());
if (list != null)
{
var account = list.FirstOrDefault();
if (account != null && account.Pwd == pwd)
{
var model = EntityConvertTools.CopyToModel <tbl_Member, MemberEntity>(account, null);
return(model);
}
}
return(null);
}
/// <summary>
/// 保存岗位表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="postEntity">岗位实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, RoleEntity postEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
postEntity.Modify(keyValue);
Base_Role role = Base_Role.SingleOrDefault("where RoleId=@0", keyValue);
role = EntityConvertTools.CopyToModel <RoleEntity, Base_Role>(postEntity, role);
role.RoleId = keyValue;
role.Update();
}
else
{
postEntity.Create();
postEntity.Category = (int)QSDMS.Model.Enums.RoleCategoryEnum.岗位;
Base_Role role = EntityConvertTools.CopyToModel <RoleEntity, Base_Role>(postEntity, null);
role.Insert();
}
}
/// <summary>
/// 保存过滤IP表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="filterIPEntity">过滤IP实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, FilterIPEntity filterIPEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
filterIPEntity.Modify(keyValue);
Base_FilterIP filterIP = Base_FilterIP.SingleOrDefault("where FilterIPId=@0", keyValue);
filterIP = EntityConvertTools.CopyToModel <FilterIPEntity, Base_FilterIP>(filterIPEntity, filterIP);
filterIP.FilterIPId = keyValue;
filterIP.Update();
}
else
{
filterIPEntity.Create();
Base_FilterIP filterIP = new Base_FilterIP();
filterIP = EntityConvertTools.CopyToModel <FilterIPEntity, Base_FilterIP>(filterIPEntity, null);
filterIP.Insert();
}
}
/// <summary>
/// 职位列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <RoleEntity> GetPageList(Pagination pagination, string queryJson)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Role where 1=1 and Category=@0", (int)QSDMS.Model.Enums.RoleCategoryEnum.职位);
var queryParam = queryJson.ToJObject();
//机构主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
sql.Append(" and OrganizeId=@0", organizeId);
}
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyword = queryParam["keyword"].ToString();
switch (condition)
{
case "EnCode": //职位编号
sql.Append(" and (charindex(@0,EnCode)>0)", keyword);
break;
case "FullName": //职位名称
sql.Append(" and (charindex(@0,FullName)>0)", keyword);
break;
default:
break;
}
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.OrderBy(new object[] { pagination.sidx + " " + pagination.sord });
}
var currentpage = Base_Role.Page(pagination.page, pagination.rows, sql);
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return(EntityConvertTools.CopyToList <Base_Role, RoleEntity>(pageList.ToList()));
}
/// <summary>
/// 保存过滤时段表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="filterTimeEntity">过滤时段实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, FilterTimeEntity filterTimeEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
filterTimeEntity.Modify(keyValue);
Base_FilterTime filterTime = Base_FilterTime.SingleOrDefault("where FilterTimeId=@0", keyValue);
filterTime = EntityConvertTools.CopyToModel <FilterTimeEntity, Base_FilterTime>(filterTimeEntity, filterTime);
filterTime.FilterTimeId = keyValue;
filterTime.Update();
}
else
{
filterTimeEntity.Create();
filterTimeEntity.FilterTimeId = filterTimeEntity.ObjectId;
Base_FilterTime filterTime = new Base_FilterTime();
filterTime = EntityConvertTools.CopyToModel <FilterTimeEntity, Base_FilterTime>(filterTimeEntity, null);
filterTime.Insert();
}
}
public List<MessageEntity> GetPageList(MessageEntity para, ref Pagination pagination)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_Message");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.AppendFormat(" order by {0} {1}", pagination.sidx, pagination.sord);
}
var currentpage = tbl_Message.Page(pagination.page, pagination.rows, sql.ToString());
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return EntityConvertTools.CopyToList<tbl_Message, MessageEntity>(pageList.ToList());
}
public List <CourseItemEntity> GetList(CourseItemEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from tbl_CourseItem");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
if (para != null)
{
if (!string.IsNullOrWhiteSpace(para.sidx))
{
sql.AppendFormat(" order by {0} {1}", para.sidx, para.sord);
}
}
var list = tbl_CourseItem.Query(sql.ToString());
return(EntityConvertTools.CopyToList <tbl_CourseItem, CourseItemEntity>(list.ToList()));
}
public virtual List <SettingsEntity> GetList(SettingsEntity para)
{
var sql = new StringBuilder();
sql.Append(@"select * from Sys_Settings");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
if (para != null)
{
if (!string.IsNullOrWhiteSpace(para.sidx))
{
sql.AppendFormat(" order by {0} {1}", para.sidx, para.sord);
}
}
var list = db.Query <Sys_Setting>(sql.ToString());
return(EntityConvertTools.CopyToList <Sys_Setting, SettingsEntity>(list.ToList()));
}
public IEnumerable <UserAuthorizeEntity> GetPageList(Pagination pagination, string queryJson)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_UserAuthorize where 1=1");
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyword = queryParam["keyword"].ToString();
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.OrderBy(new object[] { pagination.sidx + " " + pagination.sord });
}
var currentpage = Base_UserAuthorize.Page(pagination.page, pagination.rows, sql);
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return(EntityConvertTools.CopyToList <Base_UserAuthorize, UserAuthorizeEntity>(pageList.ToList()));
}
public virtual List <SettingsEntity> GetPageList(SettingsEntity para, ref Pagination pagination)
{
//重新处理数据库连接
var sql = new StringBuilder();
sql.Append(@"select * from Sys_Settings");
string where = ConverPara(para);
if (!string.IsNullOrEmpty(where))
{
sql.AppendFormat(" where 1=1 {0}", where);
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.AppendFormat(" order by {0} {1}", pagination.sidx, pagination.sord);
}
var currentpage = db.Page <Sys_Setting>(pagination.page, pagination.rows, sql.ToString());
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return(EntityConvertTools.CopyToList <Sys_Setting, SettingsEntity>(pageList.ToList()));
}
public AuditOrderEntity GetEntity(string keyValue)
{
var model = tbl_AuditOrder.SingleOrDefault("where AuditOrderId=@0", keyValue);
return(EntityConvertTools.CopyToModel <tbl_AuditOrder, AuditOrderEntity>(model, null));
}
public SettingsEntity GetEntity(string keyValue)
{
var model = tbl_Setting.SingleOrDefault("where SettingId=@0", keyValue);
return(EntityConvertTools.CopyToModel <tbl_Setting, SettingsEntity>(model, null));
}
/// <summary>
/// 机构实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public OrganizeEntity GetEntity(string keyValue)
{
var organize = Base_Organize.SingleOrDefault("where OrganizeId=@0", keyValue);
return(EntityConvertTools.CopyToModel <Base_Organize, OrganizeEntity>(organize, null));
}
