public void BindData()
{
string orderCode = txtOrderCode.Text.ToUpper();
string plineCode = ComPline.SelectedItem.Value.ToString();
List <PlanEntity> plans = PlanFactory.GetByCreatePeriod(cdate1.Date, cdate2.Date);
string _b = cdate1.Date.ToShortDateString() + " 00:00:00";
string _e = cdate2.Date.ToShortDateString() + " 23:59:59";
List <IMESCompleteInstoreEntity> entity = db.Fetch <IMESCompleteInstoreEntity>("where aufnr in (select ORDER_CODE from DATA_PLAN where create_time between to_date(@0,'yyyy-mm-dd hh24:mi:ss') and to_date(@1,'yyyy-mm-dd hh24:mi:ss'))", _b, _e);
UserEntity users = UserFactory.GetByUserCode(theUserID);
if (!string.IsNullOrWhiteSpace(orderCode))
{
//entity = (from s in entity where (from pl in plans where pl.PROJECT_CODE == orderCode.ToUpper() && pl.RUN_FLAG == "F" select pl.ORDER_CODE).Contains(s.AUFNR) select s).ToList<IMESCompleteInstoreEntity>();
}
if (!ComPline.SelectedItem.Value.ToString().Equals("All"))
{
entity = (from s in entity where (from pl in plans where pl.PLINE_CODE == plineCode && pl.RUN_FLAG == "F" select pl.ORDER_CODE).Contains(s.AUFNR) select s).ToList <IMESCompleteInstoreEntity>();
}
DataTable dt1 = new DataTable();
dt1.Columns.Add("AUFNR");
//ASPxGridView1.DataSource = entity;
XtraReport1 re = new XtraReport1(entity, theUserID, orderCode);
ReportViewer1.Report = re;
//DataTable dt = new DataTable();
//dt.Columns.Add("Text");
//dt.Columns.Add("Value");
//dt.Rows.Add("初始状态", "0");
//dt.Rows.Add("传送中", "1");
//dt.Rows.Add("已传送", "2");
//GridViewDataComboBoxColumn colPrind = ASPxGridView1.Columns["PRIND"] as GridViewDataComboBoxColumn;
//colPrind.PropertiesComboBox.DataSource = dt;
//colPrind.PropertiesComboBox.TextField = "Text";
//colPrind.PropertiesComboBox.ValueField = "Value";
//DataTable workshopDT = new DataTable();
//workshopDT.Columns.Add("Value");
//workshopDT.Columns.Add("Text");
//workshopDT.Rows.Add("8101", "园区");
//workshopDT.Rows.Add("8102", "基地");
//GridViewDataComboBoxColumn workshopCol = ASPxGridView1.Columns["WERKS"] as GridViewDataComboBoxColumn;
//workshopCol.PropertiesComboBox.DataSource = workshopDT;
//workshopCol.PropertiesComboBox.ValueField = "Value";
//workshopCol.PropertiesComboBox.TextField = "Text";
//ASPxGridView1.DataBind();
}
private void initSnEdit()
{
GridPrint.Rows.Clear();
List <PlanEntity> allPlans = PlanFactory.GetByCreatePeriod(dateTimePicker1.Value, dateTimePicker2.Value);
if (comboBox1.SelectedIndex >= 0)
{
string pline_code = comboBox1.SelectedValue.ToString();
allPlans = (from s in allPlans where s.PLINE_CODE == pline_code select s).ToList();
}
if (allPlans.Count > 0)
{
foreach (var p in allPlans)
{
List <PlanSnEntity> snEntity = PlanSnFactory.WebGetByOrderCode(p.ORDER_CODE);
if (snEntity == null)
{
continue;
}
foreach (var s in snEntity)
{
//int i = GridPrint.Rows.Add();
//GridPrint.Rows[i].Cells["colPrint"].Value = "打印";
//GridPrint.Rows[i].Cells["colProject"].Value = p.PROJECT_CODE;
//GridPrint.Rows[i].Cells["colOrderCode"].Value = p.ORDER_CODE;
//GridPrint.Rows[i].Cells["colModel"].Value = p.PLAN_SO;
//GridPrint.Rows[i].Cells["colSeries"].Value = p.PRODUCT_SERIES;
//GridPrint.Rows[i].Cells["colBarCode"].Value = p.DETECT_BARCODE;
//GridPrint.Rows[i].Cells["colSN"].Value = s.SN;
}
}
}
if (statusStrip1.Items.Count == 0)
{
statusStrip1.Items.Add("记录数量：" + allPlans.Count.ToString());
}
else
{
statusStrip1.Items[0].Text = "记录数量：" + allPlans.Count.ToString();
}
// GridEdit.Rows[i].ReadOnly = true;
// bCell.Value = "不可打印";
}
public void BindData()
{
string planSO = txtPlanSO.Text;
string plineCode = ComPline.SelectedItem.Value.ToString();
//if (string.IsNullOrWhiteSpace(orderCode)) return;
List <PlanEntity> plans = PlanFactory.GetByCreatePeriod(cdate1.Date, cdate2.Date);
//string _b = cdate1.Date.ToString("yyyyMMdd") + "000000";
//string _e = cdate2.Date.ToString("yyyyMMdd") + "235959";
//List<IMESPlanBOMEntity> entity = db.Fetch<IMESPlanBOMEntity>("where SERIAL between @0 and @1 order by AUFNR", _b, _e);
string _b = "B" + cdate1.Date.ToString("yyyyMMdd") + "0000";
string _e = "B" + cdate2.Date.ToString("yyyyMMdd") + "9999";
List <IMESPlanBOMEntity> entity = db.Fetch <IMESPlanBOMEntity>("where BATCH between @0 and @1 order by AUFNR", _b, _e);
if (!string.IsNullOrWhiteSpace(planSO))
{
entity = (from s in entity where s.MATNR == planSO select s).ToList <IMESPlanBOMEntity>();
}
if (!ComPline.SelectedItem.Value.ToString().Equals("All"))
{
entity = (from s in entity where (from pl in plans where pl.PLINE_CODE == plineCode && pl.RUN_FLAG == "F" select pl.ORDER_CODE).Contains(s.AUFNR) select s).ToList <IMESPlanBOMEntity>();
}
ASPxGridView1.DataSource = entity;
DataTable dt = new DataTable();
dt.Columns.Add("Text");
dt.Columns.Add("Value");
dt.Rows.Add("初始状态", "0");
dt.Rows.Add("传送中", "1");
dt.Rows.Add("已传送", "2");
GridViewDataComboBoxColumn colPrind = ASPxGridView1.Columns["PRIND"] as GridViewDataComboBoxColumn;
colPrind.PropertiesComboBox.DataSource = dt;
colPrind.PropertiesComboBox.TextField = "Text";
colPrind.PropertiesComboBox.ValueField = "Value";
ASPxGridView1.DataBind();
}
public void BindData()
{
string plineCode;
List <object> _planSO = gridLookupItem.GridView.GetSelectedFieldValues("WBS_CODE");
if (_planSO == null || _planSO.Count == 0)
{
return;
}
if (ComPline.SelectedItem != null)
{
plineCode = ComPline.SelectedItem.Value.ToString();
}
else
{
plineCode = "";
}
//if (string.IsNullOrEmpty(plineCode)) return;
List <PlanEntity> entity = PlanFactory.GetByCreatePeriod(cdate1.Date, cdate2.Date);
if (_planSO != null && _planSO.Count > 0)
{
//entity = (from s in entity where _planSO.Contains(s.WBS_CODE) select s).ToList<PlanEntity>();
}
if (!ComPline.SelectedItem.Value.ToString().Equals("All"))
{
entity = (from s in entity where s.PLINE_CODE == plineCode select s).ToList <PlanEntity>();
}
ASPxGridView1.DataSource = entity;
XtraReport3 re = new XtraReport3(entity);
ReportViewer1.Report = re;
GridViewDataComboBoxColumn colPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
List <ProductLineEntity> plineEntities = ProductLineFactory.GetAll();
colPline.PropertiesComboBox.DataSource = plineEntities;
colPline.PropertiesComboBox.ValueField = "RMES_ID";
colPline.PropertiesComboBox.TextField = "PLINE_NAME";
DataTable itemDT = new DataTable();
itemDT.Columns.Add("Value");
itemDT.Columns.Add("Text");
itemDT.Rows.Add("Y", "已收料");
itemDT.Rows.Add("B", "已发料单");
itemDT.Rows.Add("N", "未确认");
GridViewDataComboBoxColumn itemCol = ASPxGridView1.Columns["ITEM_FLAG"] as GridViewDataComboBoxColumn;
itemCol.PropertiesComboBox.DataSource = itemDT;
itemCol.PropertiesComboBox.ValueField = "Value";
itemCol.PropertiesComboBox.TextField = "Text";
DataTable runDT = new DataTable();
runDT.Columns.Add("Value");
runDT.Columns.Add("Text");
runDT.Rows.Add("Y", "执行中");
runDT.Rows.Add("N", "未执行");
runDT.Rows.Add("P", "暂停中");
runDT.Rows.Add("F", "已完成");
GridViewDataComboBoxColumn runCol = ASPxGridView1.Columns["RUN_FLAG"] as GridViewDataComboBoxColumn;
runCol.PropertiesComboBox.DataSource = runDT;
runCol.PropertiesComboBox.ValueField = "Value";
runCol.PropertiesComboBox.TextField = "Text";
List <UserEntity> allusers = UserFactory.GetAll();
GridViewDataComboBoxColumn create_user = ASPxGridView1.Columns["CREATE_USER_ID"] as GridViewDataComboBoxColumn;
create_user.PropertiesComboBox.DataSource = allusers;
create_user.PropertiesComboBox.ValueField = "USER_ID";
create_user.PropertiesComboBox.TextField = "USER_NAME";
DataTable typeDT = new DataTable();
typeDT.Columns.Add("Value");
typeDT.Columns.Add("Text");
typeDT.Rows.Add("ZP01", "标准");
typeDT.Rows.Add("ZP02", "返工");
typeDT.Rows.Add("ZP03", "拆解");
GridViewDataComboBoxColumn typeCol = ASPxGridView1.Columns["PLAN_TYPE_CODE"] as GridViewDataComboBoxColumn;
typeCol.PropertiesComboBox.DataSource = typeDT;
typeCol.PropertiesComboBox.ValueField = "Value";
typeCol.PropertiesComboBox.TextField = "Text";
ASPxGridView1.DataBind();
}