public List <materialData> GetList(string casestr)
{
List <materialData> listdata = new List <materialData>();
DataTable dt = new DataTable();
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
string sql = "select * from material where 1 = 1 ";
sql += casestr;
objDB.OpenConnection();
dt = objDB.QueryDataTable(sql, "tabname");
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow tempRow in dt.Rows)
{
materialData hd = new materialData();
hd.Id = tempRow["Id"].ToString().Trim();
hd.materialtit = tempRow["materialtit"].ToString().Trim();
listdata.Add(hd);
}
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(listdata);
}
public bool Login(string userid, string userpwrd)
{
bool flag = false;
string strSql = "SELECT * FROM Users WHERE (userid = '" + userid + "')";
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
DataTable dt = objDB.QueryDataTable(strSql, "Users");
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow tempRow in dt.Rows)
{
if (tempRow["userpwrd"].ToString().Trim().Equals(userpwrd))
{
this.UserType = tempRow["UserType"].ToString().Trim();
this.UserName = tempRow["UserName"].ToString().Trim();
this.UserClass = tempRow["UserClass"].ToString().Trim();
flag = true;
}
else
{
this.ErrMsg = "密码不正确。";
}
}
}
else
{
this.ErrMsg = "用户名不存在。";
}
dt = null;
return(flag);
}
public int CalcCountSearch(string casestr)
{
DataTable dt = new DataTable();
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
string sql = "select count (1) from informations where id > 0";
sql += casestr;
objDB.OpenConnection();
dt = objDB.QueryDataTable(sql, "tabname");
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return((dt == null) ? 0 : int.Parse(dt.Rows[0][0].ToString()));
}
public DataTable Get(string casestr)
{
DataTable dt = new DataTable();
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
string sql = "select * from informations where 1 = 1 ";
sql += casestr;
objDB.OpenConnection();
dt = objDB.QueryDataTable(sql, "tabname");
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(dt);
}
public DataTable SelectAllFenyeSearch(int pagesize, int pageindex, string casestr)
{
DataTable dt = new DataTable();
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
string sql = "";
if ((pageindex - 1) * pagesize == 0)
{
sql = "select top " + pagesize + " * from informations where id > 0 " + casestr + " order by id desc";
}
else
{
sql = "select top " + pagesize + " * from informations where id not in (select top " + (pageindex - 1) * pagesize + " id from informations order by id desc) " + casestr + " order by id desc";
}
objDB.OpenConnection();
dt = objDB.QueryDataTable(sql, "tabname");
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(dt);
}
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);
}