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