private void GetStockByMachine()
{
try
{
using (QuerySqliteBLL queryBll = new QuerySqliteBLL())
{
dtResult = queryBll.GetStockbyMachine();
}
this.grvSTK_Machine.DataSource = dtResult;
this.grvSTK_Machine.DataBind();
Session["LAST_UPDATE"] = DateTime.Now;
}
catch (Exception ex)
{
}
}
private void GetDeliveryDetail(string partyid, DateTime date, string wh, string status)
{
DataTable dtResult;
try
{
using (QuerySqliteBLL queryBll = new QuerySqliteBLL())
{
dtResult = queryBll.GetDeliveryDTL(partyid, date, wh, status);
}
this.grvDelivery_Detail.DataSource = dtResult;
this.grvDelivery_Detail.DataBind();
}
catch (Exception ex)
{
}
}
private void GetStockByCustomer()
{
//DataTable dtResult;
try
{
using (QuerySqliteBLL queryBll = new QuerySqliteBLL())
{
dtResult = queryBll.GetStockbyCustomer();
}
this.grvSTK_Customer.DataSource = dtResult;
this.grvSTK_Customer.DataBind();
Session["LAST_UPDATE"] = DateTime.Now;
}
catch (Exception ex)
{
}
}
private void BindingDeliveryBoard()
{
//DataTable dtResult;
try
{
using (QuerySqliteBLL queryBll = new QuerySqliteBLL())
{
dtResult = queryBll.GetDeliveryBoardControl();
}
this.ASPxGridView1.DataSource = dtResult;
this.ASPxGridView1.DataBind();
Session["LAST_UPDATE"] = DateTime.Now;
}
catch (Exception ex)
{
}
}
private void BindingBandColumns()
{
int i = 1;
List <DateTime> listDt;
DevExpress.Web.ASPxGridView.GridViewBandColumn banShowDate;
using (QuerySqliteBLL custBll = new QuerySqliteBLL())
{
listDt = custBll.Get3DayWithoutSun(DateTime.Now);
}
if (listDt != null)
{
foreach (DateTime dt in listDt)
{
banShowDate = (DevExpress.Web.ASPxGridView.GridViewBandColumn) this.ASPxGridView1.Columns[i++];
banShowDate.Caption = dt.ToString("dd/MM/yyyy");
}
}
}
private void GetStockByMinmax()
{
string s1 = string.Empty;
string s2 = string.Empty;
string s3 = string.Empty;
if (this.cblstatus.Items[0].Selected)
{
s1 = cblstatus.Items[0].Value.ToString();
}
if (this.cblstatus.Items[1].Selected)
{
s2 = cblstatus.Items[1].Value.ToString();
}
if (this.cblstatus.Items[2].Selected)
{
s3 = cblstatus.Items[2].Value.ToString();
}
//DataTable dtResult;
try
{
using (QuerySqliteBLL queryBll = new QuerySqliteBLL())
{
dtResult = queryBll.GetStockbyMinmax(s1, s2, s3);
}
this.grvSTK_Minmax.DataSource = dtResult;
this.grvSTK_Minmax.DataBind();
Session["LAST_UPDATE"] = DateTime.Now;
}
catch (Exception ex)
{
}
}
