public int EditByID(ref string ReturnDescription)
{
if (ID < 0)
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString, "", "[ID] = " + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return(-1);
}
SLS.Dal.Tables.T_CardPasswordAgents t_CardPasswordAgents = new SLS.Dal.Tables.T_CardPasswordAgents();
t_CardPasswordAgents.Company.Value = Company;
t_CardPasswordAgents.Password.Value = Password;
t_CardPasswordAgents.Name.Value = Name;
t_CardPasswordAgents.State.Value = State;
t_CardPasswordAgents.Url.Value = Url;
t_CardPasswordAgents.Update(PF.ConnectString, "[ID] = " + ID.ToString());
return(0);
}
// 正常用户登录
public int Login(ref string ReturnDescription)
{
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString,"", "ID=" + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "用户不存在";
return -1;
}
if (dt.Rows[0]["Password"].ToString() != PF.EncryptPassword(Password))
{
ReturnDescription = "密码错误";
return -2;
}
//if (!Shove._Convert.StrToBool(dt.Rows[0]["State"].ToString(), false))
if (dt.Rows[0]["State"].ToString() != "1")
{
ReturnDescription = "代理商帐号已经过期";
return -2;
}
Name = dt.Rows[0]["Name"].ToString();
Password = dt.Rows[0]["Password"].ToString();
Company = dt.Rows[0]["Company"].ToString();
Url = dt.Rows[0]["Url"].ToString();
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
// 校验成功
SaveUserIDToCookie();
return 0;
}
// 正常用户登录
public int Login(ref string ReturnDescription)
{
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString, "", "ID=" + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "用户不存在";
return(-1);
}
if (dt.Rows[0]["Password"].ToString() != PF.EncryptPassword(Password))
{
ReturnDescription = "密码错误";
return(-2);
}
//if (!Shove._Convert.StrToBool(dt.Rows[0]["State"].ToString(), false))
if (dt.Rows[0]["State"].ToString() != "1")
{
ReturnDescription = "代理商帐号已经过期";
return(-2);
}
Name = dt.Rows[0]["Name"].ToString();
Password = dt.Rows[0]["Password"].ToString();
Company = dt.Rows[0]["Company"].ToString();
Url = dt.Rows[0]["Url"].ToString();
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
// 校验成功
SaveUserIDToCookie();
return(0);
}
public int GetInformationByID(ref string ReturnDescription)
{
if (ID < 0)
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString, "", "[ID] = " + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return(-1);
}
Name = dt.Rows[0]["Name"].ToString();
Password = dt.Rows[0]["Password"].ToString();
Company = dt.Rows[0]["Company"].ToString();
Url = dt.Rows[0]["Url"].ToString();
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
return(0);
}
public int GetInformationByName(ref string ReturnDescription)
{
if (Name == "")
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString, "", "[Name] = " + Shove._Web.Utility.FilteSqlInfusion(Name), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return(-1);
}
ID = Shove._Convert.StrToInt(dt.Rows[0]["ID"].ToString(), 0);
Password = dt.Rows[0]["Password"].ToString();
Company = dt.Rows[0]["Company"].ToString();
Url = dt.Rows[0]["Url"].ToString();
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
return(0);
}
public int GetInformationByID(ref string ReturnDescription)
{
if (ID < 0)
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString,"", "[ID] = " + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return -1;
}
Name = dt.Rows[0]["Name"].ToString();
Password = dt.Rows[0]["Password"].ToString();
Company = dt.Rows[0]["Company"].ToString();
Url = dt.Rows[0]["Url"].ToString();
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
return 0;
}
public int EditByID(ref string ReturnDescription)
{
if (ID < 0)
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString,"", "[ID] = " + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return -1;
}
SLS.Dal.Tables.T_CardPasswordAgents t_CardPasswordAgents = new SLS.Dal.Tables.T_CardPasswordAgents();
t_CardPasswordAgents.Company.Value = Company;
t_CardPasswordAgents.Password.Value = Password;
t_CardPasswordAgents.Name.Value = Name;
t_CardPasswordAgents.State.Value = State;
t_CardPasswordAgents.Url.Value = Url;
t_CardPasswordAgents.Update(PF.ConnectString,"[ID] = " + ID.ToString());
return 0;
}
public int GetInformationByName(ref string ReturnDescription)
{
if (Name == "")
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new SLS.Dal.Tables.T_CardPasswordAgents().Open(PF.ConnectString,"", "[Name] = " + Shove._Web.Utility.FilteSqlInfusion(Name), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return -1;
}
ID = Shove._Convert.StrToInt(dt.Rows[0]["ID"].ToString(), 0);
Password = dt.Rows[0]["Password"].ToString();
Company = dt.Rows[0]["Company"].ToString();
Url = dt.Rows[0]["Url"].ToString();
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
return 0;
}