private void FillParentAppendixList()
{
string sql;
string[] orderBy;
switch (_AppendixMode)
{
case ProductHelper.Appendix.Appendix1:
sql = "Appendix1Id NOT IN ('" + _AppendixId.ToString() + "')";
orderBy = new string[] { "Appendix1Code" };
ProductAppendix1Ex.LoadCombo(ref cboParentAppendix, "Appendix1Code", true, true, "", sql, orderBy);
break;
case ProductHelper.Appendix.Appendix2:
sql = "Appendix1Id NOT IN ('" + this.AppendixId.ToString() + "')";
orderBy = new string[] { "Appendix1Code" };
ProductAppendix1Ex.LoadCombo(ref cboParentAppendix, "Appendix1Code", true, true, "", sql, orderBy);
break;
case ProductHelper.Appendix.Appendix3:
sql = "Appendix3Id NOT IN ('" + this.AppendixId.ToString() + "')";
orderBy = new string[] { "Appendix3Code" };
ProductAppendix3Ex.LoadCombo(ref cboParentAppendix, "Appendix3Code", true, true, "", sql, orderBy);
break;
}
cboParentAppendix.SelectedIndex = cboParentAppendix.Items.Count - 1;
}
private void FillAppendixe3()
{
string[] orderBy = new string[] { "Appendix3Code" };
ProductAppendix3Ex.LoadCombo(ref cboAppendix3, "Appendix3Code", false, true, "", "", orderBy);
/**
* cboAppendix3.Items.Clear();
*
* string[] orderBy = new string[] { "Appendix3Code" };
* ProductAppendix3Collection oA3List = ProductAppendix3.LoadCollection(orderBy, true);
* oA3List.Add(new ProductAppendix3());
* cboAppendix3.DataSource = oA3List;
* cboAppendix3.DisplayMember = "Appendix3Code";
* cboAppendix3.ValueMember = "Appendix3Id";
*/
//cboAppendix3.SelectedIndex = cboAppendix3.Items.Count - 1;
}
private void FillComboBox()
{
string textField = this.AppendixType.Trim() + "Code";
switch (this.AppendixType.Trim().ToUpper())
{
case "APPENDIX1":
ProductAppendix1Ex.LoadCombo(ref cmbFrom, textField, false);
ProductAppendix1Ex.LoadCombo(ref cmbTo, textField, false);
break;
case "APPENDIX2":
ProductAppendix2Ex.LoadCombo(ref cmbFrom, textField, false);
ProductAppendix2Ex.LoadCombo(ref cmbTo, textField, false);
break;
case "APPENDIX3":
ProductAppendix3Ex.LoadCombo(ref cmbFrom, textField, false);
ProductAppendix3Ex.LoadCombo(ref cmbTo, textField, false);
break;
}
cmbTo.SelectedIndex = cmbTo.Items.Count - 1;
}