/// <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);
}
}
