public PlanDetailData GetPlanDetailData(double plan, int month, int day, double product)
{
PlanDetailData data = new PlanDetailData();
DataTable dt = PlanInvDAL.GetPlanDetailData(plan, month, day, product);
if (dt.Rows.Count == 1)
{
DataRow dRow = dt.Rows[0];
if (!Convert.IsDBNull(dRow["MAXIMUM"])) data.MAXIMUM = Convert.ToDouble(dRow["MAXIMUM"]);
if (!Convert.IsDBNull(dRow["MINIMUM"])) data.MINIMUM = Convert.ToDouble(dRow["MINIMUM"]);
if (!Convert.IsDBNull(dRow["YEAR"])) data.YEAR = Convert.ToInt32(dRow["YEAR"]);
if (!Convert.IsDBNull(dRow["MONTH"])) data.MONTH = Convert.ToInt32(dRow["MONTH"]);
if (!Convert.IsDBNull(dRow["DAY"])) data.DAY = Convert.ToInt32(dRow["DAY"]);
if (!Convert.IsDBNull(dRow["PDLEADTIME"])) data.PDLEADTIME = Convert.ToDouble(dRow["PDLEADTIME"]);
if (!Convert.IsDBNull(dRow["PDLOID"])) data.PDLOID = Convert.ToDouble(dRow["PDLOID"]);
if (!Convert.IsDBNull(dRow["PDLOTSIZE"])) data.PDLOTSIZE = Convert.ToDouble(dRow["PDLOTSIZE"]);
if (!Convert.IsDBNull(dRow["PDQTY"])) data.PDQTY = Convert.ToDouble(dRow["PDQTY"]);
if (!Convert.IsDBNull(dRow["PLAN"])) data.PLAN = Convert.ToDouble(dRow["PLAN"]);
if (!Convert.IsDBNull(dRow["POLEADTIME"])) data.POLEADTIME = Convert.ToDouble(dRow["POLEADTIME"]);
if (!Convert.IsDBNull(dRow["POLOID"])) data.POLOID = Convert.ToDouble(dRow["POLOID"]);
if (!Convert.IsDBNull(dRow["POLOTSIZE"])) data.POLOTSIZE = Convert.ToDouble(dRow["POLOTSIZE"]);
if (!Convert.IsDBNull(dRow["POQTY"])) data.POQTY = Convert.ToDouble(dRow["POQTY"]);
if (!Convert.IsDBNull(dRow["PRODUCT"])) data.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
if (!Convert.IsDBNull(dRow["PRODUCTNAME"])) data.PRODUCTNAME = dRow["PRODUCTNAME"].ToString();
if (!Convert.IsDBNull(dRow["UNITNAME"])) data.UNITNAME = dRow["UNITNAME"].ToString();
if (!Convert.IsDBNull(dRow["STATUS"])) data.STATUS = dRow["STATUS"].ToString();
if (!Convert.IsDBNull(dRow["RECEIVELOID"])) data.RECEIVELOID = Convert.ToDouble(dRow["RECEIVELOID"]);
}
return data;
}
private void SetData(PlanDetailData data)
{
DateTime pdDate = new DateTime(1, 1, 1);
DateTime poDate = new DateTime(1, 1, 1);
DateTime receiveDate = new DateTime(data.YEAR, data.MONTH, data.DAY);
this.lblProduct.Text = data.PRODUCT.ToString();
this.lblProductName.Text = data.PRODUCTNAME;
this.lblUnitName.Text = data.UNITNAME;
this.lblMin.Text = data.MINIMUM.ToString(Constz.IntFormat);
this.lblMax.Text = data.MAXIMUM.ToString(Constz.IntFormat);
this.lblDate.Text = receiveDate.ToString(Constz.DateFormat);
this.lblStatus.Text = data.STATUS;
this.lblPOLotSize.Text = data.POLOTSIZE.ToString(Constz.IntFormat);
this.lblPOLeadTime.Text = data.POLEADTIME.ToString(Constz.IntFormat);
this.txtPOQty.Text = data.POQTY.ToString(Constz.IntFormat);
poDate = new DateTime(data.YEAR, data.MONTH, data.DAY).AddDays(-data.POLEADTIME);
this.lblPODate.Text = (data.POLEADTIME == 0 ? "-" : poDate.ToString(Constz.DateFormat));
this.lblPOLOID.Text = data.POLOID.ToString();
this.lblPDLotSize.Text = data.PDLOTSIZE.ToString(Constz.IntFormat);
this.lblPDLeadTime.Text = data.PDLEADTIME.ToString(Constz.IntFormat);
this.txtPDQty.Text = data.PDQTY.ToString(Constz.IntFormat);
pdDate = new DateTime(data.YEAR, data.MONTH, data.DAY).AddDays(-data.PDLEADTIME);
this.lblPDDate.Text = (data.PDLEADTIME == 0 ? "-" : pdDate.ToString(Constz.DateFormat));
this.lblPDLOID.Text = data.PDLOID.ToString();
this.lblReceiveLOID.Text = data.RECEIVELOID.ToString();
// Çѹ·Õè¨ÐÃѺà¢éÒµéͧÁÒ¡¡ÇèÒÇѹ·Õè»Ñ¨¨ØºÑ¹ 1 Çѹ
// Çѹ·ÕèÊÑ觼ÅÔµËÃ×ÍÇѹ·ÕèÊÑ觫×é͵éͧÁÒ¡¡ÇèÒÇѹ·Õè»Ñ¨¨ØºÑ¹
// ʶҹСÓÅѧ·ÓÃÒ¡ÒÃ
bool canEdit = true;
canEdit = receiveDate >= DateTime.Today.AddDays(1) && data.STATUS == Constz.Requisition.Status.Waiting.Code && pdDate >= DateTime.Today && poDate >= DateTime.Today;
this.ctlToolbar.BtnSaveShow = canEdit;
SetMaterial(data.PLAN, data.PRODUCT, data.MONTH, data.DAY);
this.txtPDQty.CssClass = (this.ctlToolbar.BtnSaveShow ? "zTextboxR" : "zTextboxR-View");
this.txtPDQty.ReadOnly = !this.ctlToolbar.BtnSaveShow;
this.txtPOQty.CssClass = (this.ctlToolbar.BtnSaveShow ? "zTextboxR" : "zTextboxR-View");
this.txtPOQty.ReadOnly = !this.ctlToolbar.BtnSaveShow;
}
