/// <summary> /// 根据物理主码查询 /// </summary> /// <param name="id">id</param> /// <returns>结果</returns> public News SELECT_BY_ID(long id) { try { News rd = new News(); U_news temp = (from row in db.U_news where row.id == id select row).First(); rd.Id = temp.id; rd.Mid = temp.mid; rd.Title = temp.title; rd.Context = temp.context; rd.Datetime = temp.datetime; rd.Cn = temp.cn; rd.Isused = temp.isused; return(rd); } catch { return(null); } }
/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID</returns> public long INSERT(News info) { try { U_news temp = new U_news(); //temp.id = info.Id; temp.mid = info.Mid; temp.title = info.Title; temp.context = info.Context; temp.datetime = info.Datetime; temp.cn = info.Cn; temp.isused = info.Isused; Table <U_news> table = db.GetTable <U_news>(); 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(News info) { try { U_news temp = new U_news(); Table <U_news> table = db.GetTable <U_news>(); temp = (from row in db.U_news where row.id == info.Id select row).First(); //temp.id = info.Id; temp.mid = info.Mid; temp.title = info.Title; temp.context = info.Context; temp.datetime = info.Datetime; temp.cn = info.Cn; temp.isused = info.Isused; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }