/// <summary> /// 根据物理主码查询 /// </summary> /// <param name="id">id</param> /// <returns>结果</returns> public LanCate SELECT_BY_ID(long id) { try { LanCate rd = new LanCate(); S_lancate temp = (from row in db.S_lancate where row.id == id select row).First(); rd.Id = temp.id; rd.Name = temp.name; rd.Sort = temp.sort; rd.Isused = temp.isused; return(rd); } catch { return(null); } }
/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID</returns> public long INSERT(LanCate info) { try { S_lancate temp = new S_lancate(); //temp.id = info.Id; temp.name = info.Name; temp.sort = info.Sort; temp.isused = info.Isused; Table <S_lancate> table = db.GetTable <S_lancate>(); table.InsertOnSubmit(temp); db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 更新函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码返回-1</returns> public long UPDATE(LanCate info) { try { S_lancate temp = new S_lancate(); Table <S_lancate> table = db.GetTable <S_lancate>(); temp = (from row in db.S_lancate where row.id == info.Id select row).First(); //temp.id = info.Id; temp.name = info.Name; temp.sort = info.Sort; temp.isused = info.Isused; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }