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);
}
private void BindData()
{
DataTable dt = new DAL.Tables.T_CardPasswordAgents().Open("", "", "ID desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
PF.DataGridBindData(g, dt, gPager);
}
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 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 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);
}
// 错误码：
// -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);
}
