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, "");
}
}
}
}
