private void LoadEquipGroupControl() { EquipmentGroupInfo equipGroup = null; ddlEquipGroup.Items.Clear(); ttbEquipGroupFilter.Text = ttbEquipGroupFilter.Text.Trim(); if (ttbEquipGroupFilter.Text.IsNullOrTrimEmpty() == false) { equipGroup = EquipmentGroupInfo.GetEquipmentGroupByName(ttbEquipGroupFilter.Text); } if (equipGroup != null) { ddlEquipGroup.Items.Add(new ListItem(equipGroup.GroupName, equipGroup.ID)); ddlEquipGroup_SelectedIndexChanged(ddlEquipGroup, EventArgs.Empty); } else { List <string> pars = new List <string>(); sql = @" SELECT {0} FROM MES_EQP_GROUP P"; if (ttbEquipGroupFilter.Text.IsNullOrTrimEmpty() == false) { sql += @" WHERE P.GROUPNAME LIKE #[STRING]"; pars.Add(ttbEquipGroupFilter.Text + "%"); } //取得機台群組 if (DBCenter.GetSingleResult <int>(string.Format(sql, "COUNT(P.GROUPNAME)"), pars.ToArray()) > maxReturnQty) { ddlEquipGroup.Items.Add(new ListItem(GetUIResource("InputRequired", lblEquipment.Text), string.Empty)); } else { List <EquipmentGroupInfo> equipGroupList = InfoCenter.GetList <EquipmentGroupInfo>(string.Format(sql + " ORDER BY P.GROUPNAME ", "P.GROUPNAME, P.EQP_GROUP_SID"), pars.ToArray()); ddlEquipGroup.DataSource = equipGroupList; ddlEquipGroup.DataTextField = "GroupName"; ddlEquipGroup.DataValueField = "EquipmentGroupSID"; ddlEquipGroup.DataBind(); if (equipGroupList.Count == 0) { ddlEquipGroup.Items.Add(new ListItem(TextMessage.Error.T00550(""), string.Empty)); } if (equipGroupList.Count == 1) { ddlEquipGroup_SelectedIndexChanged(ddlEquipGroup, EventArgs.Empty); } if (equipGroupList.Count > 1) { ddlEquipGroup.Items.Insert(0, ""); } } } }
private void LoadEquipmentControl() { ttbEquipmentFilter.Text = ttbEquipmentFilter.Text.Trim(); ddlEquipment.Items.Clear(); EquipmentInfo equipmant = null; if (ttbEquipmentFilter.Text.IsNullOrTrimEmpty() == false) { equipmant = EquipmentInfo.GetEquipmentByName(ttbEquipmentFilter.Text); } if (equipmant != null) { ddlEquipGroup.Items.Clear(); //ddlEquipGroup.Items.Insert(0, new ListItem(ddlEquipment.ProductName, device.ProductName)); ddlEquipment.Items.Add(new ListItem(equipmant.EquipmentName, equipmant.EquipmentName)); ddlEquipment_SelectedIndexChanged(ddlEquipment, EventArgs.Empty); } else { if (ddlEquipGroup.SelectedItem.Text.IsNullOrTrimEmpty() == true) { return; } List <string> paras = new List <string>(); sql = @"SELECT {0} FROM MES_EQP_GROUP_EQP G WHERE G.EQP_GROUP_SID = #[STRING] "; paras.Add(ddlEquipGroup.SelectedItem.Value); if (ttbEquipmentFilter.Text.IsNullOrTrimEmpty() == false) { sql += " AND G.EQUIPMENT LIKE #[STRING] "; paras.Add(ttbEquipmentFilter.Text + "%"); } if (DBCenter.GetSingleResult <int>(string.Format(sql, "COUNT(G.EQUIPMENT)"), paras.ToArray()) > maxReturnQty) { ddlEquipment.Items.Add(new ListItem(GetUIResource("InputRequired", lblEquipment.Text), string.Empty)); } else { List <EquipGroupEquipInfo> equipmentList = InfoCenter.GetList <EquipGroupEquipInfo>(string.Format(sql + " ORDER BY G.EQUIPMENT", "G.EQUIPMENT"), paras.ToArray()); ddlEquipment.DataSource = equipmentList; ddlEquipment.DataTextField = "EquipmentName"; ddlEquipment.DataValueField = "EquipmentName"; ddlEquipment.DataBind(); if (equipmentList.Count == 0) { ddlEquipment.Items.Add(new ListItem(TextMessage.Error.T00550(""), string.Empty)); } if (equipmentList.Count == 1) { ddlEquipment_SelectedIndexChanged(ddlEquipment, EventArgs.Empty); } if (equipmentList.Count > 1) { ddlEquipment.Items.Insert(0, ""); } } } }
private void LoadDeviceControl() { ttbDeviceFilter.Text = ttbDeviceFilter.Text.Trim(); ddlDevice.Items.Clear(); DeviceVersionInfo device = null; if (ttbDeviceFilter.Text.IsNullOrTrimEmpty() == false) { device = DeviceVersionInfo.GetActiveDeviceVersion(ttbDeviceFilter.Text); } if (device != null) { ddlProduct.Items.Clear(); ddlProduct.Items.Insert(0, new ListItem(device.ProductName, device.ProductName)); ddlDevice.Items.Add(new ListItem(device.DeviceName, device.DeviceName)); ddlDevice_SelectedIndexChanged(ddlDevice, EventArgs.Empty); } else { if (ddlProduct.SelectedItem.Text.IsNullOrTrimEmpty() == true) { return; } List <string> paras = new List <string>(); sql = @"SELECT {0} FROM MES_PRC_DEVICE_VER V WHERE V.REVSTATE = 'ACTIVE' AND V.PRODUCT = #[STRING] "; paras.Add(ddlProduct.SelectedItem.Value); if (ttbDeviceFilter.Text.IsNullOrTrimEmpty() == false) { sql += " AND V.DEVICE LIKE #[STRING] "; paras.Add(ttbDeviceFilter.Text + "%"); } //sql += " ORDER BY V.DEVICE"; if (DBCenter.GetSingleResult <int>(string.Format(sql, "COUNT(V.DEVICE)"), paras.ToArray()) > maxReturnQty) { ddlDevice.Items.Add(new ListItem(GetUIResource("InputRequired", lblDevice.Text), string.Empty)); } else { List <DeviceVersionInfo> DeviceList = InfoCenter.GetList <DeviceVersionInfo>(string.Format(sql + " ORDER BY V.DEVICE", "V.DEVICE"), paras.ToArray()); ddlDevice.DataSource = DeviceList; ddlDevice.DataTextField = "DeviceName"; ddlDevice.DataValueField = "DeviceName"; ddlDevice.DataBind(); if (DeviceList.Count == 0) { ddlDevice.Items.Add(new ListItem(TextMessage.Error.T00550(""), string.Empty)); } if (DeviceList.Count == 1) { ddlDevice_SelectedIndexChanged(ddlDevice, EventArgs.Empty); } if (DeviceList.Count > 1) { ddlDevice.Items.Insert(0, ""); } } } }
private void LoadProductControl() { ProductInfo product = null; ddlProduct.Items.Clear(); ttbProductFilter.Text = ttbProductFilter.Text.Trim(); if (ttbProductFilter.Text.IsNullOrTrimEmpty() == false) { product = ProductInfo.GetProductByName(ttbProductFilter.Text); } if (product != null) { ddlProduct.Items.Add(new ListItem(product.ProductName, product.ProductName)); ddlProduct_SelectedIndexChanged(ddlProduct, EventArgs.Empty); } else { List <string> pars = new List <string>(); sql = @" SELECT {0} FROM MES_PRC_PROD P"; if (ttbProductFilter.Text.IsNullOrTrimEmpty() == false) { sql += @" WHERE P.PRODUCT LIKE #[STRING]"; pars.Add(ttbProductFilter.Text + "%"); } //sql += @" ORDER BY P.PRODUCT "; //取得產品 if (DBCenter.GetSingleResult <int>(string.Format(sql, "COUNT(P.PRODUCT)"), pars.ToArray()) > maxReturnQty) { ddlProduct.Items.Add(new ListItem(GetUIResource("InputRequired", lblProduct.Text), string.Empty)); } else { List <ProductInfo> ProductList = InfoCenter.GetList <ProductInfo>(string.Format(sql + " ORDER BY P.PRODUCT ", "P.PRODUCT"), pars.ToArray()); ddlProduct.DataSource = ProductList; ddlProduct.DataTextField = "ProductName"; ddlProduct.DataValueField = "ProductName"; ddlProduct.DataBind(); if (ProductList.Count == 0) { ddlProduct.Items.Add(new ListItem(TextMessage.Error.T00550(""), string.Empty)); } if (ProductList.Count == 1) { ddlProduct_SelectedIndexChanged(ddlProduct, EventArgs.Empty); } if (ProductList.Count > 1) { ddlProduct.Items.Insert(0, ""); } } } }