示例#1
0
        private void LstTreeFocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            DateTime dt1 = new DateTime();
            DateTime dt2 = new DateTime();

            CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx();
            dtDate.CustomFormat = "MM/dd/yyyy";
            dtDate.Value        = DateTimeHelper.ServerDateTime;
            DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);

            DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode);

            if (dr != null)
            {
                LossAndAdjustment disp  = new LossAndAdjustment();
                DataTable         dtRec = new DataTable();
                if (dr["ParentID"] == DBNull.Value)
                {
                    int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
                    dt1   = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1);
                    dt2   = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1);
                    dtRec = disp.GetTransactionByDateRange(Convert.ToInt32(lkActivity.EditValue), dt1, dt2);
                    string dateString = dr["RefNo"].ToString();
                    lblAdjDate.Text = dateString;
                }
                else
                {
                    dtRec           = disp.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(lkActivity.EditValue), dr["Date"].ToString());
                    lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
                }
                gridAdjustments.DataSource = dtRec;
            }
        }
示例#2
0
 private void cboStores_EditValueChanged(object sender, EventArgs e)
 {
     if (lkActivity.EditValue != null)
     {
         LossAndAdjustment Adj   = new LossAndAdjustment();
         DataTable         dtRec = Adj.GetDistinctAdjustmentDocments(Convert.ToInt32(lkActivity.EditValue));
         /*PopulateDocument(dtRec);*/ lstTree.DataSource = dtRec;
         DateTime dt1 = new DateTime();
         DateTime dt2 = new DateTime();
         CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx();
         dtDate.CustomFormat = "MM/dd/yyyy";
         dtDate.Value        = DateTimeHelper.ServerDateTime;
         DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
         int      yr        = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
         dt1                        = new DateTime(yr, 11, 1);
         dt2                        = new DateTime(dtCurrent.Year, dtCurrent.Month, dtCurrent.Day);
         dtRec                      = Adj.GetTransactionByDateRange(Convert.ToInt32(lkActivity.EditValue), dt1, dt2);
         lblAdjDate.Text            = "Current Year";
         gridAdjustments.DataSource = dtRec;
     }
 }
示例#3
0
        private void dtTo_ValueChanged(object sender, EventArgs e)
        {
            LossAndAdjustment Adj   = new LossAndAdjustment();
            DataTable         dtRec = new DataTable();

            dtFrom.CustomFormat = "MM/dd/yyyy";
            dtTo.CustomFormat   = "MM/dd/yyyy";
            DateTime dteFrom = new DateTime();
            DateTime dteTo   = new DateTime();

            dteFrom = ConvertDate.DateConverter(dtFrom.Text);
            dteTo   = ConvertDate.DateConverter(dtTo.Text);

            if (dteFrom < dteTo)
            {
                dtRec = Adj.GetTransactionByDateRange(Convert.ToInt32(lkActivity.EditValue), dteFrom, dteTo);
            }
            else
            {
                dtRec = Adj.GetAllTransaction(Convert.ToInt32(lkActivity.EditValue));
            }
            gridAdjustments.DataSource = dtRec;
        }