/// <summary> /// 根据物理主码查询 /// </summary> /// <param name="id">id</param> /// <returns>结果</returns> public EquipType SELECT_BY_ID(long id) { try { EquipType rd = new EquipType(); U_equiptype temp = (from row in db.U_equiptype where row.id == id select row).First(); rd.Id = temp.id; rd.Name = temp.name; rd.Sort = temp.sort; rd.Icon = temp.icon; rd.Isused = temp.isused; return(rd); } catch { return(null); } }
/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID</returns> public long INSERT(EquipType info) { try { U_equiptype temp = new U_equiptype(); //temp.id = info.Id; temp.name = info.Name; temp.sort = info.Sort; temp.icon = info.Icon; temp.isused = info.Isused; Table <U_equiptype> table = db.GetTable <U_equiptype>(); 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(EquipType info) { try { U_equiptype temp = new U_equiptype(); Table <U_equiptype> table = db.GetTable <U_equiptype>(); temp = (from row in db.U_equiptype where row.id == info.Id select row).First(); //temp.id = info.Id; temp.name = info.Name; temp.sort = info.Sort; temp.icon = info.Icon; temp.isused = info.Isused; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }