/// <summary> /// 更新函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码返回-1</returns> public int UPDATE(Property info) { try { if (SELECT_BY_NAME_ISUSED(info.Name, true) != null) { return(-1); } U_property temp = new U_property(); Table <U_property> table = db.GetTable <U_property>(); temp = (from row in db.U_property where row.id == info.Id select row).First(); //temp.id = info.Id; temp.name = info.Name; temp.description = info.Description; temp.isused = info.Isused; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码项返-1</returns> public int INSERT(Property info) { try { if (SELECT_BY_NAME_ISUSED(info.Name, true) != null) { return(-1); } U_property temp = new U_property(); //temp.id = info.Id; temp.name = info.Name; temp.description = info.Description; temp.isused = info.Isused; Table <U_property> table = db.GetTable <U_property>(); table.InsertOnSubmit(temp); db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 逻辑删除 /// </summary> /// <param name="id">物理主码</param> /// <returns>影响数据物理ID</returns> public int DELETE(short id) { try { U_property temp = new U_property(); Table <U_property> table = db.GetTable <U_property>(); temp = (from row in db.U_property 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="name">名称</param> /// <param name="isused">在用</param> /// <returns>结果</returns> public Property SELECT_BY_NAME_ISUSED(string name, bool isused) { try { Property rd = new Property(); U_property temp = (from row in db.U_property where row.name == name && row.isused == isused select row).First(); rd.Id = temp.id; rd.Name = temp.name; rd.Description = temp.description; rd.Isused = temp.isused; return(rd); } catch { return(null); } }
/// <summary> /// 根据物理主码查询 /// </summary> /// <param name="id">id</param> /// <returns>结果</returns> public Property SELECT_BY_ID(short id) { try { Property rd = new Property(); U_property temp = (from row in db.U_property where row.id == id select row).First(); rd.Id = temp.id; rd.Name = temp.name; rd.Description = temp.description; rd.Isused = temp.isused; return(rd); } catch { return(null); } }