private void setCondition()
{
//绑定表数据
//string sql = "select t.RMES_ID,t.plineCODE,b.ROUTING_NAME,t.ITEMCODE,t.ITEMNAME,t.ITEMDESCRIPTION,t.MINVALUE,t.MAXVALUE,t.STANDARDVALUE,t.UNITNAME,decode(t.UNITTYPE,'N','数值','T','文字','B','判断','F','文件'）UNITTYPE,t.ORDERING from qms_standard_item t "
// + " left join data_pline_routing b on t.plineCODE=b.ROUTING_CODE order by t.plineCODE,t.ITEMCODE";
//DataTable dt = dc.GetTable(sql);
List <DetectDataEntity> entities = DetectDataFactory.GetByUser(theUserId, theProgramCode);
string sql = "select t.*,a.pline_code plinecode1 from code_detect t left join code_product_line a on t.pline_code=a.rmes_id where t.pline_code in (select pline_id from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "' ) and (t.temp01 is null or t.temp01='Y') order by t.INPUT_TIME desc nulls last";
DataTable dt1 = dc.GetTable(sql);
ASPxGridView1.DataSource = dt1;
//GridViewDataComboBoxColumn colPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
//List<ProductLineEntity> plineEntities = ProductLineFactory.GetByUserID(theUserId,theProgramCode);
//colPline.PropertiesComboBox.DataSource = plineEntities;
//colPline.PropertiesComboBox.ValueField = "PLINE_CODE";
//colPline.PropertiesComboBox.TextField = "PLINE_NAME";
//GridViewDataComboBoxColumn colworkUnit = ASPxGridView1.Columns["WORKUNIT_CODE"] as GridViewDataComboBoxColumn;
//List<StationEntity> statinEntities = StationFactory.GetAll();
//colworkUnit.PropertiesComboBox.DataSource = statinEntities;
//colworkUnit.PropertiesComboBox.ValueField = "WORKUNIT_CODE";
//colworkUnit.PropertiesComboBox.TextField = "STATION_NAME";
GridViewDataComboBoxColumn colDetectType = ASPxGridView1.Columns["DETECT_TYPE"] as GridViewDataComboBoxColumn;
DataTable dt = new DataTable();
dt.Columns.Add("Text");
dt.Columns.Add("Value");
dt.Rows.Add("计量型", "0");
dt.Rows.Add("计点型", "1");
dt.Rows.Add("文本型", "2");
dt.Rows.Add("零件条码", "3");
//dt.Rows.Add("文件", "F");
colDetectType.PropertiesComboBox.DataSource = dt;
colDetectType.PropertiesComboBox.ValueField = "Value";
colDetectType.PropertiesComboBox.TextField = "Text";
ASPxGridView1.DataBind();
}
