public IActionResult GetTestByID(int test_id)
{
TestBll testBll = new TestBll();
var testData = testBll.GetTestByID(test_id);
return(Json(testData));
}
public JsonResult GetStuData(List <FromParm> fromParm, int page = 1, int pageSize = 5)
{
try
{
StringBuilder DBWhere = new StringBuilder();
if (fromParm != null)
{
foreach (FromParm item in fromParm)
{
if (item.value != null || item.value != "")
{
DBWhere.AppendFormat(" and {0}='{1}'", item.name, item.value);
}
}
}
string whereStr = DBWhere.ToString();// 后续SQL查询条件
TestBll bll = new TestBll();
List <Student> stuList = bll.StuList;
int count = stuList.Count;
stuList = stuList.OrderByDescending(s => s.ID).Skip((page - 1) * pageSize).Take(pageSize).ToList();
vr.BS = 1;
vr.Msg = "成功";
vr.count = count;
vr.rows = stuList;
}
catch (Exception ex)
{
vr.BS = -99;
vr.Msg = "异常" + ex.Message;
}
return(Json(vr, JsonRequestBehavior.AllowGet));
}
public IActionResult Update(TestModel dto)
{
TestBll testBll = new TestBll();
bool result = testBll.TestUpdate(dto);
if (result)
{
return(Content("OK"));
}
else
{
return(Content("NO"));
}
}
public IActionResult Add(TestModel model)
{
TestBll testBll = new TestBll();
bool result = testBll.TestAdd(model);
if (result)
{
return(Content("OK"));
}
else
{
return(Content("NO"));
}
}
public IActionResult Del(List <int> ids)
{
TestBll testBll = new TestBll();
List <int> list = ids;
bool result = testBll.TestDel("tb_test", list[0].ToString());
if (result)
{
return(Content("OK"));
}
else
{
return(Content("NO"));
}
}
public IActionResult GetTest(int limit = 10, int offset = 0, string sqlwhere = "")
{
TestBll testBll = new TestBll();
int rowCount = 0;
var data = testBll.DapperGetTest <TestModel>("tb_test", sqlwhere, out rowCount, limit, offset);
//DataTable data = testBll.GetTest("tb_test", sqlwhere, out rowCount, limit, offset);
//DataTable data = MySqlHelper1.GetDataTable("select * from tbtest");
//for (int i = 0; i < data.Rows.Count; i++)
//{
// for (int j = 0; j < data.Columns.Count; j++)
// {
// Console.WriteLine(data.Rows[i][j].ToString());
// }
//}
return(Json(new { total = rowCount, rows = data }));
}
static void Main(string[] args)
{
TestBll bll = new TestBll(ConfigurationManager.ConnectionStrings["mysqlConnection"].ConnectionString);
IEnumerable <Table1Model> aa = bll.Table1GetAll(1, 10);
Table1Model model = new Table1Model
{
ActionDate = DateTime.Now,
Title = "test333- edit",
Id = 3
};
bll.Table1Update(model);
aa = bll.Table1GetAll(1, 10);
}
public ActionResult Index()
{
ViewData["smallImg"] = AdvertisementBll.GetAllTypeAdvert("2", 9);
ViewData["advert"] = AdvertisementBll.GetAllTypeAdvert("3", 2);
ViewBag.IndexBigImg = AdvertisementBll.GetAllTypeAdvert("1", 1);
ViewBag.SiYe = AdvertisementBll.GetAllTypeAdvert("4", 1);
ViewData["recGame"] = HomePageBll.GetAllTypeHomePage("11", 11);
ViewData["joinCpy"] = HomePageBll.GetAllTypeHomePage("12", 13);
ViewData["SlideShow"] = HomePageBll.GetAllTypeHomePage("7", 10);
ViewData["TenTopArea"] = HomePageBll.GetAllTypeHomePage("10", 10);
//网站首页所有新闻类型
ViewData["allTypeNews"] = NewsBll.GetAllNewsIndex();
//开测
ViewData["TestInfo"] = TestBll.TestDataTen();
//最爽礼包
ViewData["NewestCoolPackage"] = PackageBll.NewestCoolPackage();
//最热游戏
ViewData["NewestHotGame"] = HomePageBll.GetAllTypeHomePage("13", 5);
// 最强福利
ViewBag.NewsetGameDemo = GameDemoBll.GetNewestGameDemo();
//直播热点
ViewData["DirectHot"] = HomePageBll.GetAllTypeHomePage("5", 1);
ViewData["threeDirectHot"] = NewsBll.AccondingTypeGetNews("5");
//手游
ViewData["MobileGame"] = HomePageBll.GetAllTypeHomePage("6", 1);
ViewData["threeMobileGame"] = NewsBll.AccondingTypeGetNews("6");
//最赞攻略结合游戏库拿游戏的logo图
ViewData["MostGreatRaiders"] = UserRaidersBll.GetMostGreatRaiders(10);
//福利美图
ViewData["NewestIndexRecGirls"] = BeautifulGirlsBll.NewestIndexRecGirls();
//热游排行
ViewBag.InLikeNumHotGame = GameBll.InLikeNumHotGame();
//开服
ViewBag.sevenData = OpenServiceBll.WillSevenDayService();
//资讯排行
ViewBag.LikeNumNews = NewsBll.InLikeNumNews();
ViewBag.RecCpy = CompanyBll.RecCompany();
return(View());
}
public Result TestHttp()
{
return(TestBll.TestHttp());
}