/// <summary> /// 分页查询 /// </summary> /// <param name="obj"></param> /// <param name="pager"></param> /// <returns></returns> public List <Mes_Tec_TestDataPosition> FindByPage(Mes_Tec_TestDataPosition obj, ref PagerBase pager) { string sql = @"SELECT T1.*,T2.Name AS ProcessName FROM Mes_Tec_TestDataPosition T1 WITH(NOLOCK) LEFT JOIN Mes_Tec_Process T2 WITH(NOLOCK) ON T1.ProcessCode=T2.ProcessCode WHERE 1=1 "; if (!string.IsNullOrEmpty(obj.ProcessCode)) { sql += string.Format(" AND T1.ProcessCode Like '%{0}%'", obj.ProcessCode); } if (!string.IsNullOrEmpty(obj.DataTableName)) { sql += string.Format(" AND T1.DataTableName Like '%{0}%'", obj.DataTableName); } if (!string.IsNullOrEmpty(obj.DataProcessName)) { sql += string.Format(" AND T1.DataProcessName Like '%{0}%'", obj.DataProcessName); } string orderBy = pager.OrderBy; if (string.IsNullOrEmpty(orderBy)) { orderBy = "CreatedTime DESC"; } string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo); string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal))); //查询总记录数 pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>(); //返回当前页的记录数 return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Tec_TestDataPosition>()); }
public ActionResult TestDataPosition_FindByPage(Mes_Tec_TestDataPosition obj, int page, int rows) { var pager = new PagerBase() { CurrentPageIndex = page, PageSize = rows }; var list = MesTecTestDataPositionDao.Instance.FindByPage(obj, ref pager); return(Json(new { total = pager.TotalItemCount, rows = list })); }
/// <summary> /// 获取单个用户实体 /// </summary> /// <param name="obj"></param> /// <returns></returns> public Mes_Tec_TestDataPosition GetTestDataPosition(Mes_Tec_TestDataPosition obj) { List <SqlParameter> list = new List <SqlParameter>(); string sql = "select top 1 * from Mes_Tec_TestDataPosition where 1=1 "; if (!string.IsNullOrEmpty(obj.ProcessCode)) { sql = sql + string.Format(" AND ProcessCode='{0}'", obj.ProcessCode); } if (!string.IsNullOrEmpty(obj.DataTableName)) { sql = sql + string.Format(" AND DataTableName='{0}'", obj.DataTableName); } if (!string.IsNullOrEmpty(obj.DataProcessName)) { sql = sql + string.Format(" AND DataProcessName='{0}'", obj.DataProcessName); } return(this.CurDbSession.FromSql(sql.ToString()).ToFirstDefault <Mes_Tec_TestDataPosition>()); }
/// <summary> /// 保存用户 /// </summary> /// <param name="obj"></param> /// <returns></returns> public bool Save(Mes_Tec_TestDataPosition obj) { int result = -1; if (obj.ID > 0) { //修改 result = this.CurDbSession.Update <Mes_Tec_TestDataPosition>(obj); } else { result = this.CurDbSession.Insert <Mes_Tec_TestDataPosition>(obj); } if (result < 0) { return(false); } return(true); }
/// <summary> /// 保存记录 /// </summary> /// <returns></returns> public ActionResult TestDataPosition_Save(Mes_Tec_TestDataPosition obj) { string sMessage = string.Empty; //判断数据有效性 if (string.IsNullOrEmpty(obj.ProcessCode)) { sMessage = "工序编号不可为空"; return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet)); } if (string.IsNullOrEmpty(obj.DataTableName)) { sMessage = "测试数据表名称不可为空"; return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet)); } if (string.IsNullOrEmpty(obj.DataProcessName)) { sMessage = "测试工序不可为空"; return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet)); } if (obj.ID > 0) { obj.Modifier = base.CurUser.UserId; obj.ModifiedTime = DateTime.Now; } else { obj.Creater = base.CurUser.UserId; obj.CreatedTime = DateTime.Now; } bool result = MesTecTestDataPositionDao.Instance.Save(obj); if (!result) { sMessage = "保存失败"; return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet)); } return(Json(new { IsSuccess = true, Message = sMessage }, JsonRequestBehavior.AllowGet)); }