/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码项返-1</returns> public short INSERT(FireHouse info) { try { if (SELECT_BY_NAME_ISUSED(info.Name, true) != null) { return(-1); } U_firehouse temp = new U_firehouse(); //temp.id = info.Id; temp.name = info.Name; temp.aid = info.Aid; temp.lng = info.Lng; temp.lat = info.Lat; temp.description = info.Description; temp.isused = info.Isused; Table <U_firehouse> table = db.GetTable <U_firehouse>(); table.InsertOnSubmit(temp); db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 更新函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码返回-1</returns> public short UPDATE(FireHouse info) { try { //if (SELECT_BY_NAME_ISUSED(info.Name, true) != null) //{ // return -1; //} U_firehouse temp = new U_firehouse(); Table <U_firehouse> table = db.GetTable <U_firehouse>(); temp = (from row in db.U_firehouse where row.id == info.Id select row).First(); //temp.id = info.Id; temp.name = info.Name; temp.aid = info.Aid; temp.lng = info.Lng; temp.lat = info.Lat; temp.description = info.Description; temp.isused = info.Isused; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 逻辑删除 /// </summary> /// <param name="id">物理主码</param> /// <returns>影响数据物理ID</returns> public int DELETE(short id) { try { U_firehouse temp = new U_firehouse(); Table <U_firehouse> table = db.GetTable <U_firehouse>(); temp = (from row in db.U_firehouse where row.id == id select row).First(); //temp.id = info.Id; temp.isused = false; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 根据物理主码查询 /// </summary> /// <param name="id">id</param> /// <returns>结果</returns> public FireHouse SELECT_BY_ID(short id) { try { FireHouse rd = new FireHouse(); U_firehouse temp = (from row in db.U_firehouse where row.id == id select row).First(); rd.Id = temp.id; rd.Name = temp.name; rd.Aid = temp.aid; rd.Lng = temp.lng; rd.Lat = temp.lat; rd.Description = temp.description; rd.Isused = temp.isused; return(rd); } catch { return(null); } }