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); }