/// <summary> /// 更新函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码返回-1</returns> public int UPDATE(Members info) { try { U_members temp = new U_members(); Table <U_members> table = db.GetTable <U_members>(); Members existtemp = SELECT_BY_ACCOUNT_ISUSED(info.Account, true); if (existtemp != null && existtemp.Id != info.Id) { return(-1); } temp = (from row in db.U_members where row.id == info.Id select row).First(); //temp.id = info.Id; temp.account = info.Account; temp.password = info.Password; temp.name = info.Name; temp.tel = info.Tel; temp.isused = info.Isused; temp.type = info.Type; temp.linkid = info.LinkId; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 插入函数 /// </summary> /// <param name="info">Model</param> /// <returns>影响数据物理ID,已存在逻辑主码项返-1</returns> public int INSERT(Members info) { try { U_members temp = new U_members(); //temp.id = info.Id; temp.account = info.Account; temp.password = info.Password; temp.name = info.Name; temp.tel = info.Tel; temp.isused = info.Isused; temp.type = info.Type; temp.linkid = info.LinkId; Table <U_members> table = db.GetTable <U_members>(); if (SELECT_BY_ACCOUNT_ISUSED(info.Account, true) != null) { return(-1); } table.InsertOnSubmit(temp); db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 物理删除 /// </summary> /// <param name="id">物理主码</param> /// <returns>影响数据物理ID</returns> public int Xqx_DELETE(Members info) { try { U_members temp = new U_members(); Table <U_members> table = db.GetTable <U_members>(); temp = (from row in db.U_members where row.id == info.Id select row).First(); table.DeleteOnSubmit(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_members temp = new U_members(); Table <U_members> table = db.GetTable <U_members>(); temp = (from row in db.U_members where row.id == id select row).First(); //temp.id = info.Id; temp.isused = false; db.SubmitChanges(); return(temp.id); } catch { return(-2); } }
/// <summary> /// 获取某权值及链接ID /// </summary> /// <param name="limit"></param> /// <param name="linkid"></param> /// <returns></returns> public Members SELECT_BY_TYPE_LINK(short limit, long linkid) { try { Members rd = new Members(); U_members temp = (from row in db.U_members where row.type == limit && row.linkid == linkid select row).First(); rd.Id = temp.id; rd.Account = temp.account; rd.Password = temp.password; rd.Name = temp.name; rd.Tel = temp.tel; rd.Isused = temp.isused; rd.Type = temp.type; rd.LinkId = temp.linkid; return(rd); } catch { return(null); } }
/// <summary> /// 根据逻辑主码查询 /// </summary> /// <param name="account">账号</param> /// <param name="isused">在用</param> /// <returns>结果</returns> public Members SELECT_BY_ACCOUNT_ISUSED(string account, bool isused) { try { Members rd = new Members(); U_members temp = (from row in db.U_members where row.account == account && row.isused == isused select row).First(); rd.Id = temp.id; rd.Account = temp.account; rd.Password = temp.password; rd.Name = temp.name; rd.Tel = temp.tel; rd.Isused = temp.isused; rd.Type = temp.type; rd.LinkId = temp.linkid; return(rd); } catch { return(null); } }