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 <DetectErrorItemEntity> entities = db.Fetch <DetectErrorItemEntity>("");
ASPxGridView1.DataSource = entities;
GridViewDataComboBoxColumn colPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
List <ProductLineEntity> plineEntities = ProductLineFactory.GetAll();
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";
ASPxGridView1.DataBind();
}
private void setCondition()
{
//初始化GRIDVIEW
List <StationEntity> all = StationFactory.GetAll();
ASPxGridView1.DataSource = all;
ASPxGridView1.DataBind();
}
public void BindData()
{
List <LineSideStoreEntity> allEntity = LinesideStoreFactory.GetAll();
ASPxGridView1.DataSource = allEntity;
GridViewDataComboBoxColumn comPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
List <ProductLineEntity> allPline = ProductLineFactory.GetAll();
comPline.PropertiesComboBox.DataSource = allPline;
comPline.PropertiesComboBox.TextField = "PLINE_NAME";
comPline.PropertiesComboBox.ValueField = "PLINE_CODE";
GridViewDataComboBoxColumn comWorkUnit = ASPxGridView1.Columns["WORKUNIT_CODE"] as GridViewDataComboBoxColumn;
List <StationEntity> allStation = StationFactory.GetAll();
comWorkUnit.PropertiesComboBox.DataSource = allStation;
comWorkUnit.PropertiesComboBox.TextField = "STATION_NAME";
comWorkUnit.PropertiesComboBox.ValueField = "WORKUNIT_CODE";
GridViewDataComboBoxColumn comWorkShop = ASPxGridView1.Columns["WORKSHOP_CODE"] as GridViewDataComboBoxColumn;
DataTable dt = new DataTable();
dt.Columns.Add("text");
dt.Columns.Add("value");
dt.Rows.Add("园区", 8101);
dt.Rows.Add("基地", 8102);
comWorkShop.PropertiesComboBox.DataSource = dt;
comWorkShop.PropertiesComboBox.TextField = "text";
comWorkShop.PropertiesComboBox.ValueField = "value";
GridViewDataComboBoxColumn comStoreType = ASPxGridView1.Columns["STORE_TYPE"] as GridViewDataComboBoxColumn;
DataTable dt1 = new DataTable();
dt1.Columns.Add("text");
dt1.Columns.Add("value");
dt1.Rows.Add("线边库", 0);
dt1.Rows.Add("中心仓库", 1);
comStoreType.PropertiesComboBox.DataSource = dt;
comStoreType.PropertiesComboBox.TextField = "text";
comStoreType.PropertiesComboBox.ValueField = "value";
ASPxGridView1.DataBind();
}
private void initComboBoxByCompany()
{
initing = true;
object val = null;
val = comboBox1.SelectedValue;
try
{
if (val != null)
{
comboBox2.DataSource = ProductLineFactory.GetByCompanyCode(val.ToString());
comboBox2.SelectedValue = DB.ReadConfigLocal("PRODUCTLINE_CODE");
setComboxBoxCurrent(comboBox2);
val = comboBox2.SelectedValue;
if (val != null)
{
comboBox3.DataSource = StationFactory.GetByProductLine(val.ToString());
}
else
{
List <StationEntity> stas = StationFactory.GetAll();
var sta1 = from ss in stas
where ss.COMPANY_CODE == LoginInfo.CompanyInfo.COMPANY_CODE
select ss;
comboBox3.DataSource = sta1.ToList <StationEntity>();
}
comboBox6.SelectedValue = DB.ReadConfigLocal("WORKSHOP_CODE");
comboBox6.DataSource = WorkShopFactory.GetAll();
setComboxBoxCurrent(comboBox6);
comboBox3.SelectedValue = DB.ReadConfigLocal("STATION_CODE");
setComboxBoxCurrent(comboBox3);
comboBox4.DataSource = ShiftFactory.GetAll();
comboBox4.SelectedValue = DB.ReadConfigLocal("SHIFT_CODE");
setComboxBoxCurrent(comboBox4);
comboBox5.DataSource = TeamFactory.GetByPlineCode(val.ToString());
comboBox5.SelectedValue = DB.ReadConfigLocal("TEAM_CODE");
setComboxBoxCurrent(comboBox5);
}
}
catch
{
}
initing = false;
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
if (initing)
{
return;
}
string plinermesid = comboBox2.SelectedValue.ToString();
DB.WriteConfigLocal("PRODUCTLINE_CODE", plinermesid);
List <StationEntity> stations = StationFactory.GetAll();
var ss = from s in stations
where s.PLINE_CODE == plinermesid && s.COMPANY_CODE == comboBox1.SelectedValue.ToString()
select s;
comboBox3.DataSource = ss.ToList <StationEntity>();
List <TeamEntity> teams = TeamFactory.GetByPlineCode(plinermesid);
comboBox5.DataSource = teams;
}
