private void cbPrdOrder_SelectedIndexChanged(object sender, EventArgs e)
{
if ((this.cbPrdOrder.SelectedIndex != 0) && (!string.IsNullOrEmpty(this.cbPrdOrder.Text.Trim())))
{
this.lblMaterialName.Text = this.cbPrdOrder.SelectedValue.ToString();
DataSet dsDetail = new DataSet();
try
{
NP_Cls.SqlSelect = "SELECT t_PrdOrder.MaterialCode, t_PrdOrder.MaterialName, PrdQuantity,isnull(GrPrdQuantity,0)GrPrdQuantity, t_PrdOrder.PlantCode, PlantName, BOMVersion, t_PrdOrder.LocCode, LocName,m_Material.UnitCode,m_Unit.UnitName,LastGP.DocNumber FROM t_PrdOrder inner join m_Material on t_PrdOrder.MaterialCode = m_Material.MaterialCode inner join m_Unit on m_Unit.UnitCode =m_Material.UnitCode left join (Select Top(1) DocNumber,RefNumber from [t_StockMovement] where DocNumber like 'GP%' order by DateCreate DESC)as LastGP on LastGP.RefNumber = t_PrdOrder.PrdONumber WHERE (PrdONumber = N'" + this.cbPrdOrder.Text.Trim() + "')";
dsDetail = NP.GetClientDataSet(NP_Cls.SqlSelect);
this.lblUnit.Text = dsDetail.Tables[0].Rows[0]["UnitCode"].ToString();
this.lblLastGP.Text = dsDetail.Tables[0].Rows[0]["DocNumber"].ToString() != "" ? dsDetail.Tables[0].Rows[0]["DocNumber"].ToString() : "-";
this.lblUnitName.Text = dsDetail.Tables[0].Rows[0]["UnitName"].ToString();
this.lblUnitCode.Text = dsDetail.Tables[0].Rows[0]["UnitCode"].ToString();
this.lblPlantCode.Text = dsDetail.Tables[0].Rows[0]["PlantCode"].ToString();
this.lblLocCode.Text = dsDetail.Tables[0].Rows[0]["LocCode"].ToString();
this.lblBomVer.Text = dsDetail.Tables[0].Rows[0]["BOMVersion"].ToString();
this.lblPlant.Text = dsDetail.Tables[0].Rows[0]["PlantName"].ToString();
this.lblLoc.Text = dsDetail.Tables[0].Rows[0]["LocName"].ToString();
this.lblMatCode.Text = dsDetail.Tables[0].Rows[0]["MaterialCode"].ToString();
this.lblBatch.Text = NP_Cls._genSelectBatch(dsDetail.Tables[0].Rows[0]["MaterialCode"].ToString());
this.txtQty.Text = (Convert.ToDouble(dsDetail.Tables[0].Rows[0]["PrdQuantity"].ToString()) - Convert.ToDouble(dsDetail.Tables[0].Rows[0]["GrPrdQuantity"].ToString())).ToString();
this.lblGrPrdQty.Text = dsDetail.Tables[0].Rows[0]["GrPrdQuantity"].ToString();
this.lblPrdQty.Text = dsDetail.Tables[0].Rows[0]["PrdQuantity"].ToString();
this.PrdQty = Convert.ToDouble(dsDetail.Tables[0].Rows[0]["PrdQuantity"].ToString());
this.txtQty.Select(); this.txtQty.SelectAll();
}
catch (SqlException ex)
{
NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Detail : " + ex.Message); return;
}
}
else
{
Clear();
this.cbPrdOrder.Focus();
}
}
