private void BindData()
{
DataTable dt = new DAL.Tables.T_CardPasswordAgents().Open("[ID], [Name]", "", "[ID]");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_CardPasswordAdd");
return;
}
Shove.ControlExt.FillDropDownList(ddlCardPasswordAgents, dt, "Name", "ID");
}
public int EditByID(ref string ReturnDescription)
{
if (this.ID < 0)
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable table = new Tables.T_CardPasswordAgents().Open("", "[ID] = " + this.ID, "");
if ((table == null) || (table.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return -1;
}
new Tables.T_CardPasswordAgents { Company = { Value = this.Company }, Password = { Value = this.Password }, Name = { Value = this.Name }, State = { Value = this.State }, Url = { Value = this.Url } }.Update("[ID] = " + this.ID.ToString());
return 0;
}
// 正常用户登录
public int Login(ref string ReturnDescription)
{
DataTable dt = new DAL.Tables.T_CardPasswordAgents().Open("", "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 DAL.Tables.T_CardPasswordAgents().Open("", "[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 DAL.Tables.T_CardPasswordAgents().Open("", "[ID] = " + ID, "");
if ((dt == null) || (dt.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return -1;
}
DAL.Tables.T_CardPasswordAgents t_CardPasswordAgents = new 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("[ID] = " + ID.ToString());
return 0;
}
public int GetInformationByName(ref string ReturnDescription)
{
if (Name == "")
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable dt = new DAL.Tables.T_CardPasswordAgents().Open("", "[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;
}
private int Valid(ref DataSet ReturnDS, ref short State, int AgentID, string TimeStamp, string Sign, params object[] Params)
{
DateTime time;
try
{
time = DateTime.Parse(TimeStamp);
}
catch
{
this.BuildReturnDataSetForError(-11, "时间戳格式错误", ref ReturnDS);
return -4;
}
State = 0;
TimeSpan span = (TimeSpan)(DateTime.Now - time);
if (Math.Abs(span.TotalSeconds) > 300.0)
{
this.BuildReturnDataSetForError(-2, "访问超时", ref ReturnDS);
return -2;
}
Thread.Sleep(200);
DataTable table = new Tables.T_CardPasswordAgents().Open("", "[ID] = " + AgentID.ToString(), "");
if (table == null)
{
this.BuildReturnDataSetForError(-9999, "未知错误", ref ReturnDS);
return -9999;
}
if (table.Rows.Count < 1)
{
this.BuildReturnDataSetForError(-1, "代理商ID错误", ref ReturnDS);
return -1;
}
string str = table.Rows[0]["IPAddressLimit"].ToString();
if ((str != "") && (("," + str + ",").IndexOf("," + this.GetClientIPAddress() + ",") < 0))
{
this.BuildReturnDataSetForError(-3, "IP地址限制", ref ReturnDS);
return -3;
}
string str2 = table.Rows[0]["Key"].ToString();
string str3 = AgentID.ToString() + TimeStamp;
foreach (object obj2 in Params)
{
str3 = str3 + this.ParamterToString(obj2);
}
if (Encrypt.MD5(str3 + str2).ToLower() != Sign.ToLower())
{
this.BuildReturnDataSetForError(-4, "签名校验失败", ref ReturnDS);
return -4;
}
State = _Convert.StrToShort(table.Rows[0]["State"].ToString(), 0);
return 0;
}
// 错误码：
// -1 代理商ID错误
// -2 访问超时
// -3 IP地址限制
// -4 签名失败
// -5 卡号不存在
// -6 卡号已经被使用
// -7 失效时间不能小于当前时间
// -8 参数不符合规定或者未提供
// -9 代理商被停用
// -10 卡号不存在、已失效、已被更换、已被使用
// -11 时间戳格式错误
// -9999 未知错误
// 校验 Sign, 代理商合法性, 时间戳
private int Valid(ref DataSet ReturnDS, ref short State, int AgentID, string TimeStamp, string Sign, params object[] Params)
{
DateTime t_DateTime;
try
{
t_DateTime = DateTime.Parse(TimeStamp);
}
catch
{
BuildReturnDataSetForError(-11, "时间戳格式错误", ref ReturnDS);
return -4;
}
State = 0;
TimeSpan ts = DateTime.Now - t_DateTime;
if (Math.Abs(ts.TotalSeconds) > 300)
{
BuildReturnDataSetForError(-2, "访问超时", ref ReturnDS);
return -2;
}
System.Threading.Thread.Sleep(200); //休眠 200 毫秒
DataTable dt = new DAL.Tables.T_CardPasswordAgents().Open("", "[ID] = " + AgentID.ToString(), "");
if (dt == null)
{
BuildReturnDataSetForError(-9999, "未知错误", ref ReturnDS);
return -9999;
}
if (dt.Rows.Count < 1)
{
BuildReturnDataSetForError(-1, "代理商ID错误", ref ReturnDS);
return -1;
}
string IPAddressLimit = dt.Rows[0]["IPAddressLimit"].ToString();
if (IPAddressLimit != "")
{
IPAddressLimit = "," + IPAddressLimit + ",";
if (IPAddressLimit.IndexOf("," + GetClientIPAddress() + ",") < 0)
{
BuildReturnDataSetForError(-3, "IP地址限制", ref ReturnDS);
return -3;
}
}
string Key = dt.Rows[0]["Key"].ToString();
string SignSource = AgentID.ToString() + TimeStamp;
foreach (object Param in Params)
{
SignSource += ParamterToString(Param);
}
SignSource += Key;
if (Shove._Security.Encrypt.MD5(SignSource).ToLower() != Sign.ToLower())
{
BuildReturnDataSetForError(-4, "签名校验失败", ref ReturnDS);
return -4;
}
State = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), 0);
return 0;
}
private void BindData()
{
DataTable dt = new Tables.T_CardPasswordAgents().Open("[ID], [Name]", "", "[ID]");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_CardPasswordAdd");
}
else
{
ControlExt.FillDropDownList(this.ddlCardPasswordAgents, dt, "Name", "ID");
}
}
public int GetInformationByID(ref string ReturnDescription)
{
if (this.ID < 0)
{
throw new Exception("CardPassword 尚未初始化到具体的数据实例上，请先使用 GetInformation 等获取数据信息");
}
DataTable table = new Tables.T_CardPasswordAgents().Open("", "[ID] = " + this.ID, "");
if ((table == null) || (table.Rows.Count < 1))
{
ReturnDescription = "数据库读写错误";
return -1;
}
this.Name = table.Rows[0]["Name"].ToString();
this.Password = table.Rows[0]["Password"].ToString();
this.Company = table.Rows[0]["Company"].ToString();
this.Url = table.Rows[0]["Url"].ToString();
this.State = _Convert.StrToShort(table.Rows[0]["State"].ToString(), 0);
return 0;
}
public int Login(ref string ReturnDescription)
{
DataTable table = new Tables.T_CardPasswordAgents().Open("", "ID=" + this.ID, "");
if ((table == null) || (table.Rows.Count < 1))
{
ReturnDescription = "用户不存在";
return -1;
}
if (table.Rows[0]["Password"].ToString() != PF.EncryptPassword(this.Password))
{
ReturnDescription = "密码错误";
return -2;
}
if (table.Rows[0]["State"].ToString() != "1")
{
ReturnDescription = "代理商帐号已经过期";
return -2;
}
this.Name = table.Rows[0]["Name"].ToString();
this.Password = table.Rows[0]["Password"].ToString();
this.Company = table.Rows[0]["Company"].ToString();
this.Url = table.Rows[0]["Url"].ToString();
this.State = _Convert.StrToShort(table.Rows[0]["State"].ToString(), 0);
this.SaveUserIDToCookie();
return 0;
}
