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);
}
}
