コード例 #1
0
        private void ucRentalRequestStatusChange_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);

            string sSelect = "select count(*) from alert_rental_setup";

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_rental_setup (RentalStartEnabled,RentalStartPreEnabled,RentalEndEnabled,RentalEndPreEnabled,RentalStatus_Entered,RentalStatus_Active,RentalStatus_Complete,RentalStatus_Canceled)" +
                                 "values (0,0,0,0,0,0,0,0)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            sSelect             = "select isnull(RentalStatus_Entered,0) from alert_rental_setup";
            ceEntered.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            sSelect            = "select isnull(RentalStatus_Active,0) from alert_rental_setup";
            ceActive.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            sSelect = "select isnull(RentalStatus_Complete,0) from alert_rental_setup";
            ceComplete.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            sSelect = "select isnull(RentalStatus_Canceled,0) from alert_rental_setup";
            ceCanceled.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
        }
コード例 #2
0
ファイル: ucLotHold.cs プロジェクト: haizhizhong/Reflex11
        private void ucLotHold_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);
            TR_Conn.ConnectionString = Connection.TRConnection;
            daTolerance.Fill(dsTolerance);

            string sSelect = "select count(*) from alert_lot_hold_setup";

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_lot_hold_setup (id, OnHold_On, PreExpiry_On, Expiry_On, reply_tolerance) values (1, 'F', 'F', 'F', 1)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            sSelect = "select isnull(OnHold_On,'F'), isnull(PreExpiry_On,'F'), isnull(Expiry_On,'F'), isnull(reply_tolerance,1) from alert_lot_hold_setup";
            DataTable dt = Connection.SQLExecutor.ExecuteDataAdapter(sSelect, Connection.TRConnection);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    DataRow dr = dt.Rows[0];
                    if (dr != null)
                    {
                        chkOnHold.EditValue    = dr[0];
                        chkPreExpire.EditValue = dr[1];
                        chkExpiry.EditValue    = dr[2];
                        txtTolerance.EditValue = dr[3];
                    }
                }
            }
        }
コード例 #3
0
        private void ucCollectionReminders_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);
            TR_Conn.ConnectionString = Connection.TRConnection;

            string sSelect = "select count(*) from alert_land_reminder_setup where AlertID=" + AlertPointID;

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_land_reminder_setup (AlertID, X_Days) values (" + AlertPointID + ", 0)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            sSelect           = "select isnull(X_Days,0) from alert_land_reminder_setup where AlertID=" + AlertPointID;
            txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            LoadCommPurpose();
            LoadDocMergeFunc();

            daComPur.SelectCommand.Parameters["@AlertID"].Value = AlertPointID;
            daComPur.Fill(dsComPur1);

            daDocMerge.SelectCommand.Parameters["@AlertID"].Value = AlertPointID;
            daDocMerge.Fill(dsDocMerge1);

            labelControl1.Focus();
        }
コード例 #4
0
        private void ucEmpCertificateExpiry_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);

            string sSelect = "select isnull(DaysPrior,0) from hr_cntl";

            txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            labelControl1.Focus();
        }
コード例 #5
0
        private void ucFinancingPaymentDue_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);

            string sSelect = "select isnull(FinancingPastDueDays,0) from Alert_Properties_Setup";

            isLoading         = true;
            txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
            isLoading         = false;
            labelControl1.Focus();
        }
コード例 #6
0
        private void ucLatePaymentReminder_Load(object sender, EventArgs e)
        {
            LoadUserControls();

            DevXMgr.FormInit(this);
            string sSelect = "select count(*) from alert_land_reminder_setup where AlertID=" + AlertPointID;

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_land_reminder_setup (AlertID, X_Days, Recurrence_Days, Recurrence_Months) values (" + AlertPointID + ", 0, 0, 0)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            LoadAlertSetup();
        }
コード例 #7
0
        private void ucProbationaryBuildersReminder_Load(object sender, EventArgs e)
        {
            LoadUserControls();

            DevXMgr.FormInit(this);
            string sSelect = "select count(*) from alert_land_reminder_setup where AlertID=" + AlertPointID;

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_land_reminder_setup (AlertID, X_Days) values (" + AlertPointID + ", 0)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            sSelect           = "select isnull(X_Days,0) from alert_land_reminder_setup where AlertID=" + AlertPointID;
            txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
            labelControl1.Focus();
        }
コード例 #8
0
        private void ucHomeOwner_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);

            string sSelect = "select count(*) from alert_lot_hold_setup";

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_lot_hold_setup (id, OnHold_On, PreExpiry_On, Expiry_On, homeowner_confirmed_days, DownPayment_Due_Days) values (1, 'F', 'F', 'F', 0, 0)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            sSelect           = "select isnull(homeowner_confirmed_days,0) from alert_lot_hold_setup";
            txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            labelControl1.Focus();
        }
コード例 #9
0
        private void ucRentalStartNotification_Load(object sender, EventArgs e)
        {
            DevXMgr.FormInit(this);

            string sSelect = "select count(*) from alert_rental_setup";

            if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
            {
                string sInsert = "insert into alert_rental_setup (RentalStartEnabled,RentalStartPreEnabled,RentalEndEnabled,RentalEndPreEnabled,RentalStatus_Entered,RentalStatus_Active,RentalStatus_Complete,RentalStatus_Canceled)" +
                                 "values (0,0,0,0,0,0,0,0)";
                Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
            }

            sSelect = "select isnull(RentalStartEnabled,0) from alert_rental_setup";
            ceRentalStart.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);

            sSelect = "select isnull(RentalStartPreEnabled,0) from alert_rental_setup";
            ceRentalPreStart.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);


            sqlTRConnection.ConnectionString = Connection.TRConnection;
            daRentalStartPreAlerts.Fill(dsRentalStartPreAlerts1);
        }
コード例 #10
0
 private void ucPayoutExtensionReminder_Load(object sender, EventArgs e)
 {
     LoadUserControls();
     DevXMgr.FormInit(this);
 }
コード例 #11
0
 private void ucPastDuePaymentReminder_Load(object sender, EventArgs e)
 {
     LoadUserControls();
     DevXMgr.FormInit(this);
 }