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