public static void LoadData(baseDS.investorStockDataTable tbl, string stockCode, string portfolio,DateTime buyDate)
{
investorStockTA.ClearBeforeFill = false;
investorStockTA.FillByPortfolioStockBuyDate(tbl, portfolio, stockCode,buyDate);
}
public static void UpdateData(baseDS.priceDataRow row)
{
priceDataTA.Update(row);
row.AcceptChanges();
}
public static void UpdateData(baseDS.stockExchangeRow data)
{
stockExchangeTA.Update(data);
data.AcceptChanges();
}
public static void LoadStockCode_ByStatus(baseDS.stockCodeDataTable tbl,AppTypes.CommonStatus status)
{
stockCodeTA.FillByStatusMask(tbl, ((byte)status).ToString());
}
public static void UpdateData(baseDS.priceDataSumDataTable tbl)
{
priceDataSumTA.Update(tbl);
tbl.AcceptChanges();
}
public static void LoadLastPrice(baseDS.priceDataSumDataTable tbl, string timeScale,string stockCode)
{
priceDataSumTA.ClearBeforeFill = false;
priceDataSumTA.FillLastPrice(tbl,stockCode, timeScale);
}
public static void LoadPortfolioByInvestor(baseDS.portfolioDataTable tbl, string investorCode,AppTypes.PortfolioTypes type)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByInvestorCodeAndTypeMask(tbl, investorCode,((byte)type).ToString());
}
//public static void LoadAbnormalData(baseDS.priceDataDataTable tbl, string code, DateTime frDate, DateTime toDate, string timeScale)
//{
// priceDataTA.ClearBeforeFill = false;
// if (timeScale == AppTypes.MainDataTimeScale.Code)
// {
// priceDataTA.FillAbnormal(tbl, code, frDate, toDate);
// }
// else
// {
// priceDataTA.FillAbnomalSumData(tbl, code, timeScale, frDate, toDate);
// }
//}
public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale,DateTime frDate,DateTime toDate,string stockCode)
{
try
{
common.SysLog.WriteLog("AAA0: ", Settings.sysFileUserLog);
//priceDataTA.Connection.ConnectionString = @"Data Source=HAIQUAN\MSSQLSERVER2008;Initial Catalog=stock;User ID=sa;Password=123";
common.SysLog.WriteLog("AAA: " + priceDataTA.Connection.ConnectionString, Settings.sysFileUserLog);
priceDataTA.ClearBeforeFill = false;
if (timeScale == AppTypes.MainDataTimeScale.Code)
{
if (frDate == DateTime.MinValue && toDate == DateTime.MaxValue)
priceDataTA.FillByCode(tbl, stockCode);
else priceDataTA.FillByDateCode(tbl, frDate, toDate, stockCode);
}
else
{
if (frDate == DateTime.MinValue && toDate == DateTime.MaxValue)
priceDataTA.FillByTypeCode(tbl, timeScale, stockCode);
else priceDataTA.FillByTypeDateCode(tbl, timeScale, frDate, toDate, stockCode);
}
}
catch (Exception er)
{
WriteLog(common.SysSeverityLevel.Alert, "ABC", er);
}
}
public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale, DateTime frDate,string stockCode)
{
WriteLog(common.SysSeverityLevel.Informational,"", timeScale + " " + frDate.ToString() + " " + stockCode);
string eCode = "DB000";
try
{
if (tbl.Count>0)
common.SysLog.WriteLog(DateTime.Now.ToString() + common.Consts.constTab + "test 00: LoadData ", Settings.sysFileUserLog);
priceDataTA.ClearBeforeFill = false;
if (timeScale == AppTypes.MainDataTimeScale.Code)
{
eCode = "DB001";
priceDataTA.FillByCodeFromDate(tbl, stockCode, frDate);
}
else
{
eCode = "DB002 " + priceDataTA.Connection.State.ToString();
priceDataTA.FillByTypeCodeFromDate(tbl, timeScale, stockCode, frDate);
}
}
catch (Exception er)
{
WriteLog(common.SysSeverityLevel.Error, eCode , er);
}
}
public static void LoadData(baseDS.portfolioDetailDataTable tbl, string portfolioCode)
{
portfolioDetailTA.ClearBeforeFill = false;
portfolioDetailTA.FillByPortfolio(tbl, portfolioCode);
}
public static void LoadData(baseDS.portfolioDetailDataTable tbl, byte typeMask)
{
portfolioDetailTA.ClearBeforeFill = false;
portfolioDetailTA.FillByTypeMask(tbl, ((byte)typeMask).ToString());
}
public static void LoadData(baseDS.portfolioDataTable tbl, string code)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByCode(tbl, code);
}
public static void LoadData(baseDS.portfolioDataTable tbl, AppTypes.PortfolioTypes type)
{
common.SysLog.WriteLog(DateTime.Now.ToString() + common.Consts.constTab +
"ABC "+portfolioDetailTA.Connection.ConnectionString, Settings.sysFileUserLog);
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByTypeMask(tbl, ((byte)type).ToString());
}
public static void LoadData(baseDS.transactionsDataTable tbl,string portfolio,string stockCode)
{
transactionsTA.ClearBeforeFill = false;
transactionsTA.FillByPortfolioStockCode(tbl, portfolio,stockCode);
}
public static void LoadInvestorByAccount(baseDS.investorDataTable tbl, string account)
{
investorTA.ClearBeforeFill = false;
investorTA.FillByAccount(tbl, account);
}
public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale,string stockCode,int maxCount)
{
string dataTbl = "";
string cond = "stockCode=N'" + stockCode.Trim() + "'";
if (timeScale == AppTypes.MainDataTimeScale.Code)
{
dataTbl = "priceData";
}
else
{
dataTbl = "priceDataSum";
cond += (cond==""?"" : " AND ")+ "type=N'" + timeScale + "'";
}
string sqlCmd =
"SELECT * FROM " +
"(SELECT TOP " + maxCount.ToString() + " onDate,stockCode,openPrice,closePrice,lowPrice,highPrice,volume FROM " + dataTbl + common.Consts.constCRLF +
"WHERE " + cond + " ORDER BY onDate DESC)a" + common.Consts.constCRLF +
"ORDER BY onDate";
LoadFromSQL(tbl, sqlCmd);
}
public static void LoadInvestorByEmail(baseDS.investorDataTable tbl, string email)
{
investorTA.ClearBeforeFill = false;
investorTA.FillByEmail(tbl, email);
}
public static void LoadData(baseDS.tradeAlertDataTable tbl, string portfolio, DateTime frDate, DateTime toDate,byte statusMask)
{
tradeAlertTA.ClearBeforeFill = false;
tradeAlertTA.Fill(tbl,portfolio,frDate,toDate,statusMask.ToString());
}
public static void LoadMessageBySQL(baseDS.messagesDataTable tbl, string sql)
{
LoadFromSQL(tbl, sql);
}
public static void LoadData(baseDS.messagesDataTable tbl, DateTime frDate,DateTime toDate)
{
messagesTA.FillByDate(tbl, frDate, toDate);
}
public static void LoadPortfolioByInvestor(baseDS.portfolioDataTable tbl, string investorCode)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByInvestorCode(tbl, investorCode);
}
public static void LoadDataByIndustryCode(baseDS.bizSubSectorDataTable tbl, string industryCode)
{
bizSubSectorTA.ClearBeforeFill = false;
bizSubSectorTA.FillByIndustryCode(tbl, industryCode);
}
public static void LoadStockOwnedByInvestor(baseDS.investorStockDataTable tbl, string investorCode)
{
investorStockTA.ClearBeforeFill = false;
investorStockTA.FillByInvestor(tbl, investorCode);
}
public static void LoadDataBySuperSectorCode(baseDS.bizSubSectorDataTable tbl, string superSectorCode)
{
bizSubSectorTA.ClearBeforeFill = false;
bizSubSectorTA.FillBySuperSector(tbl, superSectorCode);
}
public static void UpdateData(baseDS.priceDataDataTable tbl)
{
try
{
priceDataTA.Update(tbl);
tbl.AcceptChanges();
}
catch (Exception e)
{
foreach (baseDS.priceDataRow row in tbl.Rows)
{
if (row.HasErrors)
{
WriteSyslog(e, row.stockCode + " Date: " + row.onDate);
}
}
}
}
public static void LoadDataOneRow(baseDS.priceDataDataTable tbl,DateTime frDate, DateTime toDate, string stockCode)
{
priceDataTA.ClearBeforeFill = false;
priceDataTA.FillOneByDateStockCode(tbl, frDate, toDate, stockCode);
}
public static void UpdateData(baseDS.exchangeDetailDataTable tbl)
{
exchangeDetailTA.Update(tbl);
tbl.AcceptChanges();
}
public static void LoadInvestor(baseDS.investorDataTable tbl, string cond)
{
string sqlCmd = "SELECT * FROM investor WHERE " + cond;
LoadFromSQL(tbl, sqlCmd);
}
public static void UpdateData(baseDS.stockCodeDataTable tbl)
{
stockCodeTA.Update(tbl);
tbl.AcceptChanges();
}
/// <summary>
/// Load an portfolio by investor
/// </summary>
/// <param name="tbl"></param>
/// <param name="portfolioCode"></param>
public static void LoadData(baseDS.investorStockDataTable tbl, string portfolioCode)
{
investorStockTA.ClearBeforeFill = false;
investorStockTA.FillByPortfolio(tbl, portfolioCode);
}
