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);
}
