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