protected void Page_Load(object sender, EventArgs e)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
//真实姓名
var userName = Request.Params["UserName"];
//身份证号
var identityCard = Request.Params["IdentityCard"];
try
{
if (codeUser == null || userName == null || identityCard == null)
{
string warning = string.Format("参数CodeUser，UserName，IdentityCard不能为nul！举例：http://218.92.115.55/M_Sph/Auth/AuthForConsignor.aspx?CodeUser=1DA60DDD8025725AE053A864016A725A&UserName=张三&IdentityCard=111111111111111111");
Json = JsonConvert.SerializeObject(new DicPackage(warning).FalseDic());
return;
}
//身份证验证
if (!TokenTool.CheckIDCard(identityCard))
{
Json = JsonConvert.SerializeObject(new DicPackage("身份证号码错误！").FalseDic());
return;
}
string strSql =
string.Format("select authstate from TB_SPH_USER_AUTH where code_user='******' and roletype='{1}'", codeUser, 2);
//验证此会员是否已认证
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
//添加认证数据
strSql =
string.Format("insert into TB_SPH_USER_AUTH (code_user,username,identity_card,roletype,authstate) values('{0}','{1}','{2}','{3}','{4}')", codeUser, userName, identityCard, "2", "0");
}
else
{
//更新认证数据
strSql =
string.Format("update TB_SPH_USER_AUTH set username='******',identity_card='{1}',authstate='{2}',operatetime=to_date('{3}','YYYY-MM-DD HH24:MI:SS') where code_user='******' and roletype={5}", userName, identityCard, "1", DateTime.Now, codeUser, 2);
}
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(strSql);
//检查数据是否插入/更新成功
strSql =
string.Format("select * from TB_SPH_USER_AUTH where code_user='******' and roletype='{1}'", codeUser, "2");
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage("认证失败，请稍后重试！").FalseDic());
}
else
{
Json = JsonConvert.SerializeObject(new DicPackage("审核中，请耐心等待！").TrueDic());
}
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(string.Format("{0}：认证数据发生异常。{1}", ex.Source, ex.Message)).FalseDic());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
//真实姓名
var userName = Request.Params["UserName"];
//身份证号
var identityCard = Request.Params["IdentityCard"];
//车牌号
var vehicleNum = Request.Params["VehicleNum"];
//车长
var vehicleLen = Request.Params["VehicleLen"];
//车型
var vehicleType = Request.Params["VehicleType"];
//载重吨
var tons = Request.Params["Tons"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (codeUser == null || userName == null || identityCard == null || vehicleNum == null || vehicleLen == null || vehicleType == null || tons == null)
{
info.Add("参数CodeUser，UserName，IdentityCard，VehicleNum，VehicleLen，VehicleType，Tons不能为空！举例", "http://218.92.115.55/M_Sph/Auth/AuthForDriver.aspx?CodeUser=1DA60DDD8025725AE053A864016A725A&UserName=张三&IdentityCard=111111111111111111&VehicleNum=&VehicleLen=&VehicleType=&Tons=");
Json = JsonConvert.SerializeObject(info);
return;
}
//身份证验证
if (!TokenTool.CheckIDCard(identityCard))
{
info.Add("IsAuth", "No");
info.Add("Message", "身份证号码错误！");
Json = JsonConvert.SerializeObject(info);
return;
}
string sql =
string.Format("select * from TB_SPH_USER_AUTH where code_user='******' and roletype='{1}'", codeUser, "1");
//验证此会员是否已认证
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
//添加认证数据
sql =
string.Format("insert into TB_SPH_USER_AUTH (code_user,username,identity_card,roletype,authstate,vehiclenum,vehiclelen,vehicletype,tons) values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}',{8})", codeUser, userName, identityCard, "1", "0", vehicleNum, Convert.ToDecimal(vehicleLen), vehicleType, Convert.ToDecimal(tons));
}
else
{
//更新认证数据
sql =
string.Format("update TB_SPH_USER_AUTH set username='******',identity_card='{1}',authstate='{2}',operatetime=to_date('{3}','YYYY-MM-DD HH24:MI:SS'),vehiclenum='{4}',vehiclelen={5},vehicletype='{6}',tons={7} where code_user='******' and roletype='{9}'", userName, identityCard, "0", DateTime.Now, vehicleNum, Convert.ToDecimal(vehicleLen), vehicleType, Convert.ToDecimal(tons), codeUser, "1");
}
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
//检查数据是否插入成功
sql =
string.Format("select * from TB_SPH_USER_AUTH where code_user='******' and roletype='{1}'", codeUser, "1");
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsAuth", "No");
info.Add("Message", "网络错误，请稍后再试！");
Json = JsonConvert.SerializeObject(info);
return;
}
////添加初始账户资金信息(在首次认证时添加会员初始化账户资金信息)
//sql =
// string.Format("select * from TB_YGPH_FUND where account='{0}' and roletype='{1}'", account, "1");
////验证此会员是否已初始化账户信息
//dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHmw).ExecuteTable(sql);
//if (dt.Rows.Count == 0)
//{
// sql =
// string.Format("insert into TB_YGPH_FUND (account,roletype,income,balance,content,dealtime) values('{0}','{1}','{2}','{3}','{4}',to_date('{5}','YYYY-MM-DD HH24:MI:SS'))", account, "1", "0", "0", "开户", DateTime.Now);
// dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHmw).ExecuteTable(sql);
//}
//sql =
// string.Format("select * from TB_YGPH_FUND where account='{0}' and roletype='{1}'", account, "1");
//dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHmw).ExecuteTable(sql);
//if (dt.Rows.Count == 0)
//{
// info.Add("IsAuth", "No");
// info.Add("Message", "网络错误，请稍后再试！");
// Json = JsonConvert.SerializeObject(info);
// return;
//}
info.Add("IsAuth", "Yes");
info.Add("Message", "审核中，请耐心等待！");
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsAuth", "No");
info.Add("Message", string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message));
Json = JsonConvert.SerializeObject(info);
}
}