private void BindGrid() { try { //assign search keywords string company_no_box = txtCONTRACT_CODE.Text; string company_name = txtCONSTRACT_NAME.Text; //string email = txtEmail.Text; if (CheckUtility.SearchConditionCheck(this, lblCONTRACT_CODE.Text, txtCONTRACT_CODE.Text, false, Utility.DataType.HALF_ALPHA_NUMERIC, 10, 0) && CheckUtility.SearchConditionCheck(this, lblCONSTRACT_NAME.Text, txtCONSTRACT_NAME.Text, false, Utility.DataType.FULL_WIDTH, 80, 0) ) { frmUsageChargeMasterController oController = new frmUsageChargeMasterController(); DataTable dt = oController.GetUsageChargeMaster(company_no_box, company_name, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); uIUtility.FormatUpdatedat(); } } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGrid() { try { string COMPANY_NO_BOX, COMPANY_NAME, CLOSE_FLG, GD, REQUEST_STATUS, REQ_DATE_FROM, REQ_DATE_TO, QUOTATION_DATE_FROM, QUOTATION_DATE_TO, ORDER_DATE_FROM, ORDER_DATE_TO, SYSTEM_SETTING_STATUS; if (ValidateInputs(out COMPANY_NO_BOX, out COMPANY_NAME, out CLOSE_FLG, out GD, out REQUEST_STATUS, out REQ_DATE_FROM, out REQ_DATE_TO, out QUOTATION_DATE_FROM, out QUOTATION_DATE_TO, out ORDER_DATE_FROM, out ORDER_DATE_TO, out SYSTEM_SETTING_STATUS)) { frmUsageApplicationListController oController = new frmUsageApplicationListController(); DataTable dt = oController.GetApplicationList(COMPANY_NO_BOX, COMPANY_NAME, CLOSE_FLG, GD, REQUEST_STATUS, REQ_DATE_FROM, REQ_DATE_TO, QUOTATION_DATE_FROM, QUOTATION_DATE_TO, ORDER_DATE_FROM, ORDER_DATE_TO, SYSTEM_SETTING_STATUS, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); //check for disable flag uIUtility.CheckForDisableField(); uIUtility.FormatUpdatedat(); } } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGrid() { try { if (CheckUtility.SearchConditionCheck(this, lblFY.Text, txtFY.Text, false, Utility.DataType.HALF_NUMBER, 4, 0) && CheckUtility.SearchConditionCheck(this, lblCompanyNoBox.Text, txtCompanyNoBox.Text, false, Utility.DataType.HALF_ALPHA_NUMERIC, 10, 0) && CheckUtility.SearchConditionCheck(this, lblClientCertificateNo.Text, txtClientCertificateNo.Text, false, Utility.DataType.HALF_ALPHA_NUMERIC, 7, 0) ) { frmClientCertificateListController oController = new frmClientCertificateListController(); DataTable dt = oController.GetClientCertificateList(fy, company_no_box, client_certificate_no, distributionStatus, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); uIUtility.FormatUpdatedat(); } } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGrid() { try { if (!CheckUtility.SearchConditionCheck(this, lblDate.LabelText, txtBilling_Date.Text.Trim(), true, Utility.DataType.YEARMONTH, 7, 6)) { return; } //assign search keywords DateTime YEAR_MONTH = Convert.ToDateTime(txtBilling_Date.Text); String strYearMonth = YEAR_MONTH.ToString("yyyyMM"); //assign search keywords frmInvoiceListController oController = new frmInvoiceListController(); DataSet ds = oController.GetInvoiceList(strYearMonth, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); //need to add more parameter DataTable dtList = ds.Tables[0]; DataTable dtTotal = ds.Tables[1]; InvoiceAmountTotal = 0; keySourceTotal = 0; SupplierMonthlyUsageFeeTotal = 0; SupplierExpenseTotal = 0; SupplierBrowsingInitialExpenseTotal = 0; YearlyUsageFeeTotal = 0; PostalMailTotal = 0; WebTotal = 0; EmailTotal = 0; CreditCardTotal = 0; OtherTotal = 0; foreach (DataRow row in dtTotal.Rows) { keySourceTotal += Convert.ToDecimal(row["KEY_SOURCE_MONTHLY_USAGE_FEE"].ToString()); SupplierExpenseTotal += Convert.ToDecimal(row["SUPPLIER_INITIAL_EXPENSE"].ToString()); SupplierMonthlyUsageFeeTotal += Convert.ToDecimal(row["SUPPLIER_MONTHLY_USAGE_FEE"].ToString()); SupplierBrowsingInitialExpenseTotal += Convert.ToDecimal(row["BROWSING_INITIAL_EXPENSE"].ToString()); YearlyUsageFeeTotal += Convert.ToDecimal(row["YEARLY_USAGE_FEE"].ToString()); InvoiceAmountTotal = keySourceTotal + SupplierExpenseTotal + SupplierMonthlyUsageFeeTotal + SupplierBrowsingInitialExpenseTotal + YearlyUsageFeeTotal; if (row["POSTAL_MAIL"].ToString() == "●") { PostalMailTotal++; } if (row["WEB"].ToString() == "●") { WebTotal++; } if (row["Email"].ToString() == "●") { EmailTotal++; } if (row["CREDIT_CARD"].ToString() == "●") { CreditCardTotal++; } if (row["OTHER"].ToString() == "●") { OtherTotal++; } } //dgvList.Columns["colCOMPANY_NAME"].HeaderText = "請求金額計"; //dgvList.Columns["colKEY_SOURCE_MONTHLY_USAGE_FEE"].HeaderText = keySourceTotal.ToString(); //dgvList.Columns["coLSUPPLIER_INITIAL_EXPENSE"].HeaderText = SupplierExpenseTotal.ToString(); //dgvList.Columns["colSUPPLIER_MONTHLY_USAGE_FEE"].HeaderText = SupplierMonthlyUsageFeeTotal.ToString(); //dgvList.Columns["colBROWSING_INITIAL_EXPENSE"].HeaderText = SupplierBrowsingInitialExpenseTotal.ToString(); //dgvList.Columns["colYEARLY_USAGE_FEE"].HeaderText = YearlyUsageFeeTotal.ToString(); //dgvList.Columns["coLEmail"].HeaderText = EmailTotal.ToString(); //coLEmail //dgvList.Columns["coLPOSTAL_MAIL"].HeaderText = PostalMailTotal.ToString(); //coLEmail //dgvList.Columns["colWEB"].HeaderText = WebTotal.ToString(); //coLEmail //dgvList.Columns["colCREDIT_CARD"].HeaderText = CreditCardTotal.ToString(); //coLEmail //dgvList.Columns["colOTHER"].HeaderText = OtherTotal.ToString(); //coLEmail if (dtList.Rows.Count > 0) { uIUtility.dtList = dtList; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGrid() { try { string company_no_box, company_name, email; if (!CheckUtility.SearchConditionCheck(this, lblCompanyNoBox.Text, txtCompanyNoBox.Text, false, Utility.DataType.HALF_KANA_ALPHA_NUMERIC, 10, 0)) { return; } if (!CheckUtility.SearchConditionCheck(this, lblCompanyName.Text, txtCompanyName.Text, false, Utility.DataType.FULL_WIDTH, 80, 0)) { return; } if (!CheckUtility.SearchConditionCheck(this, lblEmail.Text, txtEmail.Text, false, Utility.DataType.HALF_ALPHA_NUMERIC, 255, 0)) { return; } company_no_box = txtCompanyNoBox.Text.Trim(); company_name = txtCompanyName.Text.Trim(); email = txtEmail.Text.Trim(); frmCompanyCodeListController oController = new frmCompanyCodeListController(); DataTable dt = oController.GetCompanyCodeList(company_no_box, company_name, email, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); //check for disable flag uIUtility.CheckForDisableField(); uIUtility.FormatUpdatedat(); } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGrid() { try { string strYYYYMM1, strYYYYMM2; DateTime dtDate = Convert.ToDateTime(txtDate.Text.Trim()); string strDifference = ""; if (checkState == "Previous") { strYYYYMM1 = dtDate.ToString("yyMM"); strYYYYMM2 = dtDate.AddMonths(-1).ToString("yyMM"); strDifference = dtDate.AddMonths(-1).ToString("yyyy/MM"); } else { strYYYYMM1 = dtDate.AddMonths(1).ToString("yyMM"); strYYYYMM2 = dtDate.ToString("yyMM"); strDifference = dtDate.AddMonths(1).ToString("yyyy/MM"); } lbldifference.Text = "次月売上比較:" + strDifference + "分差異"; frmMonthlySaleComparisonListController oController = new frmMonthlySaleComparisonListController(); DataTable dt = oController.GetMonthlySaleComparisonList(strYYYYMM1, strYYYYMM2, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { if (dt.Rows.Count == 0) { MetroMessageBox.Show(this, "\n" + JimugoMessages.I000WE001, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGrid() { try { //assign search keywords string company_no_box = txtCompanyNoBox.Text; string company_name = txtCompanyName.Text; string company_name_reading = txtCompanyNameReading.Text; string edi_account = txtEDIAccount.Text; string mialAddress = txtMailAddress.Text; string contractor = ""; string invoice = ""; string serviceDesk = ""; string notificationDestination = ""; #region CheckBox if (chkContractor.Checked) { contractor = chkContractor.Text; } else { contractor = ""; } if (chkInvoice.Checked) { invoice = chkInvoice.Text; } else { invoice = ""; } if (chkServiceDesk.Checked) { serviceDesk = chkServiceDesk.Text; } else { serviceDesk = ""; } if (chkNotificationDestination.Checked) { notificationDestination = chkNotificationDestination.Text; } else { notificationDestination = ""; } #endregion //assign search keywords frmCustomerMasterMaintenanceController oController = new frmCustomerMasterMaintenanceController(); DataTable dt = oController.GetCustomerMasterMaintenanceList(company_no_box, company_name, company_name_reading, edi_account, mialAddress, contractor, invoice, serviceDesk, notificationDestination, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); //need to add more parameter if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); uIUtility.FormatUpdatedat(); //check for disable flag uIUtility.CheckForDisableField(); } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }