///数据库操作
//母页目录查询，新增下拉框查询
public ActionResult Indexasid()
{
//获取多个表格
SqlconnectionSql tables = new SqlconnectionSql();
DataTable tableasid = tables.SelectTypebig()["asidlist"];
DataTable tableother = tables.SelectTypebig()["other"];
//定义输出结果
IndexAsid result = new IndexAsid();
//定义输出结果的多个属性
List <AsidList> asidlist = new List <AsidList>();
List <TypeBigLists> resultbig = new List <TypeBigLists>();
//定义模型
AsidList asidlistrow = new AsidList();
TypeBigLists resultbigrow = new TypeBigLists();
//asid_tables的内容
//此处传值是按地址传值，自己编写的Clone方法新建一个地址用于存放每次的结果
for (int i = 0; i < tableasid.Rows.Count; i++)
{
asidlistrow.type = tableasid.Rows[i]["typebig"].ToString();
asidlistrow.name = tableasid.Rows[i]["bigtitle"].ToString();
asidlist.Add(asidlistrow.Clone());
}
//释放内存
GC.SuppressFinalize(tableasid);
//type_big_lists内容
//去掉重复的bigtitle
DataTable typebigs = tableother.DefaultView.ToTable(true, "typebig", "bigtitle");
for (int i = 0; i < typebigs.Rows.Count; i++)
{
List <Small> ss = new List <Small>();
resultbigrow.big = typebigs.Rows[i]["bigtitle"].ToString();
//判断smalltitle是否属于bigtitle并添加
for (int j = 0; j < tableother.Rows.Count; j++)
{
if (typebigs.Rows[i]["typebig"].ToString() == tableother.Rows[j]["typebig"].ToString())
{
ss.Add(new Small {
value = tableother.Rows[j]["smalltitle"].ToString(), key = Convert.ToInt32(tableother.Rows[j]["typesmall"])
}.Clone());
}
}
resultbigrow.small = ss;
resultbig.Add(resultbigrow.Clone());
}
GC.SuppressFinalize(tableother);
GC.SuppressFinalize(typebigs);
//给result属性赋值
result.type_big_lists = resultbig;
result.asid_lists = asidlist;
return(Json(new
{
result
}));
}
//子页删除功能
public ActionResult Delete()
{
int id = Convert.ToInt32(HttpContext.Request.Form["id"]);
SqlconnectionSql tables = new SqlconnectionSql();
string result = tables.DeleteJilu(id);
return(Json(new
{
result
}));
}
//子页目录，内容查询
public ActionResult TitleAndNerong()
{
string data = HttpContext.Request.Form["type"].ToString();
//获取多个表格
SqlconnectionSql tables = new SqlconnectionSql();
DataTable table = tables.SelectJilu(data)["TandN"];
//定义输出结果
JiluModel result = new JiluModel();
//定义模型的多个属性
List <JiluAsid> jiluasid = new List <JiluAsid>();
List <JiluNerong> jiluneirong = new List <JiluNerong>();
//定义模型
JiluAsid jiluasidrow = new JiluAsid();
JiluNerong jiluneirongrow = new JiluNerong();
//tables内容
for (int i = 0; i < table.Rows.Count; i++)
{
jiluneirongrow.id = Convert.ToInt32(table.Rows[i]["id"]);
jiluneirongrow.bigtitle = table.Rows[i]["bigtitle"].ToString();
jiluneirongrow.smalltitle = table.Rows[i]["smalltitle"].ToString();
jiluneirongrow.title = table.Rows[i]["title"].ToString();
jiluneirongrow.neirong = table.Rows[i]["contents"].ToString();
jiluneirong.Add(jiluneirongrow.Clone());
}
//types内容
//去掉重复的smalltitle
DataTable typesmalls = table.DefaultView.ToTable(true, "typesmall", "smalltitle");
for (int i = 0; i < typesmalls.Rows.Count; i++)
{
ArrayList ss = new ArrayList();
jiluasidrow.type_small = typesmalls.Rows[i]["smalltitle"].ToString();
//判断mulu_small是否属于type_small并添加
for (int j = 0; j < table.Rows.Count; j++)
{
if (typesmalls.Rows[i]["typesmall"].ToString() == table.Rows[j]["typesmall"].ToString())
{
ss.Add(table.Rows[j]["title"]);
}
}
jiluasidrow.mulu_small = ss;
jiluasidrow.show = 1;
jiluasid.Add(jiluasidrow.Clone());
}
//给result赋值
result.tables = jiluneirong;
result.types = jiluasid;
return(Json(new
{
result
}));
}
///登录相关操作
//账号登录
public ActionResult Login()
{
string zhanghao = HttpContext.Request.Form["zhanghao"].ToString();
string mima = HttpContext.Request.Form["mima"].ToString();
SqlconnectionSql tables = new SqlconnectionSql();
string result = tables.AccountSelect(zhanghao, mima);
return(Json(new
{
result
}));
}
//子页修改功能
public ActionResult Change()
{
int id = Convert.ToInt32(HttpContext.Request.Form["id"]);
string bigtitle = HttpContext.Request.Form["bigtitle"].ToString();
string smalltitle = HttpContext.Request.Form["smalltitle"].ToString();
string title = HttpContext.Request.Form["title"].ToString();
string neirong = HttpContext.Request.Form["neirong"].ToString();
SqlconnectionSql tables = new SqlconnectionSql();
string result = tables.UpdateJilu(bigtitle, smalltitle, title, neirong, id);
return(Json(new
{
result
}));
}
//母页新增功能
public ActionResult AddNew()
{
int typebig = Convert.ToInt32(HttpContext.Request.Form["typebig"]);
int typesmall = Convert.ToInt32(HttpContext.Request.Form["typesmall"]);
string bigtitle = HttpContext.Request.Form["bigtitle"].ToString();
string smalltitle = HttpContext.Request.Form["smalltitle"].ToString();
string title = HttpContext.Request.Form["title"].ToString();
string neirong = HttpContext.Request.Form["neirong"].ToString();
SqlconnectionSql tables = new SqlconnectionSql();
string result = tables.InsertIntoJilu(bigtitle, smalltitle, title, neirong, typebig, typesmall);
return(Json(new
{
result
}));
}
