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 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 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 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 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); }
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("准备登录用户完成!"); }