private void initUser() { //初始化用户下拉列表 string sql = "SELECT USER_ID,USER_CODE,USER_NAME FROM VW_CODE_USER WHERE COMPANY_CODE = '" + theCompanyCode + "' ORDER BY USER_CODE"; SqlUser.SelectCommand = sql; SqlUser.DataBind(); }
private void initUser() { //初始化人员下拉列表 string sql = "SELECT USER_ID,USER_CODE,USER_NAME FROM CODE_USER WHERE COMPANY_CODE = '" + theCompanyCode + "' and user_type='A' "; SqlUser.SelectCommand = sql; SqlUser.DataBind(); }
private void initPline() { //初始化新增模版里程序下拉列表 string sql = "SELECT PLINE_CODE,PLINE_NAME FROM CODE_PRODUCT_LINE WHERE COMPANY_CODE = '" + theCompanyCode + "'"; SqlUser.SelectCommand = sql; SqlUser.DataBind(); }
private void initUser() { //初始化用户下拉列表 string sql = "SELECT A.USER_ID,A.USER_CODE,A.USER_NAME FROM CODE_USER A WHERE A.COMPANY_CODE = '" + theCompanyCode + "' and user_type='B' "; SqlUser.SelectCommand = sql; SqlUser.DataBind(); }