private void DoLoadData() { DataAccess.AppLibs.LoadInvestor(DataAccess.AppLibs.myCacheBaseDS.investor, false); investorSource.DataSource = DataAccess.AppLibs.myCacheBaseDS.investor; string filter = myDataSet.messages.OnDateColumn.ColumnName + " BETWEEN '" + common.system.ConvertToSQLDateString(dateRange.frDate) + "' AND '" + common.system.ConvertToSQLDateString(dateRange.toDate) + "'"; if (feedbackTypeChk2.Checked) { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myDataSet.messages.CategoryColumn.ColumnName, feedbackTypeCb2.myValue, system.searchOptions.Exact, true); } if (accountChk.Checked && accountEd.Text.Trim() != "") { databases.tmpDS.investorRow row = DataAccess.AppLibs.GetInvestorByAccount(accountEd.Text.Trim()); if (row != null) { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myDataSet.messages.SenderIdColumn.ColumnName, row.code, system.searchOptions.Exact, true); } } if (contentChk2.Checked && contentEd2.Text.Trim() != "") { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myDataSet.messages.MsgBodyColumn.ColumnName, contentEd2.Text.Trim(), system.searchOptions.Contain, true); } string sqlCmd = "SELECT * FROM " + myDataSet.messages.TableName + (filter == "" ? "" : " WHERE " + filter); messagesSource.DataSource = DataAccess.Libs.GetMesssage_BySql(sqlCmd); }
public void ShowForm() { databases.tmpDS.investorRow investorRow = DataAccess.AppLibs.FindAndCache_Investor(commonClass.SysLibs.sysLoginCode); if (investorRow != null) { senderEd.Text = investorRow.displayName; } AddNew(""); LockEditData(false); this.Show(); }
private void LoadData() { DataAccess.AppLibs.LoadInvestor(DataAccess.AppLibs.myCacheBaseDS.investor, false); investorSource.DataSource = DataAccess.AppLibs.myCacheBaseDS.investor; string filter = myBaseDS.sysLog.onDateColumn.ColumnName + " BETWEEN '" + common.system.ConvertToSQLDateString(dateRange.frDate) + "' AND '" + common.system.ConvertToSQLDateString(dateRange.toDate) + "'"; if (accountChk.Checked && accountEd.Text.Trim() != "") { databases.tmpDS.investorRow row = DataAccess.AppLibs.GetInvestorByAccount(accountEd.Text.Trim()); if (row != null) { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myBaseDS.sysLog.investorCodeColumn.ColumnName, row.code, system.searchOptions.Exact, true); } } if (sourceChk.Checked && sourceEd.Text.Trim() != "") { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myBaseDS.sysLog.sourceColumn.ColumnName, sourceEd.Text.Trim(), system.searchOptions.Contain, true); } if (descChk.Checked && descEd.Text.Trim() != "") { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myBaseDS.sysLog.descriptionColumn.ColumnName, descEd.Text.Trim(), system.searchOptions.Contain, true); } if (messageChk.Checked && messageEd.Text.Trim() != "") { filter += (filter == "" ? "" : " AND ") + common.system.MakeSearchExpression(myBaseDS.sysLog.messageColumn.ColumnName, messageEd.Text.Trim(), system.searchOptions.Contain, true); } if (logTypeChk.Checked) { filter += (filter == "" ? "" : " AND ") + myBaseDS.sysLog.typeColumn.ColumnName + " = " + ((byte)logTypeCb.myValue).ToString(); } string sqlCmd = "SELECT * FROM " + myBaseDS.sysLog.TableName + (filter == "" ? "" : " WHERE " + filter); syslogSource.DataSource = DataAccess.Libs.GetSyslog_BySQL(sqlCmd); this.ShowReccount(syslogSource.Count); }
public static databases.tmpDS.investorRow FindAndCache(databases.tmpDS.investorDataTable tbl, string code) { databases.tmpDS.investorRow row = tbl.FindBycode(code); if (row != null) { return(row); } if (tbl.Count == 0) { LoadInvestor(tbl, false); row = tbl.FindBycode(code); if (row != null) { return(row); } } return(null); }
private void messagesSource_CurrentChanged(object sender, EventArgs e) { try { if (fProcessing || messagesSource.Current == null) { return; } databases.baseDS.messagesRow row = (databases.baseDS.messagesRow)((DataRowView)messagesSource.Current).Row; senderEd.Text = ""; databases.tmpDS.investorRow investorRow = DataAccess.AppLibs.FindAndCache_Investor(row.SenderId); if (row != null) { senderEd.Text = investorRow.displayName; } } catch (Exception er) { this.ShowMessage(er.Message); } }
private void syslogSource_CurrentChanged(object sender, EventArgs e) { try { if (fProcessing || syslogSource.Current == null) { return; } databases.baseDS.sysLogRow logRow = (databases.baseDS.sysLogRow)((DataRowView)syslogSource.Current).Row; investorEd.Text = ""; if (!logRow.IsinvestorCodeNull()) { databases.tmpDS.investorRow row = DataAccess.AppLibs.FindAndCache_Investor(logRow.investorCode); if (row != null) { investorEd.Text = row.displayName; } } } catch (Exception er) { this.ShowMessage(er.Message); } }