//protected void MenuGridView_RowCommand(object sender, GridViewCommandEventArgs e)
//{
// //是否控制权限
// if (e.CommandName == "SingleClick")
// {
// //获取当前行的索引
// LinkButton LB = (LinkButton)e.CommandSource;
// rowIndex = int.Parse(e.CommandArgument.ToString());
// //bool a = true;
// //bool b = false;
// int a = 1;
// int b = 0;
// if (LB.Text == "否")
// //if (LB.Text == STR_NO)
// {
// string sql = "update CMS_SYS_MENU set Menu_Limit='" + a + "' where Menu_ID=" + rowIndex;
// int t = DbHelperSQL.ExecuteSql(sql);
// }
// else
// {
// string sql = "update CMS_SYS_MENU set Menu_Limit='" + b + "' where Menu_ID=" + rowIndex;
// int t = DbHelperSQL.ExecuteSql(sql);
// }
// this.Page.Response.Write("<script>document.location.href=document.location.href;</script>");
// }
// //是否显示
// if (e.CommandName == "DisplayClick")
// {
// //获取当前行的索引
// LinkButton LbDisplay = (LinkButton)e.CommandSource;
// rowIndex = int.Parse(e.CommandArgument.ToString());
// //0--表示显示；1--表示隐藏
// if (LbDisplay.Text == "否")
// //if (LbDisplay.Text == STR_NO)
// {
// string sql = "update CMS_SYS_MENU set Menu_Show=0 where Menu_ID=" + rowIndex;
// int t = DbHelperSQL.ExecuteSql(sql);
// }
// else
// {
// string sql = "update CMS_SYS_MENU set Menu_Show=1 where Menu_ID=" + rowIndex;
// int t = DbHelperSQL.ExecuteSql(sql);
// }
// this.Page.Response.Write("<script>document.location.href=document.location.href;</script>");
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
string strMenuName = txtMenuName.Text.Trim();
string strUrl = txtUrlPath.Text.Trim();
string parentID= ddlParentID.SelectedValue.Trim();
string orderID = txtOrderID.Text.Trim();
string level = ddlLevel.SelectedValue.Trim();
string limit = this.radioListLimit.SelectedValue;
string display = this.RadioListDisplay.SelectedValue;
_menuEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_menuEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_menuEntity.LogMessages.Username = UserSession.Current.UserDspName;
_menuEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_menuEntity.MenuDBEntity = new List<MenuDBEntity>();
MenuDBEntity menuDBEntity = new MenuDBEntity();
menuDBEntity.Parent_MenuId = Convert.ToInt32(parentID);
menuDBEntity.Menu_Name = strMenuName;
menuDBEntity.Menu_Url = strUrl;
menuDBEntity.Menu_Target = "";
menuDBEntity.Menu_Show =Convert.ToInt32(display);//表示不显示
menuDBEntity.Menu_OrderID = Convert.ToInt32(orderID);
menuDBEntity.Menu_Type = 0;//表示类别为菜单控制的。
menuDBEntity.Menu_Limit =Convert.ToInt32(limit); //表示不作限制
menuDBEntity.Menu_Level = Convert.ToInt32(level);
menuDBEntity.Menu_Creator = UserSession.Current.UserAccount;
_menuEntity.MenuDBEntity.Add(menuDBEntity);
MenuBP.Insert(_menuEntity);
clearInputText();//清空已经输入的信息
BindGridView();
BindMenu();
}
protected void MenuGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string MenuID = MenuGridView.DataKeys[e.RowIndex].Value.ToString();
_menuEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_menuEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_menuEntity.LogMessages.Username = UserSession.Current.UserDspName;
_menuEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
string parentID = ((DropDownList)MenuGridView.Rows[e.RowIndex].FindControl("ddlParentIDEdit")).SelectedValue;
string menuName = ((TextBox)MenuGridView.Rows[e.RowIndex].FindControl("txtMenuNameEdit")).Text;
string MenuUrl =((TextBox)MenuGridView.Rows[e.RowIndex].FindControl("txtMenuUrlEdit")).Text;
string MenuOrderID = ((TextBox)MenuGridView.Rows[e.RowIndex].FindControl("txtMenuOrderIDEdit")).Text;
string Level = ((DropDownList)MenuGridView.Rows[e.RowIndex].FindControl("ddlLevelEdit")).SelectedValue;
string limit = ((RadioButtonList)MenuGridView.Rows[e.RowIndex].FindControl("radioListLimitEdit")).SelectedValue;
string display = ((RadioButtonList)MenuGridView.Rows[e.RowIndex].FindControl("RadioListDisplayEdit")).SelectedValue;
_menuEntity.MenuDBEntity = new List<MenuDBEntity>();
MenuDBEntity menuDBEntity = new MenuDBEntity();
menuDBEntity.Menu_ID = Convert.ToInt32(MenuID);
menuDBEntity.Parent_MenuId = Convert.ToInt32(parentID);
menuDBEntity.Menu_Name = menuName;
menuDBEntity.Menu_Url = MenuUrl;
menuDBEntity.Menu_OrderID = Convert.ToInt32(MenuOrderID);
menuDBEntity.Menu_Level = Convert.ToInt32(Level);
menuDBEntity.Menu_Limit = Convert.ToInt32(limit);
menuDBEntity.Menu_Show = Convert.ToInt32(display);
menuDBEntity.Update_Time = DateTime.Now.ToString();
_menuEntity.MenuDBEntity.Add(menuDBEntity);
int iResult = MenuBP.UpdateMenuByMenuID(_menuEntity);
if (iResult == 1) //修改成功
{
string successText = Resources.MyGlobal.UpdateSuccessText;
//commonDBEntity.Event_Result = successText;
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('" + successText + "');", true);
MenuGridView.EditIndex = -1;
BindGridView();//重新绑定显示的页面
}
else//表示修改失败
{
string strFaild = GetLocalResourceObject("UpdateFaildText").ToString();
//commonDBEntity.Event_Result = strRoleFaild;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "failed", "alert('" + strFaild + "')", true);
}
}
private void BindGridView()
{
#region MenuGridView 数据绑定
_menuEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_menuEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_menuEntity.LogMessages.Username = UserSession.Current.UserDspName;
_menuEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_menuEntity.MenuDBEntity = new List<MenuDBEntity>();
MenuDBEntity menuDBEntity = new MenuDBEntity();
menuDBEntity.SearchText = "";
//channelDBEntity.Name_CN = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Name_CN"].ToString())) ? null : ViewState["Name_CN"].ToString();
//channelDBEntity.OnlineStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OnlineStatus"].ToString())) ? null : ViewState["OnlineStatus"].ToString();
//channelDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
//channelDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();
_menuEntity.MenuDBEntity.Add(menuDBEntity);
DataSet dsResult = MenuBP.SelectMenuList(_menuEntity).QueryResult;
//gridViewCSChannelList.DataSource = dsResult.Tables[0].DefaultView;
//string sql = "select * from CMS_SYS_MENU";
//if (Request.QueryString["Parent_MenuId"] != null)
//{
// ParentID = Request.QueryString["Parent_MenuId"].ToString();
//}
//else
//{
// ParentID = "0";
//}
//if (!string.IsNullOrEmpty(ParentID))
//{
// sql += " where Parent_MenuId =" + ParentID;
//}
//DataTable dtUser = this.page1.GetTableInfo(" and Parent_MenuId=" + ParentID, "SYS_BPS_MENU", "OrderID", strDirection);
DataTable dtUser = dsResult.Tables[0];
GridviewControl.GridViewDataBind(this.MenuGridView, dtUser);
#endregion
}
/// <summary>
/// 点击删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void MenuGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string MenuID = MenuGridView.DataKeys[e.RowIndex].Value.ToString();
_menuEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_menuEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_menuEntity.LogMessages.Username = UserSession.Current.UserDspName;
_menuEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_menuEntity.MenuDBEntity = new List<MenuDBEntity>();
MenuDBEntity menuDBEntity = new MenuDBEntity();
menuDBEntity.Menu_ID = Convert.ToInt32(MenuID);
_menuEntity.MenuDBEntity.Add(menuDBEntity); //增加一条到数据库中
int iResult = MenuBP.DeleteMenuByMenuID(_menuEntity);
if (iResult == 1)//删除成功
{
string successText = Resources.MyGlobal.DeleteSuccessText;
//commonDBEntity.Event_Result = successText;
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('" + successText + "');", true);
BindGridView();//重新绑定显示的页面
BindMenu(); //绑定下拉框中的父状态
}
else//表示失败
{
string strFaild = GetLocalResourceObject("DeleteFaildText").ToString();
//commonDBEntity.Event_Result = strRoleFaild;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "failed", "alert('" + strFaild + "')", true);
}
}
