public JsonResult DeleteApp(string id)
{
if (string.IsNullOrEmpty(id))
{
return(Json(new { code = -1, msg = "appid为能为空。" }));
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
try
{
int r = Models.AppDal.Instance.DeletApp(PubConn, id);
if (r == 0)
{
return(Json(new { code = -1, msg = "appid [" + id + "]不存在或已被删除" }));
}
return(Json(new { code = 1 }));
}
finally
{
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "删除应用。";
Models.CertCenterLogDal.Instance.Add(PubConn, log);
}
}
}
public JsonResult Delete(int apptype, int categoryid)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
int r = Models.AppcategoryDal.Instance.DeleteCategory(PubConn, apptype, categoryid);
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "删除应用分类,操作结果：" + r;
Models.CertCenterLogDal.Instance.Add(PubConn, log);
if (r > 0)
{
return(Json(new { code = 1 }));
}
else
{
if (r == -2)
{
return(Json(new { code = -2, msg = "此分类下存在接口，无法删除。" }));
}
else
{
return(Json(new { code = -1, msg = "删除失败，不存在或已被删除" }));
}
}
}
}
public JsonResult GetAppGradeData(string id, string lv, string n)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
List <Models.Z_TreeModel> ztree = new List <Models.Z_TreeModel>();
PubConn.Open();
for (int i = 0; i <= 2; i++)
{
Models.Z_TreeModel tempnode = new Models.Z_TreeModel();
tempnode.name = Models.CertCenterComm.APPTYPENAME[i];
tempnode.iconSkin = "";
tempnode.open = "true";
tempnode.id = i.ToString();
List <Models.DbModels.appgrade> tempgrade = Models.AppGradeDal.Instance.GetGrades(PubConn, i);
tempnode.children = new List <Models.Z_TreeModel>();
foreach (var a in tempgrade)
{
tempnode.children.Add(new Models.Z_TreeModel()
{
id = i + "_" + a.appgradeno.ToString(), name = a.appgradename
});
}
tempnode.isParent = tempnode.children.Count == 0 ? "false" : "true";
ztree.Add(tempnode);
}
return(Json(ztree));
}
}
public JsonResult GetApiCategoryData(string id, string lv, string n)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
List <Models.Z_TreeModel> ztree = new List <Models.Z_TreeModel>();
PubConn.Open();
for (int i = 0; i <= 2; i++)
{
Models.Z_TreeModel tempnode = new Models.Z_TreeModel();
tempnode.name = Models.CertCenterComm.APPTYPENAME[i];
tempnode.iconSkin = "";
tempnode.id = i.ToString();
tempnode.open = "true";
List <Models.DbModels.appcategory> tempgrade = Models.AppcategoryDal.Instance.GetAppTypeCategorys(PubConn, i);
tempnode.children = new List <Models.Z_TreeModel>();
foreach (var a in tempgrade)
{
tempnode.children.Add(new Models.Z_TreeModel()
{
id = i + "_" + a.categoryid.ToString(), name = a.categorytitle
});
}
tempnode.isParent = tempnode.children.Count == 0 ? "false" : "true";
ztree.Add(tempnode);
}
//Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
//log.opecontent = "得到分类数据据";
//Models.CertCenterLogDal.Instance.Add(PubConn, log);
return(Json(ztree));
}
}
public ActionResult GetApiList(int apptype = 0, int categoryid = 1)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
List <Models.DbModels.api> listapi = Models.ApiDal.Instance.GetCategoryApis(PubConn, apptype, categoryid);
return(Json(new { code = 1, response = listapi }));
}
}
public JsonResult UseApptypeGetcategories(int apptype)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
List <Models.DbModels.appcategory> grades = Models.AppcategoryDal.Instance.GetAppTypeCategorys(PubConn, apptype);
return(Json(new { code = 1, response = grades }));
}
}
public JsonResult GetAppGradeInfo(int apptype, int appgradeno)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.appgrade model = Models.AppGradeDal.Instance.GetGradeInfo(PubConn, apptype, appgradeno);
if (model == null)
{
return(Json(new { code = -1, msg = "不存在此等级信息。" }));
}
return(Json(new { code = 1, response = model }));
}
}
public JsonResult apidetails(int id)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.api model = Models.ApiDal.Instance.Get(PubConn, id);
if (model == null)
{
return(Json(new { code = -1, msg = "不存在编号为 [" + id + "] 的接口。" }));
}
return(Json(new { code = 1, response = model }));
}
}
//
// GET: /Api/
public ActionResult Index()
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Dictionary <string, List <Models.DbModels.appcategory> > apis = new Dictionary <string, List <Models.DbModels.appcategory> >();
for (int i = 0; i <= 2; i++)
{
List <Models.DbModels.appcategory> tempcategory = Models.AppcategoryDal.Instance.GetAppTypeCategorys(PubConn, i);
apis.Add(Models.CertCenterComm.APPTYPENAME[i], tempcategory);
}
return(View(apis));
}
}
public JsonResult Edit(Models.DbModels.appcategory model)
{
if (string.IsNullOrEmpty(model.categorytitle))
{
return(Json(new { code = -1, msg = "分类名称不能为空" }));
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
try
{
if (model.categoryid < 1)//添加
{
int r = Models.AppcategoryDal.Instance.Addcategory(PubConn, model);
if (r > 0)
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "新增失败，原因不明" }));
}
}
else//修改
{
int r = Models.AppcategoryDal.Instance.UpdateCategory(PubConn, model);
if (r > 0)
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "修改失败，原因不明" }));
}
}
}
catch (Exception ex)
{
return(Json(new { code = -1, msg = ex.Message }));
}
finally
{
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "修改应用分类";
Models.CertCenterLogDal.Instance.Add(PubConn, log);
}
}
}
public JsonResult deleteapi(int id)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
bool r = Models.ApiDal.Instance.Delete(PubConn, id);
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "删除接口,操作结果：" + r;
Models.CertCenterLogDal.Instance.Add(PubConn, log);
if (r)
{
return(Json(new { code = 1 }));
}
return(Json(new { code = -1, msg = "不存在编号为 [" + id + "] 的接口或已被删除。" }));
}
}
//
// GET: /WorkLog/
public ActionResult Index(int pno = 1, string keywords = "")
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
int pagesize = 10;
int totalcount = 0;
List <Models.DbModels.certcenterlog> listtoken = Models.CertCenterLogDal.Instance.GetPage(PubConn, pno, pagesize, keywords, out totalcount);
Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.certcenterlog> pager = new Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.certcenterlog>(listtoken, pno, pagesize, totalcount);
if (Request.IsAjaxRequest())
{
return(PartialView("List", pager));
}
return(View(pager));
}
}
//
// GET: /Toekn/
public ActionResult Index(int pno = 1, string keywords = "", Models.DbModels.TokenType tokentype = Models.DbModels.TokenType.usertoken)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
int pagesize = 10;
int totalcount = 0;
List <Models.DbModels.tb_token> listtoken = Models.TokenDal.Instance.GetByPage(PubConn, pno, pagesize, keywords, tokentype, out totalcount);
Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.tb_token> pager = new Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.tb_token>(listtoken, pno, pagesize, totalcount);
if (Request.IsAjaxRequest())
{
return(PartialView("List", pager));
}
return(View(pager));
}
}
private void Init(object obj)
{
int[] para = obj == null ? new int[] { 1, 1 } : (int[])obj;
using (XXF.Db.DbConn dbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "cert_test_main", "sa", "Xx~!@#"))
{
dbconn.Open();
string sql_count = "select count(1) from tb_customer";
int allcount = 40000;// (int)dbconn.ExecuteScalar(sql_count, null);
int threadsizecount = (int)Math.Ceiling(allcount / (double)para[1]);
int pagesize = 1000;
int start = (para[0]) * threadsizecount;
int end = (para[0] + 1) * threadsizecount;
for (int i = start; i < end; i = i + pagesize)
{
string sql = "select top " + pagesize + " * from (select row_number() over(order by f_id) as Rownum,* from tb_customer ) A where A.Rownum between " + (i + 1) + " and " + (end) + "";
DataTable tb = dbconn.SqlToDataTable(sql, null);
foreach (DataRow dr in tb.Rows)
{
count_me[para[0]]++;
string pwd = dr["f_dlmm"].ToString();
try
{
pwd = XXF.Db.LibCrypto.DeDES(pwd);
}
catch (Exception ex)
{
}
var token = sp.Login(dr["f_yhzh"].ToString(), pwd);
if (token != null)
{
lock (tokens)
tokens.Add(token);
Console.WriteLine(token.token);
}
else
{
Console.WriteLine("error");
}
}
}
}
}
//
// GET: /App/
public ActionResult Index(int pno = 1, string keywords = "")
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
int pagesize = 10;
int totalcount = 10;
pno = pno < 1 ? 1 : pno;
List <Models.DbModels.app> listapp = Models.AppDal.Instance.GetList(PubConn, pno, pagesize, keywords, out totalcount);
Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.app> pager = new Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.app>(listapp, pno, pagesize, totalcount);
if (Request.IsAjaxRequest())
{
return(PartialView("List", pager));
}
return(View(pager));
}
}
public ActionResult GetAppSecret(Controller controller)
{
JsonResult jsonr = new JsonResult();
jsonr.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
CertComm.ServerResult r = new CertComm.ServerResult();
jsonr.Data = r;
string appid = controller.Request["appid"];
if (string.IsNullOrEmpty(appid))
{
r.code = -3;
r.msg = "请求参数appid不能为空";
return(jsonr);
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();//打开基本
bool ex = CertCenter.Models.AppDal.Instance.ExitAppid(PubConn, appid);
if (!ex)
{
r.code = -1;
r.msg = "appid不存在";
return(jsonr);
}
CertCenter.Models.DbModels.app app = CertCenter.Models.AppDal.Instance.GetAppInfo(PubConn, appid);
if (app == null)
{
r.code = -1;
r.msg = "appid不存在";
return(jsonr);
}
else
{
r.code = 1;
r.msg = "OK";
r.response = app.appsecret;
return(jsonr);
}
}
return(jsonr);
}
public JsonResult edit(Models.DbModels.api model)
{
if (string.IsNullOrEmpty(model.apititle))
{
return(Json(new { code = -1, msg = "请输入接口标题" }));
}
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
try
{
if (model.apiid == 0)
{
if (Models.ApiDal.Instance.Add(PubConn, model))
{
model.apiid = PubConn.GetIdentity();
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "添加失败" }));
}
}
else
{
if (Models.ApiDal.Instance.Edit(PubConn, model))
{
return(Json(new { code = 1, response = model }));
}
else
{
return(Json(new { code = -1, msg = "修改失败" }));
}
}
}
finally
{
log.opecontent = "修改接口";
Models.CertCenterLogDal.Instance.Add(PubConn, log);
}
}
}
public JsonResult DeleteLog(int id)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
bool r = Models.CertCenterLogDal.Instance.Delete(PubConn, id);
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "删除操作日志。结果：" + r;
Models.CertCenterLogDal.Instance.Add(PubConn, log);
if (r)
{
return(Json(new { code = 1 }));
}
else
{
return(Json(new { code = -1, msg = "删除失败，日志不存在或存已被删除。" }));
}
}
}
public ActionResult Edit(string id)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
if (string.IsNullOrEmpty(id))
{
ViewBag.appgrades = Models.AppGradeDal.Instance.GetGrades(PubConn, 0);
return(View());
}
else
{
ViewBag.act = "edit";
Models.DbModels.app model = Models.AppDal.Instance.GetAppInfo(PubConn, id);
ViewBag.appgrades = Models.AppGradeDal.Instance.GetGrades(PubConn, model.apptype);
return(View(model));
}
}
}
private void WriteTestUserToDB()
{
using (XXF.Db.DbConn qxdbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "cert_test_main", "sa", "Xx~!@#"))
{
qxdbconn.Open();
StringBuilder sb = new StringBuilder();
int pagesize = 1000;
int i = 0;
while (i < willtestusers.Count)
{
sb.Clear();
for (int j = 0; j < pagesize && i < willtestusers.Count; j++)
{
sb.AppendFormat("insert into testuser(f_yhzh) values('{0}');\r\n", willtestusers[i]);
i++;
}
qxdbconn.ExecuteSql(sb.ToString(), null);
}
}
}
private void Do()
{
using (XXF.Db.DbConn pubconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "cert_test_main", "sa", "Xx~!@#"))
{
pubconn.Open();
long curr_uid = start_userid;
StringBuilder sb = new StringBuilder();
while (currcount < count)
{
sb.Clear();
for (int i = 0; i < 1000; i++)
{
sb.AppendFormat("insert into tb_customer(f_yhzh,f_yhxm,f_dlmm,f_sfdj) values('{0}','{1}','{2}',0);\r\n", curr_uid, "yhm_" + curr_uid, pwd);
curr_uid++;
currcount++;
}
pubconn.ExecuteSql(sb.ToString(), null);
}
}
}
public JsonResult GetApiCategoryInfo(int apptype, int categoryid)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.appcategory model = Models.AppcategoryDal.Instance.GetCategoryInfo(PubConn, apptype, categoryid);
if (model == null)
{
return(Json(new CertComm.ServerResult()
{
code = -1, msg = "无查项"
}));
}
return(Json(new CertComm.ServerResult()
{
code = 1, msg = "", response = model
}));
}
}
public JsonResult deletetoken(string id, Models.DbModels.TokenType tokentype)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
bool r = Models.TokenDal.Instance.Delete(PubConn, id, tokentype);
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "删除token。tokentype=" + tokentype.ToString() + " result=" + r;
Models.CertCenterLogDal.Instance.Add(PubConn, log);
if (r)
{
return(Json(new { code = 1 }));
}
else
{
return(Json(new { code = -905, msg = "删除失败，token不存在或存已被删除。" }));
}
}
}
private void Init(object obj)
{
int[] para = obj == null ? new int[] { 1, 1 } : (int[])obj;
using (XXF.Db.DbConn dbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "cert_test_main", "sa", "Xx~!@#"))
using (XXF.Db.DbConn qxdbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "dyd_new_qx", "sa", "Xx~!@#"))
{
dbconn.Open();
qxdbconn.Open();
int allcount = 1200000;// (int)dbconn.ExecuteScalar(sql_count, null);
int threadsizecount = (int)Math.Ceiling(allcount / (double)para[1]);
int pagesize = 200;
int start = (para[0]) * threadsizecount;
int end = (para[0] + 1) * threadsizecount;
StringBuilder sb = new StringBuilder();
for (int i = start; i < end; i = i + pagesize)
{
sb.Clear();
string sql = "select top " + pagesize + " * from (select row_number() over(order by f_id) as Rownum,* from tb_customer ) A where A.Rownum between " + (i + 1) + " and " + (end) + "";
DataTable tb = dbconn.SqlToDataTable(sql, null);
foreach (DataRow dr in tb.Rows)
{
count_me[para[0]]++;
string pwd = dr["f_dlmm"].ToString();
string yhzh = dr["f_yhzh"].ToString();
string id = dr["f_id"].ToString();
string yhxm = dr["f_yhxm"].ToString();
string token = Guid.NewGuid().ToString().Replace("-", "");
sb.AppendFormat("insert into usertoken (token,userid,id,username,appid,createtime,expires) " +
" values('{0}','{1}','{2}','{3}','Customer','2015-07-01','2015-08-31');\r\n", token, yhzh, id, yhxm);
}
qxdbconn.ExecuteSql(sb.ToString(), null);
}
}
}
public ActionResult Login(string appid, string returnurl)
{
if (!string.IsNullOrEmpty(appid))
{
using (XXF.Db.DbConn pubconn = XXF.Db.DbConfig.CreateConn())
{
pubconn.Open();
string constr = CertCenter.Areas.CertApi.Models.ApiCommDal.GetConnStr(Models.DbModels.TokenType.managetoken);
if (!string.IsNullOrEmpty(appid))
{
CertCenter.Models.DbModels.app app = CertCenter.Models.AppDal.Instance.GetAppInfo(pubconn, appid);
if (app == null)
{
ViewBag.msg = "应用不存在";
}
else
{
ViewBag.appname = app.appname;
}
}
}
}
return(View());
}
public ActionResult Edit(Models.DbModels.app model, string act)
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
ViewBag.appgrades = Models.AppGradeDal.Instance.GetGrades(PubConn, model.apptype);
ViewBag.act = act;
if (string.IsNullOrEmpty(model.appname))
{
ModelState.AddModelError("appname", "应用名不能为空。");
return(View(model));
}
if (model.appgradeno <= 0)
{
ModelState.AddModelError("appgradeno", "请选择应用级别。");
return(View(model));
}
try
{
if (string.IsNullOrEmpty(model.appid))
{
model.appid = XXF.Db.LibString.MakeRandomNumber(16);
}
if (string.IsNullOrEmpty(model.appsecret))
{
model.appsecret = Guid.NewGuid().ToString().Replace("-", "");
}
if (act == "edit")
{
int r = Models.AppDal.Instance.UpdateApp(PubConn, model);
if (r > 0)
{
return(RedirectToAction("index"));
}
else
{
ViewBag.act = "edit";
return(View(model));
}
}
else
{
int r = Models.AppDal.Instance.AddApp(PubConn, model);
if (r > 0)
{
return(RedirectToAction("index"));
}
else
{
if (r == -1)
{
ModelState.AddModelError("appid", "appid已存在，请更换");
}
return(View(model));
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
return(View(model));
}
finally
{
Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this);
log.opecontent = "修改应用";
Models.CertCenterLogDal.Instance.Add(PubConn, log);
}
}
}
public ActionResult Login(string userid, string pwd, string returnurl, string appid)
{
XXF.Db.DbConn pubconn = null;
XXF.Db.DbConn dbconn = null;
try
{
pubconn = XXF.Db.DbConfig.CreateConn();
pubconn.Open();
ViewBag.userid = userid;
ViewBag.pwd = pwd;
string constr = CertCenter.Areas.CertApi.Models.ApiCommDal.GetConnStr(Models.DbModels.TokenType.managetoken);
if (!string.IsNullOrEmpty(appid))
{
CertCenter.Models.DbModels.app app = CertCenter.Models.AppDal.Instance.GetAppInfo(pubconn, appid);
if (app == null)
{
ViewBag.msg = "应用不存在";
return(View());
}
}
dbconn = XXF.Db.DbConfig.CreateConn(constr);
dbconn.Open();
Models.DbModels.manage model = Models.AccountDal.Instance.getManage(dbconn, userid);
if (model == null)
{
ViewBag.msg = "用户名不存在";
return(View());
}
if (model.freeze == 1)
{
ViewBag.msg = "用户已被冻结";
return(View());
}
if (pwd != model.pwd)
{
ViewBag.msg = "密码不正确";
return(View());
}
//if (string.IsNullOrEmpty(appid))
//{
FormsAuthentication.SetAuthCookie(userid + " " + model.username, false);
return(RedirectToAction("Index", "Home"));
//}
//else
//{
// if (returnurl.Contains("?")&&returnurl.Contains("&"))
// {
// returnurl = returnurl + "&token="+;
// }
// return Redirect(returnurl);
//}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (pubconn != null)
{
pubconn.Dispose();
}
if (dbconn != null)
{
dbconn.Dispose();
}
}
}
private void PrepareTokens(int allcount)
{
Console.WriteLine("正在准备内存token...");
Thread mainthrad = new Thread(() =>
{
using (XXF.Db.DbConn qxdbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "dyd_new_qx", "sa", "Xx~!@#"))
{
qxdbconn.Open();
// int allcount = 999000;// (int)dbconn.ExecuteScalar(sql_count, null);
int pagesize = 200000;
StringBuilder sb = new StringBuilder();
int i = 0;
while (true)
{
sb.Clear();
string sql = "select * from (select row_number() over(order by token) as Rownum,* from usertoken ) A where A.Rownum between " + (i + 1) + " and " + (i + pagesize) + "";
DataTable tb = qxdbconn.SqlToDataTable(sql, null);
foreach (DataRow dr in tb.Rows)
{
sp.Add(new CertSdk.Token()
{
appid = dr["appid"].ToString(),
createtime = XXF.Db.LibConvert.ObjToDateTime(dr["createtime"]),
expires = XXF.Db.LibConvert.ObjToDateTime(dr["expires"]),
id = dr["id"].ToString(),
token = dr["token"].ToString(),
userid = dr["userid"].ToString(),
username = dr["username"].ToString()
});
_PrepareTokens_count++;
if (_PrepareTokens_count >= allcount)
{
break;
}
}
if (_PrepareTokens_count >= allcount)
{
break;
}
}
}
});
Thread m = new Thread(() =>
{
while (true)
{
Thread.Sleep(3000);
Console.WriteLine("当前准备token总数={0}", _PrepareTokens_count);
if (mainthrad.ThreadState == System.Threading.ThreadState.Stopped)
{
return;
}
}
});
mainthrad.Start();
m.Start();
m.Join();
Console.WriteLine("准备内存token完成！");
}
private void GetTestUsers(int count)
{
Console.WriteLine("正在准备登录用户...");
Thread maint = new Thread(() =>
{
using (XXF.Db.DbConn qxdbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "cert_test_main", "sa", "Xx~!@#"))
{
qxdbconn.Open();
int allcount = (int)qxdbconn.ExecuteScalar("select count(1) from testuser", null);
if (allcount >= count)
{
string sql = "select top " + count + " * from testuser";
DataTable tb = qxdbconn.SqlToDataTable(sql, null);
foreach (DataRow dr in tb.Rows)
{
willtestusers.Add(dr["f_yhzh"].ToString());
_GetTestUsers_count++;
}
return;
}
}
int pagesize = 50;
using (XXF.Db.DbConn qxdbconn = XXF.Db.DbConn.CreateConn(XXF.Db.DbType.SQLSERVER, "192.168.17.236", "cert_test_main", "sa", "Xx~!@#"))
{
qxdbconn.Open();
int allcount = (int)qxdbconn.ExecuteScalar("select count(1) from tb_customer", null);
for (int i = 0; i < count; i = i + pagesize)
{
Random r = new Random();
int start_index = r.Next(1, allcount - pagesize);
string sql = "select top " + pagesize + " A.f_yhzh from (select row_number() over(order by f_id) as Rownum,f_yhzh from tb_customer ) A where A.Rownum >=" + start_index + "";
DataTable tb = qxdbconn.SqlToDataTable(sql, null);
foreach (DataRow dr in tb.Rows)
{
willtestusers.Add(dr["f_yhzh"].ToString());
_GetTestUsers_count++;
}
}
}
WriteTestUserToDB();
});
Thread m = new Thread(() =>
{
while (true)
{
Thread.Sleep(3000);
Console.WriteLine("当前准备测试用户总数={0}", _GetTestUsers_count);
if (maint.ThreadState == System.Threading.ThreadState.Stopped)
{
return;
}
}
});
maint.Start();
m.Start();
m.Join();
Console.WriteLine("准备登录用户完成！");
}
public static JsonResult Visit(Func <XXF.Db.DbConn, object> action, Controller controller)
{
//msgs.Add(-100, "认证失败");
//msgs.Add(-905, "token不存在或已过期");
//msgs.Add(-102, "请求超时");
//msgs.Add(-103, " sign不正确");
//msgs.Add(-104, "无权操作该接口");
//msgs.Add(-105, "接口已被冻结");
//msgs.Add(-106, "应用被冻结");
//msgs.Add(-111, "参数不完整");
//msgs.Add(-112, "用户不存在");
//msgs.Add(-113, "pwd不正确");
//msgs.Add(-114, "用户被冻结");
CertComm.ServerResult sr = new CertComm.ServerResult();
Dictionary <string, string> para = GetRequestPara(controller);
if (para.ContainsKey("appid") && string.IsNullOrEmpty(para["appid"]))
{
sr.code = -111;
sr.msg = "appid不能为空";
}
else if (para.ContainsKey("timespan") && string.IsNullOrEmpty(para["timespan"]))
{
sr.code = -111;
sr.msg = "timespan不能为空";
}
else if (para.ContainsKey("sign") && string.IsNullOrEmpty(para["sign"]))
{
sr.code = -111;
sr.msg = "sign不能为空";
}
else if (para.ContainsKey("userid") && string.IsNullOrEmpty(para["userid"]))
{
sr.code = -111;
sr.msg = "userid不能为空";
}
else if (para.ContainsKey("pwd") && string.IsNullOrEmpty(para["pwd"]))
{
sr.code = -111;
sr.msg = "pwd不能为空";
}
else
{
if (!CertComm.Authcomm.TestTimeSpanOk(para["timespan"], 10 * 60))
{
sr.code = -102;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
else
{
using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn())
{
PubConn.Open();
Models.DbModels.app appitem = Models.AppDal.Instance.GetAppInfo(PubConn, para["appid"]);
if (appitem == null)
{
sr.code = -103;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
else if (appitem.freeze == 1)
{
sr.code = -107;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
else
{
string nowsign = CertComm.Authcomm.ToSign(para, appitem.appsecret);
if (nowsign.ToLower() != para["sign"].ToLower())
{
sr.code = -104;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
else//用户相关验证
{
Models.DbModels.manage manager = Models.AccountDal.Instance.getManage(PubConn, para["userid"]);
if (manager == null)
{
sr.code = -112;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
else if (manager.freeze == 1)
{
sr.code = -114;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
else if (CertComm.Authcomm.ToMD5String(manager.pwd) != para["pwd"])
{
sr.code = -113;
sr.msg = AUTH_CODE_MSG.Get(sr.code);
}
}
}
}
}
}
if (sr.code < -100)
{
return(new JsonResult()
{
Data = sr
});
}
return(null);
}
