private void initWorkUnit() { //初始化生产线下拉列表 string sql = "select WORKUNIT_CODE,STATION_NAME,RMES_ID from CODE_STATION WHERE COMPANY_CODE = '" + theCompanyCode + "'"; SqlRole.SelectCommand = sql; SqlRole.DataBind(); }
private void initRole() { //初始化角色下拉列表 string sql = "SELECT ROLE_CODE,ROLE_NAME FROM CODE_ROLE WHERE COMPANY_CODE = '" + theCompanyCode + "'"; SqlRole.SelectCommand = sql; SqlRole.DataBind(); }
private void initRole() { //初始化生产线下拉列表 string sql = "SELECT RMES_ID,PLINE_CODE,PLINE_NAME FROM code_product_line WHERE COMPANY_CODE = '" + theCompanyCode + "'"; SqlRole.SelectCommand = sql; SqlRole.DataBind(); }
private void initDEPT() { //初始化角色下拉列表 string sql = "SELECT DEPT_CODE,DEPT_NAME FROM CODE_DEPT WHERE COMPANY_CODE = '" + theCompanyCode + "'"; SqlRole.SelectCommand = sql; SqlRole.DataBind(); }
/// <summary> /// Add Menu Permission from the database. /// </summary> /// <param name="dtMenu"></param> /// <returns>Returns true if delete is successful, else false.</returns> public static bool AddUpdateMenu(DataTable dtMenu) { if (dtMenu.Rows.Count > 0) { var sqlRole = new SqlRole(); return sqlRole.AddUpdateMenu(dtMenu); } return false; }
public RoleController(SqlRole roleRepository) { this._roleRepository = roleRepository; }
/// <summary> /// Get the Menus. /// </summary> /// <param name="id"></param> /// <returns>Collection of Menus.</returns> public static IList<Role> GetMenus(int? id = null) { var sqlRole = new SqlRole(); return sqlRole.GetMenus(id); }
/// <summary> /// Get the Role. /// </summary> /// <returns>Collection of Role.</returns> public static IList<Role> GetRoles() { var sqlRole = new SqlRole(); return sqlRole.GetRoles(); }
/// <summary> /// Add/Update Role /// </summary> /// <returns></returns> public static bool AddUpdateRole(Role entity) { var sqlRole = new SqlRole(); bool isAddUpdated = sqlRole.AddUpdateRole(entity); return isAddUpdated; }
/// <summary> /// Deletes an Role from the database based on Id. /// </summary> /// <param name="dtRole"></param> /// <returns>Returns true if delete is successful, else false.</returns> /// <remarks>Deletes based on primary key(s).</remarks> public static bool DeleteRole(DataTable dtRole) { var sqlRole = new SqlRole(); return sqlRole.DeleteRole(dtRole); }