public int Add(SystemMenus model)
{
string sql = "insert into SystemMenus(SystemMenus_Id,SystemMenus_Title,SystemMenus_Link,SystemMenus_Icon,SystemMenus_DeleteId,SystemMenus_ParentId,SystemMenus_CreateTime,SystemMenus_UpdateTime) "
+ "values(@SystemMenus_Id,@SystemMenus_Title,@SystemMenus_Link,@SystemMenus_Icon,@SystemMenus_DeleteId,@SystemMenus_ParentId,@SystemMenus_CreateTime,@SystemMenus_UpdateTime)";
return(SqlHelper <SystemMenus> .ExceuteNonQuery(sql, model));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SystemMenus.getMenuType(drpMenuType, entities);
//load grid view
grvLib.DataBind();
}
}
public int EditSystemMenus(SystemMenus systemMenus)
{
string sql =
"update SystemMenus set SystemMenus_Title = @SystemMenus_Title,SystemMenus_Link = @SystemMenus_Link,SystemMenus_UpdateTime = @SystemMenus_UpdateTime where SystemMenus_Id = @SystemMenus_Id";
SqlParameter[] param =
{
new SqlParameter("@SystemMenus_Title", systemMenus.SystemMenus_Title),
new SqlParameter("@SystemMenus_Link", systemMenus.SystemMenus_Link),
new SqlParameter("@SystemMenus_UpdateTime", systemMenus.UpdateTime),
new SqlParameter("@SystemMenus_Id", systemMenus.Id)
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int intMenuID = 0;
//get Default Language ID
Commons.CommonFunctionsAndProcedures.drawTreeInDropDownList(0, null, drpMenus, null, Commons.TitleConst.getTitleConst("TABLE_QT_MENUS"), entities);
SystemMenus.getMenuType(drpMenuType, entities);
//get Content ID from session for finding content
SessionForFindingMenu objSessionForFindingMenu = (SessionForFindingMenu)Session[Commons.ConstValues.SESSION_MENUS];
if ((objSessionForFindingMenu != null) && (!String.IsNullOrEmpty(objSessionForFindingMenu.ID_MENU)))
{
intMenuID = Convert.ToInt32(objSessionForFindingMenu.ID_MENU);
Session[Commons.ConstValues.SESSION_MENUS] = null;
txtMenuID.Text = intMenuID.ToString();
CPanel.Models.TBL_MENU objMenu = entities.TBL_MENU.Find(intMenuID);
txtTieude.Text = objMenu.TEN;
txtURL.Text = objMenu.LINK;
txtSTT.Text = (objMenu.STT == null ? "" : objMenu.STT.ToString());
if (objMenu.isEnabled)
{
cbPublishedStatus.Checked = true;
}
else
{
cbPublishedStatus.Checked = false;
}
if (objMenu.ID_CHA != 0)
{
drpMenus.SelectedValue = objMenu.ID_CHA.ToString();
}
//set Menu Type
drpMenuType.SelectedValue = objMenu.ID_LOAI_MENU.ToString();
}
}
}
public int AddSystemMenus(SystemMenus systemMenus)
{
string sql =
"insert into SystemMenus(SystemMenus_Id,SystemMenus_Title,SystemMenus_Link,SystemMenus_ParentId,SystemMenus_Icon,SystemMenus_DeleteId,SystemMenus_CreateTime,SystemMenus_UpdateTime)values(@SystemMenus_Id,@SystemMenus_Title,@SystemMenus_Link,@SystemMenus_ParentId,@SystemMenus_Icon,@SystemMenus_DeleteId,@SystemMenus_CreateTime,@SystemMenus_UpdateTime)";
SqlParameter[] param =
{
new SqlParameter("@SystemMenus_Id", systemMenus.Id),
new SqlParameter("@SystemMenus_Title", systemMenus.SystemMenus_Title),
new SqlParameter("@SystemMenus_Link", systemMenus.SystemMenus_Link),
new SqlParameter("@SystemMenus_ParentId", systemMenus.SystemMenus_ParentId),
new SqlParameter("@SystemMenus_Icon", systemMenus.SystemMenus_Icon),
new SqlParameter("@SystemMenus_DeleteId", systemMenus.DeleteId),
new SqlParameter("@SystemMenus_CreateTime", systemMenus.CreateTime),
new SqlParameter("@SystemMenus_UpdateTime", systemMenus.UpdateTime),
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
public List <SystemMenus> FillData(DataTable dt)
{
var list = new List <SystemMenus>();
foreach (DataRow dr in dt.Rows)
{
var item = new SystemMenus()
{
Id = Guid.Parse(dr["SystemMenus_Id"].ToString()),
SystemMenus_Title = dr["SystemMenus_Title"].ToString(),
SystemMenus_Link = dr["SystemMenus_Link"].ToString(),
SystemMenus_ParentId = Guid.Parse(dr["SystemMenus_ParentId"].ToString()),
SystemMenus_Icon = dr["SystemMenus_Icon"].ToString(),
DeleteId = int.Parse(dr["SystemMenus_DeleteId"].ToString()),
UpdateTime = DateTime.Parse(dr["SystemMenus_UpdateTime"].ToString())
};
list.Add(item);
}
return(list);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
var choose = this.ddlFirst.SelectedValue;
Guid id = Guid.Empty;
if (choose == "2")
{
//当我们第一个下拉列表的值为2时,那么我们的菜单等级为二级菜单,我们需要去选择一个父级菜单,并且得到这个菜单的id
id = Guid.Parse(this.ddlSecond.SelectedValue);
}
else if (choose == "3")
{
//当我们第一个下拉列表的值为3时,那么我们的菜单等级为三级菜单,我们需要去选择一个父级菜单,并且得到这个菜单的id
id = Guid.Parse(this.ddlThird.SelectedValue);
}
var model = new SystemMenus
{
SystemMenus_Title = this.txtName.Text,
SystemMenus_Link = this.txtLink.Text,
SystemMenus_Icon = this.txtIcon.Text,
SystemMenus_ParentId = id
};
var res = menuSvc.Add(model);
ReturnMsg rm = res > 0
? new ReturnMsg()
{
Code = StatusCode.OK,
Message = "新增系统菜单成功",
Data = null
}
: new ReturnMsg()
{
Code = StatusCode.Error,
Message = "新增系统菜单失败",
Data = null
};
Session["Msg"] = rm; //用于传递执行信息的
Response.Redirect("SystemMenu_List.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//If user is an anonymous
if (ATCL_Consts.NUMBER_ANONYMOUS_USER_ID.ToString().Equals((String)Session[ATCL_Consts.SESSION_NAME_USER_ID]))
{
return;
}
//Otherwise, get user's info
CheckUserInfo.CheckLogin();
int intUserID = (int)CheckUserInfo.GetUserId();
var obj = entities.TBL_NGUOI_DUNG.Where(x => x.Id == intUserID).FirstOrDefault();
txtFullName.Text = String.Format(Commons.TitleConst.getTitleConst("WELCOME_USER"), obj.UserName);
//get Menus
SystemMenus objSysMenus = new SystemMenus();
objSysMenus.getAdministratorMenus(lbMenus);
//get Departments by UserID
ATCL_Commons.getDropDownList_Departments_ByUserID(drpDepartments, intUserID, Session, entities);
}
}
public int Edit(SystemMenus model)
{
return(dal.Edit(model));
}
public int Add(SystemMenus model)
{
return(dal.Add(model));
}
public int Edit(SystemMenus model)
{
string sql = "update SystemMenus set SystemMenus_Title = @SystemMenus_Title ,SystemMenus_Link = @SystemMenus_Link,SystemMenus_Icon = @SystemMenus_Icon,SystemMenus_ParentId = @SystemMenus_ParentId,SystemMenus_UpdateTime = @SystemMenus_UpdateTime where SystemMenus_Id = @SystemMenus_Id";
return(SqlHelper <SystemMenus> .ExceuteNonQuery(sql, model));
}
public int EditSystemMenus(SystemMenus systemMenus)
{
return(sm.EditSystemMenus(systemMenus));
}
public int AddSystemMenus(SystemMenus systemMenus)
{
return(sm.AddSystemMenus(systemMenus));
}
