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