private void BankEntry_Load(object sender, EventArgs e) { //ADDED BY DHRUB ON 07/05/2014 ViewGrid.Size = new Size(1000, 506); lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); lblTitle.Text = this.Text; //Populating Payment Type Combo strSQL = "SELECT PAYMENT_TYPE_ID," + " PAYMENT_TYPE_DESCRIPTION " + "FROM MST_PAYMENT_TYPE " + "ORDER BY PAYMENT_TYPE_ID "; if (dmlService.J_PopulateComboBox(strSQL, ref cmbFilterPaymentType) == false) { return; } strSQL = "SELECT COMPANY_ID," + " COMPANY_NAME " + "FROM MST_COMPANY " + "WHERE BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND COMPANY_ID = " + BS_CompanyId.PDSInfotech + " " + "ORDER BY COMPANY_NAME "; if (dmlService.J_PopulateComboBox(strSQL, ref cmbCompany, 1) == false) { return; } chkIncompleteRecords.Checked = true; }
private void ClearControls() { txtPartyName.Text = ""; txtAddress1.Text = ""; txtAddress2.Text = ""; txtAddress3.Text = ""; txtCity.Text = ""; txtPin.Text = ""; txtContactPersonName.Text = ""; txtMobileNo.Text = ""; txtPhone.Text = ""; txtFaxNo.Text = ""; txtEmailID.Text = ""; txtVatNo.Text = ""; grpSort.Visible = false; grpSearch.Visible = false; txtPartyNameSearch.Text = ""; strSQL = "SELECT PARTY_CATEGORY_ID, " + " PARTY_CATEGORY_DESCRIPTION " + "FROM MST_PARTY_CATEGORY " + "WHERE INACTIVE_FLAG = 0 " + "ORDER BY PARTY_CATEGORY_ID "; dmlService.J_PopulateComboBox(strSQL, ref cmbPartyCategory, J_ComboBoxDefaultText.NO); }
private void ClearControls() { strSQL = "SELECT USER_ID," + " LOGIN_ID " + " FROM MST_USER " + " WHERE BRANCH_ID = " + J_Var.J_pBranchId + " " + " AND " + cmnService.J_SQLDBFormat("LOGIN_ID", J_SQLColFormat.UCase) + " <> 'ADMIN' " + " AND USER_ID <> " + J_Var.J_pUserId + " " + " ORDER BY LOGIN_ID "; dmlService.J_PopulateComboBox(strSQL, ref cmbUserId); PopulateDetailGrid(); }
private void BankEntry_Load(object sender, EventArgs e) { //Added By dhrub on 03/05/2014 for Set the Grid Size ViewGrid.Size = new Size(1000, 510); lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); lblTitle.Text = this.Text; strSQL = "SELECT COMPANY_ID," + " COMPANY_NAME " + "FROM MST_COMPANY " + "WHERE BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND COMPANY_ID = " + BS_CompanyId.PDSInfotech + " " + "ORDER BY COMPANY_NAME "; if (dmlService.J_PopulateComboBox(strSQL, ref cmbCompany, 1) == false) { return; } strSQL = "SELECT BANK_ID," + " BANK_NAME " + "FROM MST_BANK " + "ORDER BY BANK_NAME "; if (dmlService.J_PopulateComboBox(strSQL, ref cmbSelectBank) == false) { return; } cmbCompany.Enabled = true; BtnSort.BackColor = Color.LightGray; BtnSort.Enabled = false; BtnPrint.BackColor = Color.LightGray; BtnPrint.Enabled = false; chkCancelledEntry.Checked = false; }
// #endregion #region User Defined Events #region BankEntry_Load private void BankEntry_Load(object sender, EventArgs e) { //Added By dhrub on 03/05/2014 for Set the Grid Size //ViewGrid.Size = new Size(1000, 510); // lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); // BtnAdd.Enabled = false; BtnEdit.Enabled = false; BtnDelete.Enabled = false; BtnRefresh.Enabled = false; BtnSearch.Enabled = false; BtnSort.Enabled = false; BtnSave.Enabled = false; BtnCancel.Enabled = false; BtnPrint.Enabled = false; BtnAdd.BackColor = Color.LightGray; BtnEdit.BackColor = Color.LightGray; BtnSave.BackColor = Color.LightGray; BtnCancel.BackColor = Color.LightGray; BtnSort.BackColor = Color.LightGray; BtnSearch.BackColor = Color.LightGray; BtnDelete.BackColor = Color.LightGray; BtnRefresh.BackColor = Color.LightGray; BtnPrint.BackColor = Color.LightGray; lblTitle.Text = this.Text; string strSQL1 = "SELECT ITEM_ID," + " ITEM_NAME " + "FROM MST_ITEM " + "WHERE ONLINE_FLAG = 1 " + "ORDER BY DEFAULT_ITEM_ONLINE_OFFLINE_BILLING DESC "; blnExit = false; if (dmlService.J_PopulateComboBox(strSQL1, ref cmbItemName) == false) { return; } blnExit = true; cmbItemName.Enabled = true; BtnSort.BackColor = Color.LightGray; BtnSort.Enabled = false; BtnPrint.BackColor = Color.LightGray; BtnPrint.Enabled = false; chkCancelledEntry.Checked = false; cmbItemName.Select(); }
private void ClearControls() { strSQL = "SELECT BRANCH_ID," + " BRANCH_NAME " + "FROM MST_SETUP " + "ORDER BY BRANCH_NAME "; dmlService.J_PopulateComboBox(strSQL, ref cmbBranch, J_ComboBoxDefaultText.NO); // 1. Table Name // 2. Column Name // 3. Column Data Type // 4. No. of space string[,] strArray = { { "MST_FAYEAR", "FA_BEG_DATE", "D", "3" }, { "MST_FAYEAR", "FA_END_DATE", "D", "3" } }; strSQL = "SELECT FAYEAR_ID," + " " + dmlService.J_ConcateColumns(strArray) + " AS FA_DATE " + "FROM MST_FAYEAR " + "WHERE INACTIVE_FLAG = 0 " + "ORDER BY FA_BEG_DATE DESC"; dmlService.J_PopulateComboBox(strSQL, ref cmbFAYear, J_ComboBoxDefaultText.NO); txtPassword.Text = ""; }
private void ClearControls() { txtInvAmount.Text = ""; txtAddress1.Text = ""; txtAddress2.Text = ""; txtAddress3.Text = ""; txtCity.Text = ""; txtPin.Text = ""; txtContactPersonName.Text = ""; txtMobileNo.Text = ""; txtEmailID.Text = ""; strSQL = @" SELECT PARTY_CATEGORY_ID, PARTY_CATEGORY_DESCRIPTION FROM MST_PARTY_CATEGORY WHERE INACTIVE_FLAG = 0 ORDER BY PARTY_CATEGORY_ID "; dmlService.J_PopulateComboBox(strSQL, ref cmbPartyCategory, J_ComboBoxDefaultText.NO); }
private void ClearControls() { strSQL = "SELECT COMPANY_ID," + " COMPANY_NAME " + " FROM MST_COMPANY " + " ORDER BY COMPANY_NAME "; if (dmlService.J_PopulateComboBox(strSQL, ref cmbCompanyName) == false) { return; } txtPrefix.Text = ""; txtStartNo.Text = "0"; //txtLastNo.Text = "0"; mskLastDate.Text = ""; txtDisplayText.Text = ""; grpSort.Visible = false; grpSearch.Visible = false; txtPrefixSearch.Text = ""; txtStartNoSearch.Text = "0"; txtLastNoSearch.Text = "0"; mskLastDateSearch.Text = ""; }