public bool Delete(string Id)
{
int iRel = -1;
bool bRel = false;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
try
{
objDB.OpenConnection();
string strSql = "delete from homework where Id=" + Id + "";
objDB.Command.CommandType = System.Data.CommandType.Text;
objDB.Command.CommandText = strSql;
iRel = objDB.Command.ExecuteNonQuery();
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
bRel = (iRel.Equals(1) ? true : false);
return(bRel);
}
public bool Modify(menulevel1Data datmenulevel1)
{
int iRel = -1;
bool bRel = false;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
try
{
objDB.OpenConnection();
string strSql = "update menulevel1 set menuname=@menuname,nums=@nums where Id = @Id";
objDB.Command.CommandType = System.Data.CommandType.Text;
objDB.Command.CommandText = strSql;
objDB.Command.Parameters.AddWithValue("@menuname", datmenulevel1.menuname);
objDB.Command.Parameters.AddWithValue("@nums", datmenulevel1.nums);
objDB.Command.Parameters.AddWithValue("@Id", datmenulevel1.Id);
iRel = objDB.Command.ExecuteNonQuery();
}
catch (Exception ex)
{ iRel = -1; }
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
bRel = (iRel.Equals(1) ? true : false); return(bRel);
}
public bbsData SelectData(string casestr)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
bbsData datbbs = new bbsData();
string sql = "select * from bbs where 1= 1 ";
sql += casestr;
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
for (int i = 0; i < nRow; i++)
{
datbbs.userid = ds.Tables[0].Rows[i]["userid"].ToString();
datbbs.thetime = ds.Tables[0].Rows[i]["thetime"].ToString();
datbbs.memos = ds.Tables[0].Rows[i]["memos"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datbbs);
}
public menulevel1Data[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
menulevel1Data[] datmenulevel1 = new menulevel1Data[1];
string sql = "select * from menulevel1 where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datmenulevel1 = new menulevel1Data[nRow];
for (int i = 0; i < nRow; i++)
{
datmenulevel1[i] = new menulevel1Data();
datmenulevel1[i].menuname = ds.Tables[0].Rows[i]["menuname"].ToString();
datmenulevel1[i].nums = ds.Tables[0].Rows[i]["nums"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datmenulevel1);
}
public string getmenu()
{
List <memu> menu_list = new List <memu>();
DataTable dt = new DataTable();
DataTable dtlevel2 = new DataTable();
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
string sql = "select * from menulevel1 order by nums ";
objDB.OpenConnection();
dt = objDB.QueryDataTable(sql, "tabname");
if (dt != null && dt.Rows.Count > 0)
{
//现在把所有符合条件的 都放到一个LIST里面 然后在这个LIST里面进行操作
foreach (DataRow tempRow in dt.Rows)
{
//查找二级菜单
List <sub_button> sub_button_list = new List <sub_button>();
sql = "select * from menulevel2 where level1id ='" + tempRow["id"].ToString() + "' order by nums ";
dtlevel2 = objDB.QueryDataTable(sql, "tabname");
if (dtlevel2 != null && dtlevel2.Rows.Count > 0)
{
foreach (DataRow tempRowlevel2 in dtlevel2.Rows)
{
sub_button sub_buttondata = new sub_button();
sub_buttondata.type = tempRowlevel2["menutype"].ToString().Trim();
sub_buttondata.name = tempRowlevel2["menuname"].ToString().Trim();
sub_buttondata.url = tempRowlevel2["menuurl"].ToString().Trim();
sub_button_list.Add(sub_buttondata);
}
}
memu tmpmemu = new memu();
tmpmemu.name = tempRow["menuname"].ToString();
tmpmemu.sub_button = sub_button_list;
menu_list.Add(tmpmemu);
}
}
dt = null;
dtlevel2 = null;
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
//建立三级菜单
//string name = "公告";
//sub_button btn = new sub_button();
//btn.type = "1";
//btn.name = "2";
//btn.url = "3";
//sub_button btn1 = new sub_button();
//btn1.type = "1";
//btn1.name = "2";
//btn1.url = "3";
//List<sub_button> sub_button = new List<sub_button>() { btn, btn1 };
////建立二级菜单
////建立物件，塞资料
//memu memu = new memu()
//{
// name = name,
// sub_button = sub_button
//};
////建立一级菜单
//List<memu> memulist = new List<memu>() { memu };
getbutton getbutton = new getbutton()
{
button = menu_list
};
//物件序列化
string strJson = JsonConvert.SerializeObject(getbutton, Formatting.Indented);
//输出结果
//Response.Write(strJson);
return(strJson);
}