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