public List <Models.DbModels.app> GetList(XXF.Db.DbConn PubConn, int pno, int pagesize, string keywords, out int totalcount)
{
totalcount = 0;
List <Models.DbModels.app> listapp = new List <DbModels.app>();
string sql = string.Format(basesql, " ROW_NUMBER() over (order by appid) as rownum, appid,appname,appsecret,app.apptype,appgrade.appgradeno,appgrade.appgradename,appdesc,freeze ");;
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
string con = "";
if (!string.IsNullOrEmpty(keywords))
{
con = " and app.appid like '%' + @keywords + '%' or app.appname like '%' + @keywords + '%' or appname like '%' + @keywords + '%' ";
para.Add("@keywords", keywords);
sql = sql + con;
}
string querysql = string.Concat("select A.* from (", sql, ") A ", " where A.rownum between ", (pno - 1) * pagesize + 1, " and ", pno * pagesize);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, querysql, para.ToParameters());
foreach (DataRow dr in ds.Tables[0].Rows)
{
listapp.Add(FillModel(dr));
}
totalcount = (int)PubConn.ExecuteScalar(string.Format(basesql, " count(*) ") + con, para.ToParameters());
return(listapp);
}
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);
}
}
}
/// <summary>根据userid得到管理员工信息</summary>
public DbModels.manage getManage(XXF.Db.DbConn PubConn, string userid)
{
string sql = "select ygbh,ygmc,ygmm,ygzt,sfsc from tb_userinfo where ygbh=@userid";
DataSet ds = new DataSet();
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@userid", userid);
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count != 1)
{
return(null);
}
DbModels.manage model = new DbModels.manage();
model.userid = ds.Tables[0].Rows[0]["ygbh"].ToString();
model.id = model.userid;
model.username = ds.Tables[0].Rows[0]["ygmc"].ToString();
model.pwd = privateToDeDES(ds.Tables[0].Rows[0]["ygmm"].ToString());
model.freeze = Convert.ToInt32(ds.Tables[0].Rows[0]["sfsc"]);
if (model.freeze == 0)
{
model.freeze = 1;
}
else
{
model.freeze = 0;
}
return(model);
}
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 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 int AddApp(XXF.Db.DbConn PubConn, Models.DbModels.app model)
{
if (string.IsNullOrEmpty(model.appid))
{
model.appid = XXF.Db.LibString.MakeRandomNumber(16).ToLower();
}
if (ExitAppid(PubConn, model.appid))
{
return(-2);
}
if (string.IsNullOrEmpty(model.appsecret))
{
model.appsecret = Guid.NewGuid().ToString().Replace("-", "");
}
string sql = "insert into app(appid,appname,apptype,appgradeno,appsecret,appdesc,freeze) values(@appid,@appname,@apptype,@appgradeno,@appsecret,@appdesc,@freeze)";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@appid", model.appid);
para.Add("@appsecret", model.appsecret);
para.Add("@appname", model.appname);
para.Add("@apptype", model.apptype);
para.Add("@appgradeno", model.appgradeno);
para.Add("@freeze", model.freeze);
para.Add("@appdesc", model.appdesc ?? "");
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
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 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 int DeletApp(XXF.Db.DbConn PubConn, string appid)
{
string sql = "delete from app where appid=@appid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@appid", appid);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
public bool ExitAppid(XXF.Db.DbConn PubConn, string appid)
{
string sql = "select count(*) from app where appid=@appid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@appid", appid);
int r = (int)PubConn.ExecuteScalar(sql, para.ToParameters());
return(r == 1);
}
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 }));
}
}
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 int UpdateCategory(XXF.Db.DbConn PubConn, Models.DbModels.appcategory model)
{
model.categorydesc = model.categorydesc ?? "";
string sql = "update appcategory set categorytitle=@categorytitle,categorydesc=@categorydesc where apptype=@apptype and categoryid=@categoryid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@categoryid", model.categoryid);
para.Add("@categorytitle", model.categorytitle);
para.Add("@categorydesc", model.categorydesc);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
public int UpdateGrade(XXF.Db.DbConn PubConn, Models.DbModels.appgrade model)
{
model.appgradedesc = model.appgradedesc ?? "";
string sql = "update appgrade set appgradename=@appgradename,appgradedesc=@appgradedesc where apptype=@apptype and appgradeno=@appgradeno";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@appgradeno", model.appgradeno);
para.Add("@appgradename", model.appgradename);
para.Add("@appgradedesc", model.appgradedesc);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
//
// 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: /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));
}
}
//
// 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
public Models.DbModels.app GetAppInfo(XXF.Db.DbConn PubConn, string appid)
{
string sql = string.Format(basesql, " appid,appname,appsecret,app.apptype,appgrade.appgradeno,appgrade.appgradename,appdesc,freeze ");
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@appid", appid);
sql += " and appid=@appid";
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(FillModel(ds.Tables[0].Rows[0]));
}
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");
}
}
}
}
}
public int UpdateApp(XXF.Db.DbConn PubConn, Models.DbModels.app model)
{
string sql = "update app set appname=@appname,appsecret=@appsecret,appdesc=@appdesc ,freeze=@freeze ,apptype = @apptype,appgradeno =@appgradeno where appid=@appid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@appid", model.appid);
para.Add("@appsecret", model.appsecret);
para.Add("@appname", model.appname);
para.Add("@apptype", model.apptype);
para.Add("@appgradeno", model.appgradeno);
para.Add("@freeze", model.freeze);
para.Add("@appdesc", model.appdesc ?? "");
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
//
// 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 int AddGrade(XXF.Db.DbConn PubConn, Models.DbModels.appgrade model)
{
model.appgradedesc = model.appgradedesc ?? "";
string getcatid = "select isnull(max(appgradeno),0)+1 from appgrade where apptype=" + model.apptype;
model.appgradeno = Convert.ToInt32(PubConn.ExecuteScalar(getcatid, null));
string addsql = "insert into appgrade(apptype,appgradeno,appgradename,appgradedesc) values(@apptype,@appgradeno,@appgradename,@appgradedesc)";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@appgradeno", model.appgradeno);
para.Add("@appgradename", model.appgradename);
para.Add("@appgradedesc", model.appgradedesc);
int r = PubConn.ExecuteSql(addsql, para.ToParameters());
return(r);
}
public int Addcategory(XXF.Db.DbConn PubConn, Models.DbModels.appcategory model)
{
model.categorydesc = model.categorydesc ?? "";
string getcatid = "select isnull(max(categoryid),0)+1 from appcategory where apptype=" + model.apptype;
model.categoryid = Convert.ToInt32(PubConn.ExecuteScalar(getcatid, null));
string addsql = "insert into appcategory(apptype,categoryid,categorytitle,categorydesc) values(@apptype,@categoryid,@categorytitle,@categorydesc)";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", model.apptype);
para.Add("@categoryid", model.categoryid);
para.Add("@categorytitle", model.categorytitle);
para.Add("@categorydesc", model.categorydesc);
int r = PubConn.ExecuteSql(addsql, para.ToParameters());
return(r);
}
public int DeleteCategory(XXF.Db.DbConn PubConn, int apptype, int categoryid)
{
string countsql = " select COUNT(*) from gradepermission where apptype=" + apptype + " and categoryid=" + categoryid + "";
int c = (int)PubConn.ExecuteScalar(countsql, null);
if (c != 0)
{
return(-2);
}
string sql = "delete from appcategory where apptype=@apptype and categoryid=@categoryid";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", apptype);
para.Add("@categoryid", categoryid);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
public int DeleteGrade(XXF.Db.DbConn PubConn, int apptype, int appgradeno)
{
string countsql = " select COUNT(*) from api where apptype=" + apptype + " and appgradeno=" + appgradeno + "";
int c = (int)PubConn.ExecuteScalar(countsql, null);
if (c != 0)
{
return(-2);
}
string sql = "delete from appgrade where apptype=@apptype and appgradeno=@appgradeno";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", apptype);
para.Add("@appgradeno", appgradeno);
int r = PubConn.ExecuteSql(sql, para.ToParameters());
return(r);
}
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 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);
}
