/// <summary>
/// 添加
/// </summary>
public int add(menu record)
{
using (qdbEntities myDb = new qdbEntities())
{
myDb.menu.Add(record);
return(myDb.SaveChanges());
}
}
/// <summary>
/// getById
/// </summary>
public roles_menus getById(int id, int menuid)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
return(myDb.Set <roles_menus>().Where <roles_menus>(p => p.MENU_ID == id && p.ROLE_ID == menuid).FirstOrDefault <roles_menus>());
}
}
/// <summary>
/// 更新
/// </summary>
public int updateById(general_workflow_func record)
{
using (qdbEntities myDb = new qdbEntities())
{
myDb.general_workflow_func.Attach(record);
myDb.Entry(record).State = EntityState.Modified;
return(myDb.SaveChanges());
}
}
/// <summary>
/// getById
/// </summary>
public general_workflow_func getById(int id)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
return(myDb.Set <general_workflow_func>().Where <general_workflow_func>(p => p.ORIGREC == id).FirstOrDefault <general_workflow_func>());
}
}
/// <summary>
/// 更新
/// </summary>
public int updateById(role record)
{
using (qdbEntities myDb = new qdbEntities())
{
myDb.role.Attach(record);
myDb.Entry(record).State = EntityState.Modified;
return(myDb.SaveChanges());
}
}
/// <summary>
/// getById
/// </summary>
public role getById(int id)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
return(myDb.Set <role>().Where <role>(p => p.ID == id).FirstOrDefault <role>());
}
}
/// <summary>
/// getById
/// </summary>
public users_roles getById(int id, int roleid)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
return(myDb.Set <users_roles>().Where <users_roles>(p => p.USER_ID == id && p.ROLE_ID == roleid).FirstOrDefault <users_roles>());
// return myDb.Set<users_roles>().Where<users_roles>(p => p.ROLE_ID == id).FirstOrDefault<users_roles>();
}
}
/// <summary>
/// 查询
/// </summary>
public List <role> query(role record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <role> db = myDb.role;
if (record.ID != null)
{
db = db.Where <role>(p => p.ID.Equals(record.ID));
}
if (!String.IsNullOrEmpty(record.NAME))
{
db = db.Where <role>(p => p.NAME.Equals(record.NAME));
}
if (!String.IsNullOrEmpty(record.REMARK))
{
db = db.Where <role>(p => p.REMARK.Equals(record.REMARK));
}
if (!String.IsNullOrEmpty(record.DATA_SCOPE))
{
db = db.Where <role>(p => p.DATA_SCOPE.Equals(record.DATA_SCOPE));
}
if (record.LEVEL != null)
{
db = db.Where <role>(p => p.LEVEL.Equals(record.LEVEL));
}
if (record.CREATE_TIME != null)
{
db = db.Where <role>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
if (!String.IsNullOrEmpty(record.PERMISSION))
{
db = db.Where <role>(p => p.PERMISSION.Equals(record.PERMISSION));
}
return(db.ToList());
}
}
/// <summary>
/// 删除
/// </summary>
public int deleteById(int id, int deptid)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
roles_depts record = new roles_depts()
{
ROLE_ID = id, DEPT_ID = deptid
};
myDb.roles_depts.Attach(record);
myDb.Entry(record).State = EntityState.Deleted;
return(myDb.SaveChanges());
}
}
/// <summary>
/// 删除
/// </summary>
public int deleteById(int id)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
general_workflow_func record = new general_workflow_func()
{
ORIGREC = id
};
myDb.general_workflow_func.Attach(record);
myDb.Entry(record).State = EntityState.Deleted;
return(myDb.SaveChanges());
}
}
/// <summary>
/// 删除
/// </summary>
public int deleteById(int id, int roleid)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
users_roles record = new users_roles()
{
USER_ID = id, ROLE_ID = roleid
};
myDb.users_roles.Attach(record);
myDb.Entry(record).State = EntityState.Deleted;
return(myDb.SaveChanges());
}
}
/// <summary>
/// 删除
/// </summary>
public int deleteById(int id)
{
using (qdbEntities myDb = new qdbEntities())
{
// TODO 生成代码后需要检查一下是否找到正确的主键，这里做一个错误代码，避免直接使用
dict_detail record = new dict_detail()
{
ID = id
};
myDb.dict_detail.Attach(record);
myDb.Entry(record).State = EntityState.Deleted;
return(myDb.SaveChanges());
}
}
/// <summary>
/// 查询
/// </summary>
public List <dict_detail> query(dict_detail record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <dict_detail> db = myDb.dict_detail;
if (record.ID != null)
{
db = db.Where <dict_detail>(p => p.ID.Equals(record.ID));
}
if (!String.IsNullOrEmpty(record.LABEL))
{
db = db.Where <dict_detail>(p => p.LABEL.Equals(record.LABEL));
}
if (!String.IsNullOrEmpty(record.VALUE))
{
db = db.Where <dict_detail>(p => p.VALUE.Equals(record.VALUE));
}
if (!String.IsNullOrEmpty(record.SORT))
{
db = db.Where <dict_detail>(p => p.SORT.Equals(record.SORT));
}
if (record.DICT_ID != null)
{
db = db.Where <dict_detail>(p => p.DICT_ID.Equals(record.DICT_ID));
}
if (record.CREATE_TIME != null)
{
db = db.Where <dict_detail>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
return(db.ToList());
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="page"></param>
/// <param name="tableName">可以是表格（对应泛型T），也可以是sql</param>
/// <returns></returns>
public PageInfo <T> DBQueryPage <T>(PageInfo <T> page, string tableName, string where)
{
if (page == null)
{
return(null);
}
using (qdbEntities qdb = new qdbEntities())
{
string totalSql = "select count(*) as recordCount from " + tableName + " T" + (String.IsNullOrEmpty(where) ? "" : " where " + where);
int totalCount = qdb.Database.SqlQuery <int>(totalSql).FirstOrDefault();
page.totalCount = totalCount;
page.totalPage = (totalCount + page.pageSize - 1) / page.pageSize;
string querySql = "select * from " + tableName + " T " + (String.IsNullOrEmpty(where) ? "" : " where " + where) + " " + (String.IsNullOrEmpty(page.orderName) ? "" : " order by " + page.orderName) + " limit " + ((page.pageIndex - 1) * page.pageSize) + "," + page.pageSize + "";
List <T> list = qdb.Database.SqlQuery <T>(querySql).ToList();
page.list = list;
return(page);
}
}
/// <summary>
/// 查询
/// </summary>
public List <roles_menus> query(roles_menus record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <roles_menus> db = myDb.roles_menus;
if (record.MENU_ID != null)
{
db = db.Where <roles_menus>(p => p.MENU_ID.Equals(record.MENU_ID));
}
if (record.ROLE_ID != null)
{
db = db.Where <roles_menus>(p => p.ROLE_ID.Equals(record.ROLE_ID));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <users_roles> query(users_roles record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <users_roles> db = myDb.users_roles;
if (record.USER_ID != null)
{
db = db.Where <users_roles>(p => p.USER_ID.Equals(record.USER_ID));
}
if (record.ROLE_ID != null)
{
db = db.Where <users_roles>(p => p.ROLE_ID.Equals(record.ROLE_ID));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <user_avatar> query(user_avatar record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <user_avatar> db = myDb.user_avatar;
if (record.ID != null)
{
db = db.Where <user_avatar>(p => p.ID.Equals(record.ID));
}
if (!String.IsNullOrEmpty(record.REAL_NAME))
{
db = db.Where <user_avatar>(p => p.REAL_NAME.Equals(record.REAL_NAME));
}
if (!String.IsNullOrEmpty(record.PATH))
{
db = db.Where <user_avatar>(p => p.PATH.Equals(record.PATH));
}
if (!String.IsNullOrEmpty(record.SIZE))
{
db = db.Where <user_avatar>(p => p.SIZE.Equals(record.SIZE));
}
if (record.CREATE_TIME != null)
{
db = db.Where <user_avatar>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <dept> query(dept record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <dept> db = myDb.dept;
if (record.ID != null)
{
db = db.Where <dept>(p => p.ID.Equals(record.ID));
}
if (!String.IsNullOrEmpty(record.NAME))
{
db = db.Where <dept>(p => p.NAME.Equals(record.NAME));
}
if (record.PID != null)
{
db = db.Where <dept>(p => p.PID.Equals(record.PID));
}
if (record.ENABLED != null)
{
db = db.Where <dept>(p => p.ENABLED.Equals(record.ENABLED));
}
if (record.CREATE_TIME != null)
{
db = db.Where <dept>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
return(db.ToList());
}
}
/// <summary>
/// 分页查询 + 条件查询 + 排序
/// </summary>
/// <typeparam name="Tkey">泛型</typeparam>
/// <param name="pageSize">每页大小</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="total">总数量</param>
/// <param name="whereLambda">查询条件</param>
/// <param name="orderbyLambda">排序条件</param>
/// <param name="isAsc">是否升序</param>
/// <returns>IQueryable 泛型集合</returns>
public List <T> LoadPageItems <T, TKey>(int pageSize, int pageIndex, out int total, Expression <Func <T, bool> > whereLambda, Func <T, TKey> orderbyLambda, bool isAsc) where T : class
{
using (qdbEntities qdb = new qdbEntities())
{
total = qdb.Set <T>().Where(whereLambda).Count();
if (isAsc)
{
var temp = qdb.Set <T>().Where(whereLambda)
.OrderBy <T, TKey>(orderbyLambda)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize);
return(temp.ToList());
}
else
{
var temp = qdb.Set <T>().Where(whereLambda)
.OrderByDescending <T, TKey>(orderbyLambda)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize);
return(temp.ToList());
}
}
}
/// <summary>
/// 查询
/// </summary>
public List <general_workflow_func> query(general_workflow_func record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <general_workflow_func> db = myDb.general_workflow_func;
if (record.ORIGREC != null)
{
db = db.Where <general_workflow_func>(p => p.ORIGREC.Equals(record.ORIGREC));
}
if (!String.IsNullOrEmpty(record.ORIGSTS))
{
db = db.Where <general_workflow_func>(p => p.ORIGSTS.Equals(record.ORIGSTS));
}
if (!String.IsNullOrEmpty(record.WORKFLOWCODE))
{
db = db.Where <general_workflow_func>(p => p.WORKFLOWCODE.Equals(record.WORKFLOWCODE));
}
if (!String.IsNullOrEmpty(record.STEPCODE))
{
db = db.Where <general_workflow_func>(p => p.STEPCODE.Equals(record.STEPCODE));
}
if (!String.IsNullOrEmpty(record.CALCDESC))
{
db = db.Where <general_workflow_func>(p => p.CALCDESC.Equals(record.CALCDESC));
}
if (!String.IsNullOrEmpty(record.CALCNAME))
{
db = db.Where <general_workflow_func>(p => p.CALCNAME.Equals(record.CALCNAME));
}
if (!String.IsNullOrEmpty(record.CALCUL))
{
db = db.Where <general_workflow_func>(p => p.CALCUL.Equals(record.CALCUL));
}
if (!String.IsNullOrEmpty(record.CONTROLID))
{
db = db.Where <general_workflow_func>(p => p.CONTROLID.Equals(record.CONTROLID));
}
if (!String.IsNullOrEmpty(record.ACTIONTYPE))
{
db = db.Where <general_workflow_func>(p => p.ACTIONTYPE.Equals(record.ACTIONTYPE));
}
if (!String.IsNullOrEmpty(record.REPLACE))
{
db = db.Where <general_workflow_func>(p => p.REPLACE.Equals(record.REPLACE));
}
if (!String.IsNullOrEmpty(record.CONTROLTYPE))
{
db = db.Where <general_workflow_func>(p => p.CONTROLTYPE.Equals(record.CONTROLTYPE));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <general_workflow_steps> query(general_workflow_steps record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <general_workflow_steps> db = myDb.general_workflow_steps;
if (record.ORIGREC != null)
{
db = db.Where <general_workflow_steps>(p => p.ORIGREC.Equals(record.ORIGREC));
}
if (!String.IsNullOrEmpty(record.WORKFLOWCODE))
{
db = db.Where <general_workflow_steps>(p => p.WORKFLOWCODE.Equals(record.WORKFLOWCODE));
}
if (!String.IsNullOrEmpty(record.USRNAM))
{
db = db.Where <general_workflow_steps>(p => p.USRNAM.Equals(record.USRNAM));
}
if (record.NUMBEROOFDAYS != null)
{
db = db.Where <general_workflow_steps>(p => p.NUMBEROOFDAYS.Equals(record.NUMBEROOFDAYS));
}
if (!String.IsNullOrEmpty(record.STEPCODE))
{
db = db.Where <general_workflow_steps>(p => p.STEPCODE.Equals(record.STEPCODE));
}
if (record.SORTER != null)
{
db = db.Where <general_workflow_steps>(p => p.SORTER.Equals(record.SORTER));
}
if (!String.IsNullOrEmpty(record.JOBDESCRIPTION))
{
db = db.Where <general_workflow_steps>(p => p.JOBDESCRIPTION.Equals(record.JOBDESCRIPTION));
}
if (!String.IsNullOrEmpty(record.GOTOSTEPS))
{
db = db.Where <general_workflow_steps>(p => p.GOTOSTEPS.Equals(record.GOTOSTEPS));
}
if (!String.IsNullOrEmpty(record.SIGNATURETYPE))
{
db = db.Where <general_workflow_steps>(p => p.SIGNATURETYPE.Equals(record.SIGNATURETYPE));
}
if (!String.IsNullOrEmpty(record.ORIGSTS))
{
db = db.Where <general_workflow_steps>(p => p.ORIGSTS.Equals(record.ORIGSTS));
}
if (!String.IsNullOrEmpty(record.TREEAUTH))
{
db = db.Where <general_workflow_steps>(p => p.TREEAUTH.Equals(record.TREEAUTH));
}
if (!String.IsNullOrEmpty(record.STEPSTATUS))
{
db = db.Where <general_workflow_steps>(p => p.STEPSTATUS.Equals(record.STEPSTATUS));
}
if (!String.IsNullOrEmpty(record.STEPNAME))
{
db = db.Where <general_workflow_steps>(p => p.STEPNAME.Equals(record.STEPNAME));
}
if (!String.IsNullOrEmpty(record.EXECUTEACTION))
{
db = db.Where <general_workflow_steps>(p => p.EXECUTEACTION.Equals(record.EXECUTEACTION));
}
if (!String.IsNullOrEmpty(record.EXECUTEACTION1))
{
db = db.Where <general_workflow_steps>(p => p.EXECUTEACTION1.Equals(record.EXECUTEACTION1));
}
if (!String.IsNullOrEmpty(record.EXECUTEACTION2))
{
db = db.Where <general_workflow_steps>(p => p.EXECUTEACTION2.Equals(record.EXECUTEACTION2));
}
if (!String.IsNullOrEmpty(record.EXECUTEACTION3))
{
db = db.Where <general_workflow_steps>(p => p.EXECUTEACTION3.Equals(record.EXECUTEACTION3));
}
if (!String.IsNullOrEmpty(record.CONSOLEITEM))
{
db = db.Where <general_workflow_steps>(p => p.CONSOLEITEM.Equals(record.CONSOLEITEM));
}
if (!String.IsNullOrEmpty(record.DESTINATIONTYPE))
{
db = db.Where <general_workflow_steps>(p => p.DESTINATIONTYPE.Equals(record.DESTINATIONTYPE));
}
if (!String.IsNullOrEmpty(record.GROUPNAME))
{
db = db.Where <general_workflow_steps>(p => p.GROUPNAME.Equals(record.GROUPNAME));
}
if (!String.IsNullOrEmpty(record.STEPDISPSTATUS))
{
db = db.Where <general_workflow_steps>(p => p.STEPDISPSTATUS.Equals(record.STEPDISPSTATUS));
}
if (!String.IsNullOrEmpty(record.GROUPTABLE))
{
db = db.Where <general_workflow_steps>(p => p.GROUPTABLE.Equals(record.GROUPTABLE));
}
if (!String.IsNullOrEmpty(record.GROUPTABLEFIELD1))
{
db = db.Where <general_workflow_steps>(p => p.GROUPTABLEFIELD1.Equals(record.GROUPTABLEFIELD1));
}
if (!String.IsNullOrEmpty(record.GROUPTABLEFIELD2))
{
db = db.Where <general_workflow_steps>(p => p.GROUPTABLEFIELD2.Equals(record.GROUPTABLEFIELD2));
}
if (!String.IsNullOrEmpty(record.GROUPTABLEFIELD3))
{
db = db.Where <general_workflow_steps>(p => p.GROUPTABLEFIELD3.Equals(record.GROUPTABLEFIELD3));
}
if (!String.IsNullOrEmpty(record.MYLIMSSTS))
{
db = db.Where <general_workflow_steps>(p => p.MYLIMSSTS.Equals(record.MYLIMSSTS));
}
if (!String.IsNullOrEmpty(record.COMMENTNAME))
{
db = db.Where <general_workflow_steps>(p => p.COMMENTNAME.Equals(record.COMMENTNAME));
}
if (!String.IsNullOrEmpty(record.FUNCCODE))
{
db = db.Where <general_workflow_steps>(p => p.FUNCCODE.Equals(record.FUNCCODE));
}
if (!String.IsNullOrEmpty(record.BYSERVGRP))
{
db = db.Where <general_workflow_steps>(p => p.BYSERVGRP.Equals(record.BYSERVGRP));
}
if (!String.IsNullOrEmpty(record.ROLES))
{
db = db.Where <general_workflow_steps>(p => p.ROLES.Equals(record.ROLES));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <user> query(user record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <user> db = myDb.user;
if (record != null)
{
if (record.ID != null)
{
db = db.Where <user>(p => p.ID.Equals(record.ID));
}
if (record.AVATAR_ID != null)
{
db = db.Where <user>(p => p.AVATAR_ID.Equals(record.AVATAR_ID));
}
if (!String.IsNullOrEmpty(record.EMAIL))
{
db = db.Where <user>(p => p.EMAIL.Equals(record.EMAIL));
}
if (record.ENABLED != null)
{
db = db.Where <user>(p => p.ENABLED.Equals(record.ENABLED));
}
if (!String.IsNullOrEmpty(record.PASSWORD))
{
db = db.Where <user>(p => p.PASSWORD.Equals(record.PASSWORD));
}
if (!String.IsNullOrEmpty(record.USERNAME))
{
db = db.Where <user>(p => p.USERNAME.Equals(record.USERNAME));
}
if (record.DEPT_ID != null)
{
db = db.Where <user>(p => p.DEPT_ID.Equals(record.DEPT_ID));
}
if (!String.IsNullOrEmpty(record.PHONE))
{
db = db.Where <user>(p => p.PHONE.Equals(record.PHONE));
}
if (record.JOB_ID != null)
{
db = db.Where <user>(p => p.JOB_ID.Equals(record.JOB_ID));
}
if (record.CREATE_TIME != null)
{
db = db.Where <user>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
if (record.LAST_PASSWORD_RESET_TIME != null)
{
db = db.Where <user>(p => p.LAST_PASSWORD_RESET_TIME.Equals(record.LAST_PASSWORD_RESET_TIME));
}
if (!String.IsNullOrEmpty(record.NICK_NAME))
{
db = db.Where <user>(p => p.NICK_NAME.Equals(record.NICK_NAME));
}
if (!String.IsNullOrEmpty(record.SEX))
{
db = db.Where <user>(p => p.SEX.Equals(record.SEX));
}
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <general_workflowstepdet> query(general_workflowstepdet record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <general_workflowstepdet> db = myDb.general_workflowstepdet;
if (record.ORIGREC != null)
{
db = db.Where <general_workflowstepdet>(p => p.ORIGREC.Equals(record.ORIGREC));
}
if (!String.IsNullOrEmpty(record.ORIGSTS))
{
db = db.Where <general_workflowstepdet>(p => p.ORIGSTS.Equals(record.ORIGSTS));
}
if (!String.IsNullOrEmpty(record.WORKFLOWCODE))
{
db = db.Where <general_workflowstepdet>(p => p.WORKFLOWCODE.Equals(record.WORKFLOWCODE));
}
if (!String.IsNullOrEmpty(record.STEPCODE))
{
db = db.Where <general_workflowstepdet>(p => p.STEPCODE.Equals(record.STEPCODE));
}
if (!String.IsNullOrEmpty(record.DISPOSITIONNAME))
{
db = db.Where <general_workflowstepdet>(p => p.DISPOSITIONNAME.Equals(record.DISPOSITIONNAME));
}
if (!String.IsNullOrEmpty(record.DISPOSITIONCODE))
{
db = db.Where <general_workflowstepdet>(p => p.DISPOSITIONCODE.Equals(record.DISPOSITIONCODE));
}
if (!String.IsNullOrEmpty(record.TOSTEPCODE))
{
db = db.Where <general_workflowstepdet>(p => p.TOSTEPCODE.Equals(record.TOSTEPCODE));
}
if (record.INVESTIGATIONCODE != null)
{
db = db.Where <general_workflowstepdet>(p => p.INVESTIGATIONCODE.Equals(record.INVESTIGATIONCODE));
}
if (!String.IsNullOrEmpty(record.TOSTEPNAME))
{
db = db.Where <general_workflowstepdet>(p => p.TOSTEPNAME.Equals(record.TOSTEPNAME));
}
if (!String.IsNullOrEmpty(record.EXECUTEACTION))
{
db = db.Where <general_workflowstepdet>(p => p.EXECUTEACTION.Equals(record.EXECUTEACTION));
}
if (record.SORTER != null)
{
db = db.Where <general_workflowstepdet>(p => p.SORTER.Equals(record.SORTER));
}
if (!String.IsNullOrEmpty(record.VERIFYACTION))
{
db = db.Where <general_workflowstepdet>(p => p.VERIFYACTION.Equals(record.VERIFYACTION));
}
if (!String.IsNullOrEmpty(record.REASONS))
{
db = db.Where <general_workflowstepdet>(p => p.REASONS.Equals(record.REASONS));
}
if (!String.IsNullOrEmpty(record.ISREJECT))
{
db = db.Where <general_workflowstepdet>(p => p.ISREJECT.Equals(record.ISREJECT));
}
if (!String.IsNullOrEmpty(record.VISIBLE))
{
db = db.Where <general_workflowstepdet>(p => p.VISIBLE.Equals(record.VISIBLE));
}
if (!String.IsNullOrEmpty(record.AUDITTYPE))
{
db = db.Where <general_workflowstepdet>(p => p.AUDITTYPE.Equals(record.AUDITTYPE));
}
if (!String.IsNullOrEmpty(record.NOTNULLCOMMENT))
{
db = db.Where <general_workflowstepdet>(p => p.NOTNULLCOMMENT.Equals(record.NOTNULLCOMMENT));
}
if (!String.IsNullOrEmpty(record.DISPFLAG))
{
db = db.Where <general_workflowstepdet>(p => p.DISPFLAG.Equals(record.DISPFLAG));
}
if (!String.IsNullOrEmpty(record.STEPDETCAT))
{
db = db.Where <general_workflowstepdet>(p => p.STEPDETCAT.Equals(record.STEPDETCAT));
}
if (!String.IsNullOrEmpty(record.REQUIREREASON))
{
db = db.Where <general_workflowstepdet>(p => p.REQUIREREASON.Equals(record.REQUIREREASON));
}
if (!String.IsNullOrEmpty(record.ISMULTIAUDIT))
{
db = db.Where <general_workflowstepdet>(p => p.ISMULTIAUDIT.Equals(record.ISMULTIAUDIT));
}
if (!String.IsNullOrEmpty(record.ISAUDITUSER))
{
db = db.Where <general_workflowstepdet>(p => p.ISAUDITUSER.Equals(record.ISAUDITUSER));
}
if (!String.IsNullOrEmpty(record.CALCUL))
{
db = db.Where <general_workflowstepdet>(p => p.CALCUL.Equals(record.CALCUL));
}
if (!String.IsNullOrEmpty(record.BUSINESSTYPE))
{
db = db.Where <general_workflowstepdet>(p => p.BUSINESSTYPE.Equals(record.BUSINESSTYPE));
}
if (!String.IsNullOrEmpty(record.MESSAGETEXT))
{
db = db.Where <general_workflowstepdet>(p => p.MESSAGETEXT.Equals(record.MESSAGETEXT));
}
if (!String.IsNullOrEmpty(record.MESSAGEUSER))
{
db = db.Where <general_workflowstepdet>(p => p.MESSAGEUSER.Equals(record.MESSAGEUSER));
}
if (!String.IsNullOrEmpty(record.ISSENDMES))
{
db = db.Where <general_workflowstepdet>(p => p.ISSENDMES.Equals(record.ISSENDMES));
}
if (!String.IsNullOrEmpty(record.ISMULTIPLE))
{
db = db.Where <general_workflowstepdet>(p => p.ISMULTIPLE.Equals(record.ISMULTIPLE));
}
if (!String.IsNullOrEmpty(record.VERIFYCALCNO))
{
db = db.Where <general_workflowstepdet>(p => p.VERIFYCALCNO.Equals(record.VERIFYCALCNO));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <general_workflows> query(general_workflows record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <general_workflows> db = myDb.general_workflows;
if (record.ORIGREC != null)
{
db = db.Where <general_workflows>(p => p.ORIGREC.Equals(record.ORIGREC));
}
if (!String.IsNullOrEmpty(record.WORKFLOWCODE))
{
db = db.Where <general_workflows>(p => p.WORKFLOWCODE.Equals(record.WORKFLOWCODE));
}
if (!String.IsNullOrEmpty(record.WORKFLOWDESC))
{
db = db.Where <general_workflows>(p => p.WORKFLOWDESC.Equals(record.WORKFLOWDESC));
}
if (!String.IsNullOrEmpty(record.WORKFLOWNAME))
{
db = db.Where <general_workflows>(p => p.WORKFLOWNAME.Equals(record.WORKFLOWNAME));
}
if (record.STARTDATE != null)
{
db = db.Where <general_workflows>(p => p.STARTDATE.Equals(record.STARTDATE));
}
if (record.VERSION != null)
{
db = db.Where <general_workflows>(p => p.VERSION.Equals(record.VERSION));
}
if (!String.IsNullOrEmpty(record.APPLICATIONREF))
{
db = db.Where <general_workflows>(p => p.APPLICATIONREF.Equals(record.APPLICATIONREF));
}
if (record.ENDDATE != null)
{
db = db.Where <general_workflows>(p => p.ENDDATE.Equals(record.ENDDATE));
}
if (!String.IsNullOrEmpty(record.ORIGSTS))
{
db = db.Where <general_workflows>(p => p.ORIGSTS.Equals(record.ORIGSTS));
}
if (!String.IsNullOrEmpty(record.TABLERELATED))
{
db = db.Where <general_workflows>(p => p.TABLERELATED.Equals(record.TABLERELATED));
}
if (!String.IsNullOrEmpty(record.STATUSFIELD))
{
db = db.Where <general_workflows>(p => p.STATUSFIELD.Equals(record.STATUSFIELD));
}
if (!String.IsNullOrEmpty(record.DISSTATUSFIELD))
{
db = db.Where <general_workflows>(p => p.DISSTATUSFIELD.Equals(record.DISSTATUSFIELD));
}
if (!String.IsNullOrEmpty(record.NEEDESIGN))
{
db = db.Where <general_workflows>(p => p.NEEDESIGN.Equals(record.NEEDESIGN));
}
if (!String.IsNullOrEmpty(record.REJECTFIELD))
{
db = db.Where <general_workflows>(p => p.REJECTFIELD.Equals(record.REJECTFIELD));
}
if (!String.IsNullOrEmpty(record.RETIRED))
{
db = db.Where <general_workflows>(p => p.RETIRED.Equals(record.RETIRED));
}
return(db.ToList());
}
}
/// <summary>
/// 查询
/// </summary>
public List <menu> query(menu record)
{
using (qdbEntities myDb = new qdbEntities())
{
IQueryable <menu> db = myDb.menu;
if (record.ID != null)
{
db = db.Where <menu>(p => p.ID.Equals(record.ID));
}
if (record.I_FRAME != null)
{
db = db.Where <menu>(p => p.I_FRAME.Equals(record.I_FRAME));
}
if (!String.IsNullOrEmpty(record.NAME))
{
db = db.Where <menu>(p => p.NAME.Equals(record.NAME));
}
if (!String.IsNullOrEmpty(record.COMPONENT))
{
db = db.Where <menu>(p => p.COMPONENT.Equals(record.COMPONENT));
}
if (record.PID != null)
{
db = db.Where <menu>(p => p.PID.Equals(record.PID));
}
if (record.SORT != null)
{
db = db.Where <menu>(p => p.SORT.Equals(record.SORT));
}
if (!String.IsNullOrEmpty(record.ICON))
{
db = db.Where <menu>(p => p.ICON.Equals(record.ICON));
}
if (!String.IsNullOrEmpty(record.PATH))
{
db = db.Where <menu>(p => p.PATH.Equals(record.PATH));
}
if (record.CACHE != null)
{
db = db.Where <menu>(p => p.CACHE.Equals(record.CACHE));
}
if (record.HIDDEN != null)
{
db = db.Where <menu>(p => p.HIDDEN.Equals(record.HIDDEN));
}
if (!String.IsNullOrEmpty(record.COMPONENT_NAME))
{
db = db.Where <menu>(p => p.COMPONENT_NAME.Equals(record.COMPONENT_NAME));
}
if (record.CREATE_TIME != null)
{
db = db.Where <menu>(p => p.CREATE_TIME.Equals(record.CREATE_TIME));
}
if (!String.IsNullOrEmpty(record.PERMISSION))
{
db = db.Where <menu>(p => p.PERMISSION.Equals(record.PERMISSION));
}
if (record.TYPE != null)
{
db = db.Where <menu>(p => p.TYPE.Equals(record.TYPE));
}
if (!String.IsNullOrEmpty(record.MODULES))
{
db = db.Where <menu>(p => p.MODULES.Equals(record.MODULES));
}
return(db.ToList());
}
}
