protected void comDetectItem_Callback(object sender, CallbackEventArgsBase e)
{
string workUnit = e.Parameter;
List <DetectDataEntity> stations = DetectDataFactory.GetByWorkunit(theCompanyCode, workUnit);
ASPxComboBox detectItem = (ASPxComboBox)sender;
detectItem.DataSource = stations;
detectItem.TextField = "DETECT_ITEM_NAME";
detectItem.ValueField = "DETECT_ITEM_CODE";
detectItem.DataBind();
}
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();
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox;
ASPxComboBox detectItem = ASPxGridView1.FindEditFormTemplateControl("comDetectItem") as ASPxComboBox;
pline.TextField = "PLINE_NAME";
pline.ValueField = "PLINE_CODE";
string plineCode = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "PLINE_CODE").ToString();
string workUnitCode = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "WORKUNIT_CODE").ToString();
List <StationEntity> stations = StationFactory.GetByProductLine(plineCode);
workUnit.DataSource = stations;
workUnit.TextField = "STATION_NAME";
workUnit.ValueField = "WORKUNIT_CODE";
List <DetectDataEntity> detectItems = DetectDataFactory.GetByWorkunit(theCompanyCode, workUnitCode);
detectItem.DataSource = detectItems;
detectItem.TextField = "DETECT_ITEM_NAME";
detectItem.ValueField = "DETECT_ITEM_CODE";
if (ASPxGridView1.IsEditing)
{
//string _workUnit = ASPxGridView1.GetRowValues(ASPxGridView1.EditingRowVisibleIndex, "WORKUNIT_CODE").ToString();
//for (int i = 0; i < workUnit.Items.Count; i++)
//{
// if (_workUnit == workUnit.Items[i].Value.ToString())
// workUnit.Items[i].Selected = true;
//}
}
}
