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