Пример #1
0
        public void CheckRegistration()
        {
            chkSupply.Enabled   = true;
            chkContract.Enabled = true;
            chkService.Enabled  = true;


            DataTable dt = new DataTable();
            DataTable dtt;
            DataView  dv;
            bool      bSCheck;
            bool      bCCheck;
            bool      bHCheck;


            bool bRSCheck;
            bool bRCCheck;
            bool bRHCheck;


            int lCount = 0;

            dt = m_oRegister.GetRegTrans(Convert.ToInt32(txtVendorName.Tag));
            dv = new DataView(dt);
            if (m_lRegTransId != 0)
            {
                dv.RowFilter = "StatusType = 'B' and RegTransID < " + m_lRegTransId;
            }
            else
            {
                dv.RowFilter = "StatusType = 'B'";
            }

            dtt = new DataTable();
            dtt = dv.ToTable();

            for (lCount = 0; lCount < dtt.Rows.Count; lCount++)
            {
                if (Convert.ToBoolean(dtt.Rows[lCount]["Supply"].ToString()) == true)
                {
                    chkSupply.Checked = false;
                    chkSupply.Enabled = false;
                }

                if (Convert.ToBoolean(dtt.Rows[lCount]["Contract"].ToString()) == true)
                {
                    chkContract.Checked = false;
                    chkContract.Enabled = false;
                }

                if (Convert.ToBoolean(dtt.Rows[lCount]["Service"].ToString()) == true)
                {
                    chkService.Checked = false;
                    chkService.Enabled = false;
                }
            }
            dv = new DataView(dt);
            if (m_lRegTransId != 0)
            {
                dv.RowFilter = "StatusType = 'S' and RegTransID < " + m_lRegTransId;
            }
            else
            {
                dv.RowFilter = "StatusType = 'S'";
            }
            dtt     = new DataTable();
            dtt     = dv.ToTable();
            bSCheck = false;
            bCCheck = false;
            bHCheck = false;
            for (lCount = 0; lCount < dtt.Rows.Count; lCount++)
            {
                if (Convert.ToBoolean(dtt.Rows[lCount]["Supply"].ToString()) == true & bSCheck == false)
                {
                    dtpSFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["STDate"].ToString()).AddDays(1);
                    bSCheck = true;
                }

                if (Convert.ToBoolean(dtt.Rows[lCount]["Contract"].ToString()) == true & bCCheck == false)
                {
                    dtpCFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["CTDate"].ToString()).AddDays(1);
                    bCCheck = true;
                }

                if (Convert.ToBoolean(dtt.Rows[lCount]["Service"].ToString()) == true & bHCheck == false)
                {
                    dtpHFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["HTDate"].ToString()).AddDays(1);
                    bHCheck = true;
                }
            }

            dv = new DataView(dt);
            if (m_lRegTransId != 0)
            {
                dv.RowFilter = "StatusType = 'R' and RegTransID < " + m_lRegTransId;
            }
            else
            {
                dv.RowFilter = "StatusType = 'R'";
            }
            dtt      = new DataTable();
            dtt      = dv.ToTable();
            bRSCheck = false;
            bRCCheck = false;
            bRHCheck = false;
            for (lCount = 0; lCount < dtt.Rows.Count; lCount++)
            {
                if (Convert.ToBoolean(dtt.Rows[lCount]["Supply"].ToString()) == true & bRSCheck == false)
                {
                    if (dtpSFDate.Properties.MinValue < Convert.ToDateTime(dtt.Rows[lCount]["STDate"].ToString()).AddDays(1))
                    {
                        dtpSFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["STDate"].ToString()).AddDays(1);
                        bRSCheck = true;
                    }
                }

                if (Convert.ToBoolean(dtt.Rows[lCount]["Contract"].ToString()) == true & bRCCheck == false)
                {
                    if (dtpCFDate.Properties.MinValue < Convert.ToDateTime(dtt.Rows[lCount]["CTDate"].ToString()).AddDays(1))
                    {
                        dtpCFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["CTDate"].ToString()).AddDays(1);
                        bRCCheck = true;
                    }
                }

                if (Convert.ToBoolean(dtt.Rows[lCount]["Service"].ToString()) == true & bRHCheck == false)
                {
                    if (dtpHFDate.Properties.MinValue < Convert.ToDateTime(dtt.Rows[lCount]["HTDate"].ToString()).AddDays(1))
                    {
                        dtpHFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["HTDate"].ToString()).AddDays(1);
                        bRHCheck = true;
                    }
                }
            }

            if ((bSCheck == false & bRSCheck == false) | (bCCheck == false & bRCCheck == false) | (bHCheck == false & bRHCheck == false))
            {
                DataTable dtM = new DataTable();
                dtM = m_oRegister.GetRegistration(Convert.ToInt32(txtVendorName.Tag));
                if (dtM.Rows.Count > 0)
                {
                    if (Convert.ToBoolean(dtM.Rows[0]["Supply"].ToString()) == true)
                    {
                        if (bSCheck == false & bRSCheck == false)
                        {
                            dtpSFDate.Properties.MinValue = Convert.ToDateTime(dtM.Rows[0]["STDate"].ToString()).AddDays(1);
                        }
                    }

                    if (Convert.ToBoolean(dtM.Rows[0]["Contract"].ToString()) == true)
                    {
                        if (bCCheck == false & bRCCheck == false)
                        {
                            dtpCFDate.Properties.MinValue = Convert.ToDateTime(dtM.Rows[0]["CTDate"].ToString()).AddDays(1);
                        }
                    }

                    if (Convert.ToBoolean(dtM.Rows[0]["Service"].ToString()) == true)
                    {
                        if (bHCheck == false & bRHCheck == false)
                        {
                            dtpHFDate.Properties.MinValue = Convert.ToDateTime(dtM.Rows[0]["HTDate"].ToString()).AddDays(1);
                        }
                    }
                }
            }
        }
Пример #2
0
        private void PopulateData()
        {
            DataTable dt;

            dt = new DataTable();
            dt = m_oRegister.GetRegistration(m_lVendorId);
            if (dt.Rows.Count > 0)
            {
                m_lRegisterId = Convert.ToInt32(dt.Rows[0]["RegisterId"].ToString());
                dtpDate.Value = Convert.ToDateTime(dt.Rows[0]["RegDate"].ToString());
                m_dOldDate    = Convert.ToDateTime(dt.Rows[0]["RegDate"].ToString());
                txtRegNo.Text = dt.Rows[0]["RegNo"].ToString();
                if (Convert.ToBoolean(dt.Rows[0]["Supply"].ToString()) == true)
                {
                    chkSupply.Checked = true;
                    dtpSFDate.Value   = Convert.ToDateTime(dt.Rows[0]["SFDate"].ToString());
                    dtpSTDate.Value   = Convert.ToDateTime(dt.Rows[0]["STDate"].ToString());
                    if (Convert.ToBoolean(dt.Rows[0]["SLifeTime"].ToString()) == true)
                    {
                        chkSLife.Checked = true;
                    }
                    //txtSGradeName.Text = dt.Rows[0]["SGrade"].ToString();
                    //txtSGradeName.Tag = dt.Rows[0]["SGradeID"].ToString();
                }

                if (Convert.ToBoolean(dt.Rows[0]["Contract"].ToString()) == true)
                {
                    chkContract.Checked = true;
                    dtpCFDate.Value     = Convert.ToDateTime(dt.Rows[0]["CFDate"].ToString());
                    dtpCTDate.Value     = Convert.ToDateTime(dt.Rows[0]["CTDate"].ToString());
                    if (Convert.ToBoolean(dt.Rows[0]["CLifeTime"].ToString()) == true)
                    {
                        chkCLife.Checked = true;
                    }
                    //txtCGradeName.Text = dt.Rows[0]["CGrade"].ToString();
                    //txtCGradeName.Tag = dt.Rows[0]["CGradeID"].ToString();
                }

                if (Convert.ToBoolean(dt.Rows[0]["Service"].ToString()) == true)
                {
                    chkService.Checked = true;
                    dtpHFDate.Value    = Convert.ToDateTime(dt.Rows[0]["HFDate"].ToString());
                    dtpHTDate.Value    = Convert.ToDateTime(dt.Rows[0]["HTDate"].ToString());
                    if (Convert.ToBoolean(dt.Rows[0]["HLifeTime"].ToString()) == true)
                    {
                        chkHLife.Checked = true;
                    }
                    //txtHGradeName.Text = dt.Rows[0]["HGrade"].ToString();
                    //txtHGradeName.Tag = dt.Rows[0]["HGradeID"].ToString();
                }
                txtRemarks.Text = dt.Rows[0]["Remarks"].ToString();
            }
            if (m_lRegisterId != 0)
            {
                if (m_oRegister.CheckRegTrans(m_lVendorId) == true)
                {
                    cmdRemove.Visible = false;
                    cmdOK.Enabled     = false;
                }
                else
                {
                    cmdRemove.Visible = true;
                    cmdOK.Enabled     = true;
                }
            }

            UpdateRegNo();
        }