public static void BuildComboDistinct(DropDownList zCombo, string TableName, string TextFiledName, string ValueFieldName, string OrderFieldName, string WhereString, string BlankText, string BlankValue)
{
ComboSourceFlow cmbFlow = new ComboSourceFlow();
DataTable dt = cmbFlow.GetSourceDistinct(TableName, TextFiledName, ValueFieldName, OrderFieldName, WhereString);
if (dt != null)
{
zCombo.Items.Clear();
zCombo.DataSource = dt;
zCombo.DataTextField = TextFiledName;
zCombo.DataValueField = ValueFieldName;
zCombo.DataBind();
if (BlankText != null || BlankValue != null)
{
ListItem itm = new ListItem(BlankText, BlankValue);
zCombo.Items.Insert(0, itm);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlUtil.SetDblTextBox(this.txtCost);
ControlUtil.SetDblTextBox(this.txtPrice);
ControlUtil.SetIntTextBox(this.txtLeadtime);
ControlUtil.SetIntTextBox(this.txtLeadtimePD);
ControlUtil.SetDblTextBox(this.txtAge);
ControlUtil.SetIntTextBox(this.txtLotSize);
ControlUtil.SetIntTextBox(this.txtLotSizePD);
ControlUtil.SetIntTextBox(this.txtPacksize);
this.rbtOrderType.Items.Clear();
this.rbtOrderType.Items.Add(new ListItem(Constz.OrderType.PO.Name, Constz.OrderType.PO.Code)); ;
this.rbtOrderType.Items.Add(new ListItem(Constz.OrderType.PD.Name, Constz.OrderType.PD.Code));
this.rbtOrderType.Items.Add(new ListItem(Constz.OrderType.AR.Name, Constz.OrderType.AR.Code));
this.rbtIsVat.Items.Clear();
this.rbtIsVat.Items.Add(new ListItem(Constz.VAT.Included.Name, Constz.VAT.Included.Code)); ;
this.rbtIsVat.Items.Add(new ListItem(Constz.VAT.NotIncluded.Name, Constz.VAT.NotIncluded.Code));
this.rbtIsDiscount.Items.Clear();
this.rbtIsDiscount.Items.Add(new ListItem(Constz.Discount.Calculated.Name, Constz.Discount.Calculated.Code)); ;
this.rbtIsDiscount.Items.Add(new ListItem(Constz.Discount.NotCalculated.Name, Constz.Discount.NotCalculated.Code));
this.rbtIsEdit.Items.Clear();
this.rbtIsEdit.Items.Add(new ListItem(Constz.Edit.Editable.Name, Constz.Edit.Editable.Code)); ;
this.rbtIsEdit.Items.Add(new ListItem(Constz.Edit.DisEditable.Name, Constz.Edit.DisEditable.Code));
this.rbtIsRefund.Items.Clear();
this.rbtIsRefund.Items.Add(new ListItem(Constz.Refund.Yes.Name, Constz.Refund.Yes.Code)); ;
this.rbtIsRefund.Items.Add(new ListItem(Constz.Refund.No.Name, Constz.Refund.No.Code));
ComboSourceFlow TypeFlow = new ComboSourceFlow();
this.cmbProductType.DataSource = TypeFlow.GetSource("PRODUCTTYPE", "NAME", "LOID", "NAME", "(TYPE = '" + Constz.ProductType.Type.FG.Code + "' OR TYPE = '" + Constz.ProductType.Type.Others.Code + "') AND ACTIVE = '" + Constz.ActiveStatus.Active + "' ");
this.cmbProductType.DataTextField = "NAME";
this.cmbProductType.DataValueField = "LOID";
this.cmbProductType.DataBind();
ComboSourceFlow UnitFlow = new ComboSourceFlow();
this.cmbUnit.DataSource = UnitFlow.GetSource("UNIT", "NAME", "LOID", "NAME", "ACTIVE = '" + Constz.ActiveStatus.Active + "' AND (TYPE = '" + Constz.UnitType.FG.Code + "' OR TYPE = '" + Constz.UnitType.ALL.Code + "')");
this.cmbUnit.DataTextField = "NAME";
this.cmbUnit.DataValueField = "LOID";
this.cmbUnit.DataBind();
ComboSourceFlow UnitPackFlow = new ComboSourceFlow();
this.cmbUnitPack.DataSource = UnitPackFlow.GetSource("UNIT", "NAME", "LOID", "NAME", "ACTIVE = '" + Constz.ActiveStatus.Active + "' ");
this.cmbUnitPack.DataTextField = "NAME";
this.cmbUnitPack.DataValueField = "LOID";
this.cmbUnitPack.DataBind();
ComboSourceFlow ProduceGroupFlow = new ComboSourceFlow();
this.cmbProduceGroup.DataSource = TypeFlow.GetSource("PRODUCEGROUP", "NAME", "LOID", "RANK", "");
this.cmbProduceGroup.DataTextField = "NAME";
this.cmbProduceGroup.DataValueField = "LOID";
this.cmbProduceGroup.DataBind();
ResetState(Convert.ToDouble(Request["loid"] == null ? "0" : Request["loid"]));
getDataToGroup();
CheckOrderType();
}
}
public static void BuildCombo(ComboBox zCombo, string TableName, string TextFiledName, string ValueFieldName, string OrderFieldName, string WhereString, string BlankText, string BlankValue)
{
ComboSourceFlow cmbFlow = new ComboSourceFlow();
DataTable dt = cmbFlow.GetSource(TableName, TextFiledName, ValueFieldName, OrderFieldName, WhereString);
if (dt != null)
{
//zCombo.Items.Clear(); UPDATE BY NANG
if (BlankText != null || BlankValue != null)
{
DataRow dRow = dt.NewRow();
dRow[TextFiledName] = BlankText;
dRow[ValueFieldName] = BlankValue;
dt.Rows.InsertAt(dRow, 0);
}
zCombo.DataSource = dt;
zCombo.DisplayMember = TextFiledName;
zCombo.ValueMember = ValueFieldName;
}
}