private void initinfo(string strID)
{
systemMenu sm = new systemMenu();
System.Data.DataTable dt = sm.getEditdata(strID);
DataRow r = dt.Rows[0];
editID.Text = strID;
menuparent.Text = r["menuparent"].ToString().Trim();
menuname.Text = r["menuname"].ToString().Trim();
nodeid.Text = r["nodeid"].ToString().Trim();
sortcode.Text = r["sortcode"].ToString().Trim();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int[] intRowindexarray = mainGrid.SelectedRowIndexArray;
if (intRowindexarray.Length > 0)
{
systemMenu sm = new systemMenu();
object[] keys = mainGrid.DataKeys[intRowindexarray[0]];
string strID = keys[0].ToString();
List <Dictionary <string, string> > listdic = new List <Dictionary <string, string> >();
Dictionary <string, string> dic = new Dictionary <string, string>();
List <string> listTablename = new List <string>();
dic.Add("ID", " cast(ID as varchar(36))='" + strID + "' ");
listdic.Add(dic);
dic = new Dictionary <string, string>();
dic.Add("pid", " cast(pid as varchar(36))='" + strID + "' ");
listdic.Add(dic);
listTablename.Add("systemMenu");
listTablename.Add("systemMenu_button");
int intresult = sm.deleteMutri(listdic, listTablename);
setPageContent(5);
childGrid.DataSource = null;
childGrid.DataBind();
erasechild();
Alert alert = new Alert();
if (intresult > 0)
{
alert.Icon = Icon.Information;
alert.Message = "成功移除数据";
}
else
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据移除失败";
}
alert.Show();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Dictionary <string, string> dic = initDatadic();
string strID = editID.Text.ToString().Trim();
systemMenu sm = new systemMenu();
int intresult = 0;
if (strID == "")
{
dic.Add("ID", Guid.NewGuid().ToString());
intresult = sm.add(dic, "systemMenu");
}
else
{
intresult = sm.update(dic, "systemMenu", "ID", strID);
}
if (CurPage.Text.Trim() == "")
{
setPageContent(1);
}
else
{
setPageContent(5);
}
Alert alert = new Alert();
if (intresult == 1)
{
alert.Icon = Icon.Information;
alert.Message = "数据保存成功";
}
else
{
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Message = "数据保存失败";
}
alert.Show();
}
private void BindGrid()
{
string strf_menuname = f_menuname.Text.Trim();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("menuname", strf_menuname);
int intPageindex = Convert.ToInt32(CurPage.Text.Trim());
int intPagesize = Convert.ToInt32(GridPageSize.Text.Trim());
string strSort = mainGrid.SortField;
string strSortDirection = mainGrid.SortDirection;
systemMenu sm = new systemMenu();
DataTable dt = sm.getBindDataAsdt(dic, strSort, strSortDirection, intPagesize, intPageindex);
DataTable dt1 = sm.getBindDataAsdt(dic, strSort, strSortDirection);
TotalPage.Text = dt1.Rows.Count.ToString();
mainGrid.DataSource = dt;
mainGrid.DataBind();
}
private void inittree()
{
// 模拟从数据库返回数据表
systemMenu sm = new systemMenu();
DataTable table = sm.getBindTreeDataAsdt();
DataSet ds = new DataSet();
ds.Tables.Add(table);
ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["id"], ds.Tables[0].Columns["pid"]);
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row.IsNull("pid"))
{
FineUIPro.TreeNode node = new FineUIPro.TreeNode();
node.Text = row["nodetext"].ToString();
node.NodeID = row["id"].ToString();
node.EnableCheckEvent = true;
firsttree.Nodes.Add(node);
ResolveSubTree(row, node);
}
}
}
