/// <summary> /// 添加 /// </summary> public int add(general_workflows record) { using (qdbEntities myDb = new qdbEntities()) { myDb.general_workflows.Add(record); return(myDb.SaveChanges()); } }
/// <summary> /// 更新 /// </summary> public int updateById(general_workflows record) { using (qdbEntities myDb = new qdbEntities()) { myDb.general_workflows.Attach(record); myDb.Entry(record).State = EntityState.Modified; return(myDb.SaveChanges()); } }
/// <summary> /// 删除 /// </summary> public int deleteById(int id) { using (qdbEntities myDb = new qdbEntities()) { // TODO 生成代码后需要检查一下是否找到正确的主键,这里做一个错误代码,避免直接使用 general_workflows record = new general_workflows() { ORIGREC = id }; myDb.general_workflows.Attach(record); myDb.Entry(record).State = EntityState.Deleted; return(myDb.SaveChanges()); } }
/// <summary> /// 更新 /// </summary> public int updateById(general_workflows record) { return(new GeneralWorkflowsDao().updateById(record)); }
/// <summary> /// 添加 /// </summary> public int add(general_workflows record) { return(new GeneralWorkflowsDao().add(record)); }
/// <summary> /// 分页查询 /// </summary> public List <general_workflows> queryPage(general_workflows record) { return(new GeneralWorkflowsDao().queryPage(record)); }
/// <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 <general_workflows> queryPage(general_workflows record) { int _total = 0; Expression <Func <general_workflows, bool> > whereLambda = PredicateExtensions.True <general_workflows>(); if (record.ORIGREC != null) { whereLambda.And(p => p.ORIGREC.Equals(record.ORIGREC)); } if (!String.IsNullOrEmpty(record.WORKFLOWCODE)) { whereLambda.And(p => p.WORKFLOWCODE.Equals(record.WORKFLOWCODE)); } if (!String.IsNullOrEmpty(record.WORKFLOWDESC)) { whereLambda.And(p => p.WORKFLOWDESC.Equals(record.WORKFLOWDESC)); } if (!String.IsNullOrEmpty(record.WORKFLOWNAME)) { whereLambda.And(p => p.WORKFLOWNAME.Equals(record.WORKFLOWNAME)); } if (record.STARTDATE != null) { whereLambda.And(p => p.STARTDATE.Equals(record.STARTDATE)); } if (record.VERSION != null) { whereLambda.And(p => p.VERSION.Equals(record.VERSION)); } if (!String.IsNullOrEmpty(record.APPLICATIONREF)) { whereLambda.And(p => p.APPLICATIONREF.Equals(record.APPLICATIONREF)); } if (record.ENDDATE != null) { whereLambda.And(p => p.ENDDATE.Equals(record.ENDDATE)); } if (!String.IsNullOrEmpty(record.ORIGSTS)) { whereLambda.And(p => p.ORIGSTS.Equals(record.ORIGSTS)); } if (!String.IsNullOrEmpty(record.TABLERELATED)) { whereLambda.And(p => p.TABLERELATED.Equals(record.TABLERELATED)); } if (!String.IsNullOrEmpty(record.STATUSFIELD)) { whereLambda.And(p => p.STATUSFIELD.Equals(record.STATUSFIELD)); } if (!String.IsNullOrEmpty(record.DISSTATUSFIELD)) { whereLambda.And(p => p.DISSTATUSFIELD.Equals(record.DISSTATUSFIELD)); } if (!String.IsNullOrEmpty(record.NEEDESIGN)) { whereLambda.And(p => p.NEEDESIGN.Equals(record.NEEDESIGN)); } if (!String.IsNullOrEmpty(record.REJECTFIELD)) { whereLambda.And(p => p.REJECTFIELD.Equals(record.REJECTFIELD)); } if (!String.IsNullOrEmpty(record.RETIRED)) { whereLambda.And(p => p.RETIRED.Equals(record.RETIRED)); } return(LoadPageItems(5, 2, out _total, whereLambda, p => p.ORIGREC, true)); // return LoadPageItems(5, 2, out _total, whereLambda, p => p.id, true); }