//加载查询条件
private void GetCondition()
{
var qc = new StockQueryCondition();
if (!string.IsNullOrEmpty(this.selUnit.SelectedValue))
{
qc.unit_id = this.selUnit.SelectedValue;
qc.unit_name = this.selUnit.SelectedText;
}
if (!string.IsNullOrEmpty(this.selWarehouse.SelectedValue))
{
qc.warehouse_id = this.selWarehouse.SelectedValue;
qc.warehouse_name = this.selWarehouse.Text;
}
if (!string.IsNullOrEmpty(this.tbItemCode.Value))
{
qc.item_code = this.tbItemCode.Value;
}
if (!string.IsNullOrEmpty(this.tbItemName.Value))
{
qc.item_name = this.tbItemName.Value;
}
qc.typeValue = this.selType.SelectedValue;
if (!string.IsNullOrEmpty(this.selDate.Value) && this.selType.SelectedIndex == 2)
{
qc.YearMonth = this.selDate.Value;
}
else
{
qc.YearMonth = null;
}
this.QueryCondition = qc;
}
/// <summary>
/// 买入股票历史数据
/// </summary>
/// <param name="data"></param>
/// <param name="qc"></param>
public void LoadBuyHistoryData(DataTable data, StockQueryCondition qc)
{
string stockCode = qc.StockCode;
string stockName = qc.StockName;
string type = qc.BuyPoint;
string dateFrom = DateTimeFunction.ConvertDate(qc.DatePickerFrom);
string dateTo = DateTimeFunction.ConvertDate(qc.DatePickerTo);
string dateSearch = DateTimeFunction.ConvertDate(qc.DatePickerSearch);
string sql = "select ta.stock_code,ta.stock_name,ta.stock_type,ta.stock_day as search_day,tb.stock_day,"
+ " tb.today_begin,tb.today_end,tb.max_price,tb.min_price,tb.increase_percent from"
+ " (select * from aistock_stock_buy_stats b"
+ " where b.stock_day = '" + dateSearch + "'";
if (!string.IsNullOrEmpty(type))
{
sql += " and b.stock_type = '" + type + "'";
}
sql += " ) ta,"
+ " (select * from aistock_stock_information a"
+ " where a.stock_day >= '" + dateFrom + "' and a.stock_day <= '" + dateTo + "') tb"
+ " where ta.stock_code = tb.stock_code";
if (!string.IsNullOrEmpty(stockCode))
{
sql += " and ta.stock_code = '" + stockCode + "'";
}
if (!string.IsNullOrEmpty(stockName))
{
sql += " and ta.stock_name = '" + stockName + "'";
}
sql += " order by ta.stock_code, ta.stock_type, tb.stock_day desc";
this.AutoFill(data, sql);
}
private void RestoreQueryCondition()
{
if (this.ViewState["_StockQueryCondition"].ToString() != string.Empty)
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
this.txtStockCode.Text = qc.StockCode;
this.txtStockName.Text = qc.StockName;
this.DatePickerFrom.DateTime = qc.DatePickerFrom;
this.DatePickerTo.DateTime = qc.DatePickerTo;
this.DatePickerSearch.DateTime = qc.DatePickerSearch;
for (int i = 0; i < this.DropDownListType.Items.Count; i++)
{
if (this.DropDownListType.Items[i].Value == qc.BuyPoint)
{
this.DropDownListType.SelectedIndex = i;
break;
}
}
qc.Dispose();
}
}
public IHttpActionResult GetRecoTotalCount(StockQueryCondition condition)
{
//string[] codeList = id.Split('$');
//string[] cateList = codeList[0].Split(',');
//string[] indexList = codeList[1].Split(',');
//using (StockManDBEntities db = new StockManDBEntities())
//{
// //var sql = @"select cate_code, count(cate_code) as count from reco_category_count where cate_code in ('013500','013200','','012400') and index_code in ('T0001','T0003','T0002') group by cate_code";
// var total = db.reco_category_count.Where(p => cateList.Contains(p.cate_code)).Sum(p=>p.count);
// return Ok(total);
//}
var query = service.FindStockCountFromRankPoolBy(new dm.dto.StockQueryCondition
{
user_id = condition.user_id,
price = condition.price,
pe = condition.pe,
pb = condition.pb,
mv = condition.mv,
fv = condition.fv,
cate = condition.cate
});
return(Ok(query.Sum(p => p.count)));
}
public void LoadStockBaseInfo(DataTable data, StockQueryCondition qc)
{
string stockCode = qc.StockCode;
string market = qc.Market;
string field = qc.Field;
string province = qc.Province;
string sql = "SELECT * FROM AISTOCK_STOCK_BASEINFO WHERE IS_VALID = 1";
if (!string.IsNullOrEmpty(stockCode))
{
sql += " AND STOCK_CODE = '" + stockCode + "'";
}
if (!string.IsNullOrEmpty(market))
{
sql += " AND STOCK_ADDR = '" + market + "'";
}
if (!string.IsNullOrEmpty(field))
{
sql += " AND FIELD = '" + field + "'";
}
if (!string.IsNullOrEmpty(province))
{
sql += " AND PROVINCE = '" + province + "'";
}
sql += " ORDER BY PROFIT_PERCENT DESC, STOCK_CODE";
this.AutoFill(data, sql);
}
/// <summary>
/// 记录查询条件
/// </summary>
private void RecordQueryCondition()
{
string datepickerfrom = this.DatePickerFrom.DateTime;
StockQueryCondition qc = new StockQueryCondition();
qc.DatePickerFrom = datepickerfrom;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
}
private bool IsValidDate()
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
string dateTo = DateTimeFunction.ConvertDate1(qc.DatePickerFrom);
return(new StockSystem().IsValidDate(dateTo));
}
private void DrawBlafTableHeader()
{
//第一行
TableRow headerRow = this.BmBlafTableHistory.AddHeadRow();
headerRow.BorderColor = Color.Black;
headerRow.BorderWidth = Unit.Point(1);
headerRow.Height = 25;
this.BmBlafTableHistory.AddHeadCell(headerRow, " ", 70).HorizontalAlign = HorizontalAlign.Center; //股票代码
this.BmBlafTableHistory.AddHeadCell(headerRow, " ", 70).HorizontalAlign = HorizontalAlign.Center; //股票名称
this.BmBlafTableHistory.AddHeadCell(headerRow, " ", 100).HorizontalAlign = HorizontalAlign.Center; //买入类型
this.BmBlafTableHistory.AddHeadCell(headerRow, " ", 70).HorizontalAlign = HorizontalAlign.Center; //查询日期
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
_dateList = this.SplitDate(qc.DatePickerFrom, qc.DatePickerTo);
for (int i = _dateList.Count - 1; i >= 0; i--)
{
TableCell cell = this.BmBlafTableHistory.AddHeadCell(headerRow, _dateList[i].ToString(), 70 * 5);
cell.ColumnSpan = 5;
cell.HorizontalAlign = HorizontalAlign.Center;
}
//第二行
TableRow secondRow = this.BmBlafTableHistory.AddHeadRow();
secondRow.BorderColor = Color.Black;
secondRow.BorderWidth = Unit.Point(1);
this.BmBlafTableHistory.AddHeadCell(secondRow, "股票代码", 70).HorizontalAlign = HorizontalAlign.Center; //股票代码
this.BmBlafTableHistory.AddHeadCell(secondRow, "股票名称", 70).HorizontalAlign = HorizontalAlign.Center; //股票名称
this.BmBlafTableHistory.AddHeadCell(secondRow, "买入类型", 100).HorizontalAlign = HorizontalAlign.Center; //买入类型
this.BmBlafTableHistory.AddHeadCell(secondRow, "查询日期", 70).HorizontalAlign = HorizontalAlign.Center; //查询日期
for (int i = _dateList.Count - 1; i >= 0; i--)
{
this.BmBlafTableHistory.AddHeadCell(secondRow, "开盘价", 70).HorizontalAlign = HorizontalAlign.Center;
this.BmBlafTableHistory.AddHeadCell(secondRow, "收盘价", 70).HorizontalAlign = HorizontalAlign.Center;
this.BmBlafTableHistory.AddHeadCell(secondRow, "最高价", 70).HorizontalAlign = HorizontalAlign.Center;
this.BmBlafTableHistory.AddHeadCell(secondRow, "最低价", 70).HorizontalAlign = HorizontalAlign.Center;
this.BmBlafTableHistory.AddHeadCell(secondRow, "增长率", 70).HorizontalAlign = HorizontalAlign.Center;
}
this.BmBlafTableHistory.Width = "100%";
this.BmBlafTableHistory.Height = "400";
}
/// <summary>
/// 记录查询条件
/// </summary>
private void RecordQueryCondition()
{
string code = this.txtStockCode.Text.Trim();
string datepickerfrom = this.DatePickerFrom.DateTime;
StockQueryCondition qc = new StockQueryCondition();
qc.StockCode = code;
qc.DatePickerFrom = datepickerfrom;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
}
/// <summary>
/// 记录查询条件
/// </summary>
private void RecordQueryCondition()
{
string datepickerfrom = this.DatePickerFrom.DateTime;
string type = this.DropDownListType.SelectedValue;
StockQueryCondition qc = new StockQueryCondition();
qc.DatePickerFrom = datepickerfrom;
qc.BuyPoint = type;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
}
public AISTOCK_STOCK_AVG_PRICE_DATA GetStockAvgHistory(StockQueryCondition qc)
{
AISTOCK_STOCK_AVG_PRICE_DATA data = new AISTOCK_STOCK_AVG_PRICE_DATA();
using (DaStock da = new DaStock())
{
da.LoadStockAvgHistory(data.AISTOCK_STOCK_AVG_PRICE, qc);
}
return(data);
}
/// <summary>
/// 查询买入股历史数据
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public AISTOCK_STOCK_BUY_HISTORY_DATA GetBuyHistoryData(StockQueryCondition qc)
{
AISTOCK_STOCK_BUY_HISTORY_DATA data = new AISTOCK_STOCK_BUY_HISTORY_DATA();
using (DaStock da = new DaStock())
{
da.LoadBuyHistoryData(data.AISTOCK_STOCK_BUY_HISTORY, qc);
}
return(data);
}
public AISTOCK_STOCK_DAILY_DATA_V_DATA GetStockHistory(StockQueryCondition qc)
{
AISTOCK_STOCK_DAILY_DATA_V_DATA data = new AISTOCK_STOCK_DAILY_DATA_V_DATA();
using (DaStock da = new DaStock())
{
da.LoadStockHistory(data.AISTOCK_STOCK_DAILY_DATA_V, qc);
}
return(data);
}
public AISTOCK_STOCK_BASEINFO_DATA GetStockBaseInfo(StockQueryCondition qc)
{
AISTOCK_STOCK_BASEINFO_DATA data = new AISTOCK_STOCK_BASEINFO_DATA();
using (DaStock da = new DaStock())
{
da.LoadStockBaseInfo(data.AISTOCK_STOCK_BASEINFO, qc);
}
return(data);
}
/// <summary>
/// 还原界面查询条件
/// </summary>
private void RestoreQueryCondition()
{
if (this.ViewState["_StockQueryCondition"].ToString() != string.Empty)
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
this.txtStockCode.Text = qc.StockCode;
this.txtStockName.Text = qc.StockName;
this.DatePickerFrom.DateTime = qc.DatePickerFrom;
this.DatePickerTo.DateTime = qc.DatePickerTo;
for (int i = 0; i < this.DropDownListCategory.Items.Count; i++)
{
if (this.DropDownListCategory.Items[i].Value == qc.Market)
{
this.DropDownListCategory.SelectedIndex = i;
break;
}
}
for (int i = 0; i < this.DropDownListField.Items.Count; i++)
{
if (this.DropDownListField.Items[i].Value == qc.Field)
{
this.DropDownListField.SelectedIndex = i;
break;
}
}
for (int i = 0; i < this.DropDownListProvince.Items.Count; i++)
{
if (this.DropDownListProvince.Items[i].Value == qc.Province)
{
this.DropDownListProvince.SelectedIndex = i;
break;
}
}
for (int i = 0; i < this.DropDownListChart.Items.Count; i++)
{
if (this.DropDownListChart.Items[i].Value == qc.Chart)
{
this.DropDownListChart.SelectedIndex = i;
break;
}
}
qc.Dispose();
}
}
/// <summary>
/// 还原界面查询条件
/// </summary>
private void RestoreQueryCondition()
{
if (this.ViewState["_StockQueryCondition"].ToString() != string.Empty)
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
this.txtStockCode.Text = qc.StockCode;
this.DatePickerFrom.DateTime = qc.DatePickerFrom;
qc.Dispose();
}
}
private void Refresh()
{
string dateFrom = Request.QueryString["datefrom"] == null ? string.Empty : Request.QueryString["datefrom"];
string dateTo = Request.QueryString["dateto"] == null ? string.Empty : Request.QueryString["dateto"];
string market = Request.QueryString["market"] == null ? string.Empty : Request.QueryString["market"];
string field = Request.QueryString["field"] == null ? string.Empty : Request.QueryString["field"];
string chart = Request.QueryString["chart"] == null ? string.Empty : Request.QueryString["chart"];
string province = Request.QueryString["province"] == null ? string.Empty : Request.QueryString["province"];
string stockName = Request.QueryString["stockName"] == null ? string.Empty : Request.QueryString["stockName"].ToString().Trim();
string stockcode = Request.QueryString["stockcode"] == null ? string.Empty : Request.QueryString["stockcode"];
string MarketName = Request.QueryString["MarketName"] == "--请选择--" ? string.Empty : Request.QueryString["MarketName"];
string FieldName = Request.QueryString["FieldName"] == "--请选择--" ? string.Empty : Request.QueryString["FieldName"].Trim();
string ChartName = Request.QueryString["ChartName"] == "--请选择--" ? string.Empty : Request.QueryString["ChartName"];
string ProvinceName = Request.QueryString["ProvinceName"] == "--请选择--" ? string.Empty : Request.QueryString["ProvinceName"].Trim();
StockQueryCondition qc = new StockQueryCondition();
qc.DatePickerFrom = dateFrom;
qc.DatePickerTo = dateTo;
qc.StockCode = stockcode;
qc.StockName = stockName;
qc.Market = MarketName;
qc.Field = FieldName;
qc.Chart = ChartName;
qc.Province = ProvinceName;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
AISTOCK_STOCK_DAILY_DATA_V_DATA data = new AISTOCK_STOCK_DAILY_DATA_V_DATA();
data = new StockSystem().GetStockHistory(qc);
AISTOCK_STOCK_AVG_PRICE_DATA avgData = new AISTOCK_STOCK_AVG_PRICE_DATA();
avgData = new StockSystem().GetStockAvgHistory(qc);
this.BmBlafTableHistory.Clear();
this.BmBlafTableHistory.BorderColor = Color.Black;
this.BmBlafTableHistory.BorderWidth = Unit.Point(1);
this.DrawBlafTableHeader();
this.DrawBlafTableBody(data, avgData);
this.LabelTitle.Text = "名称：查询股票历史记录<br>" +
"创建时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "<br>" +
"时间：" + qc.DatePickerFrom + "至" + qc.DatePickerTo + "<br>" +
"所属证券市场：" + (qc.Market == string.Empty ? "ALL" : qc.Market) + "<br>" +
"所属证监会行业：" + (qc.Field == string.Empty ? "ALL" : qc.Field) + "<br>" +
"所属省份：" + (qc.Province == string.Empty ? "ALL" : qc.Province) + "<br>" +
"K线图：" + (qc.Chart == string.Empty ? "ALL" : qc.Chart) + "<br>" +
"股票代码：" + (qc.StockCode == string.Empty ? "ALL" : qc.StockCode) + "<br>" +
"股票名称：" + (qc.StockName == string.Empty ? "ALL" : qc.StockName);
}
/// <summary>
/// 记录查询条件
/// </summary>
private void RecordQueryCondition()
{
string code = this.txtStockCode.Text.Trim();
string market = this.DropDownListCategory.SelectedValue;
string field = this.DropDownListField.SelectedValue;
string province = this.DropDownListProvince.SelectedValue;
StockQueryCondition qc = new StockQueryCondition();
qc.StockCode = code;
qc.Market = market;
qc.Field = field;
qc.Province = province;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
}
private void Refresh()
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
this.labPrompt.Text = "";
//查询日前两天
string dateTo2 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 2);
dateTo2 = DateTimeFunction.ConvertDate(DateTime.Parse(dateTo2).ToShortDateString());
string date2RSI6 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 8);
date2RSI6 = DateTimeFunction.ConvertDate(DateTime.Parse(date2RSI6).ToShortDateString());
string date2RSI12 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 14);
date2RSI12 = DateTimeFunction.ConvertDate(DateTime.Parse(date2RSI12).ToShortDateString());
//string date2RSI24 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 26);
//date2RSI24 = DateTimeFunction.ConvertDate(DateTime.Parse(date2RSI24).ToShortDateString());
//查询日
string dateTo = DateTimeFunction.ConvertDate(qc.DatePickerFrom);
string dateRSI6 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 6);
dateRSI6 = DateTimeFunction.ConvertDate(DateTime.Parse(dateRSI6).ToShortDateString());
string dateRSI12 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 12);
dateRSI12 = DateTimeFunction.ConvertDate(DateTime.Parse(dateRSI12).ToShortDateString());
//string dateRSI24 = new StockSystem().GetIndexDay(qc.DatePickerFrom, 24);
//dateRSI24 = DateTimeFunction.ConvertDate(DateTime.Parse(dateRSI24).ToShortDateString());
AISTOCK_STOCK_STATS_DATA stockData = new StockSystem().GetStockData(dateTo2, txtStockCode.Text.Trim());
string today = DateTimeFunction.ConvertDate(DateTime.Now.ToShortDateString());
today = new StockSystem().GetToday(today);
bool flag = false;
if (int.Parse(dateTo) < int.Parse(today))
{
flag = true;
}
AISTOCK_STOCK_INDEX_V_DATA data2RSI6 = new AISTOCK_STOCK_INDEX_V_DATA();
data2RSI6 = new StockSystem().GetStockDataIndex(date2RSI6, dateTo2, txtStockCode.Text.Trim());
this.BmBlafTable.Clear();
DrawRsiTableHeader();
DrawRsiTableBody(data2RSI6, stockData, txtStockCode.Text.Trim(), flag, today, dateTo2, date2RSI12, dateTo, dateRSI6, dateRSI12);
}
public IHttpActionResult GetRecoCateCount(StockQueryCondition condition)
{
var query = service.FindStockCountFromRankPoolBy(new dm.dto.StockQueryCondition
{
user_id = condition.user_id,
price = condition.price,
pe = condition.pe,
pb = condition.pb,
mv = condition.mv,
fv = condition.fv,
cate = condition.cate
});
return(Ok(query));
}
private void Refresh()
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
string date = DateTimeFunction.ConvertDate(qc.DatePickerFrom);
AISTOCK_STATS_PERCENT_V_DATA data = new StockSystem().GetStockStatsVData(date);
DataTable leader = new StockSystem().GetLeaderStock(date);
this.BmBlafTable.Clear();
DrawTableHeader();
DrawTableBody(data, leader);
this.RestoreQueryCondition();
}
private void Refresh()
{
if (this.ViewState["_StockQueryCondition"] == null)
{
this.RecordQueryCondition();
}
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
AISTOCK_STOCK_BASEINFO_DATA data = new StockSystem().GetStockBaseInfo(qc);
this.BmBlafTableStock.Clear();
this.DrawBmTableHeader();
this.DrawBmTableBody(data);
}
public IHttpActionResult GetStateStockCount(StockQueryCondition condition)
{
var query = service.FindStateStockCountBy(new dm.dto.StockQueryCondition
{
user_id = condition.user_id,
price = condition.price,
pe = condition.pe,
pb = condition.pb,
mv = condition.mv,
fv = condition.fv,
cate = condition.cate,
tech = condition.tech
});
return(Ok(query.Sum(p => p.count)));
}
/// <summary>
/// 记录查询条件
/// </summary>
private void RecordQueryCondition()
{
string code = this.txtStockCode.Text.Trim();
string name = this.txtStockName.Text.Trim();
string datepickerfrom = this.DatePickerFrom.DateTime;
string datepickerto = this.DatePickerTo.DateTime;
string datepickersearch = this.DatePickerSearch.DateTime;
string type = this.DropDownListType.SelectedValue;
StockQueryCondition qc = new StockQueryCondition();
qc.DatePickerFrom = datepickerfrom;
qc.DatePickerTo = datepickerto;
qc.DatePickerSearch = datepickersearch;
qc.StockCode = code;
qc.StockName = name;
qc.BuyPoint = type;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
}
public void LoadStockAvgHistory(DataTable data, StockQueryCondition qc)
{
string stockCode = qc.StockCode;
string stockName = qc.StockName;
string dateFrom = DateTimeFunction.ConvertDate(qc.DatePickerFrom);
string dateTo = DateTimeFunction.ConvertDate(qc.DatePickerTo);
string sql = "SELECT * FROM AISTOCK_STOCK_AVG_PRICE WHERE STOCK_DAY <= '" + dateTo + "' AND STOCK_DAY >= '" + dateFrom + "'";
if (!string.IsNullOrEmpty(stockCode))
{
sql += " AND STOCK_CODE LIKE '%" + stockCode + "%'";
}
if (!string.IsNullOrEmpty(stockName))
{
sql += " AND STOCK_NAME LIKE '%" + stockName + "%'";
}
sql += " ORDER BY STOCK_CODE";
this.AutoFill(data, sql);
}
private void Refresh()
{
StockQueryCondition qc = new StockQueryCondition();
qc.DeserializeFromString(this.ViewState["_StockQueryCondition"].ToString());
DateTime dateFrom = DateTime.Parse(this.DatePickerFrom.DateTime.ToString());
DateTime dateTo = DateTime.Parse(this.DatePickerTo.DateTime.ToString());
if (dateFrom > dateTo)
{
this.RestoreQueryCondition();
this.labScript.Text = JavaScriptFunction.Alert("选择的查询时间段不对，请重新选择。");
return;
}
AISTOCK_STOCK_DAILY_DATA_V_DATA data = new AISTOCK_STOCK_DAILY_DATA_V_DATA();
data = new StockSystem().GetStockHistory(qc);
AISTOCK_STOCK_AVG_PRICE_DATA avgData = new AISTOCK_STOCK_AVG_PRICE_DATA();
avgData = new StockSystem().GetStockAvgHistory(qc);
this.BmBlafTableHistory.Clear();
this.BmBlafTableHistory.IsEnableScroll = true;
this.BmBlafTableHistory.FreezeColumnCount = 6;
if (data == null || data.AISTOCK_STOCK_DAILY_DATA_V.Count <= 0)
{
//this.BmBlafTableHistory.TitleRowCount = 1;
this.DrawBlafTableHeader();
}
else
{
//this.BmBlafTableHistory.TitleRowCount = 2;
this.DrawBlafTableHeader();
this.DrawBlafTableBody(data, avgData);
}
//恢复记录
this.RestoreQueryCondition();
}
/// <summary>
/// 记录查询条件
/// </summary>
private void RecordQueryCondition()
{
string code = this.txtStockCode.Text.Trim();
string name = this.txtStockName.Text.Trim();
string market = this.DropDownListCategory.SelectedValue;
string field = this.DropDownListField.SelectedValue;
string province = this.DropDownListProvince.SelectedValue;
string index = this.DropDownListIndex.SelectedValue;
string datepickerfrom = this.DatePickerFrom.DateTime;
StockQueryCondition qc = new StockQueryCondition();
qc.StockCode = code;
qc.Index = index;
qc.StockName = name;
qc.Market = market;
qc.Field = field;
qc.Province = province;
qc.DatePickerFrom = datepickerfrom;
this.ViewState["_StockQueryCondition"] = qc.SerializeToString();
}
public IHttpActionResult FindStockRankBy(StockQueryCondition condition)
{
//需要和用户关注行业和技术关联
var query = service.FindStockFromRankPoolBy(new dm.dto.StockQueryCondition
{
user_id = condition.user_id,
price = condition.price,
pe = condition.pe,
pb = condition.pb,
mv = condition.mv,
fv = condition.fv,
cate = condition.cate
});
if (condition.user_id == "guest")
{
return(Ok(query.Take(5).ToList()));
}
return(Ok(query));
}
public void LoadStockHistory(DataTable data, StockQueryCondition qc)
{
string stockCode = qc.StockCode;
string stockName = qc.StockName;
string market = qc.Market;
string field = qc.Field;
string chart = qc.Chart;
string province = qc.Province;
string dateFrom = DateTimeFunction.ConvertDate(qc.DatePickerFrom);
string dateTo = DateTimeFunction.ConvertDate(qc.DatePickerTo);
string sql = "SELECT * FROM AISTOCK_STOCK_DAILY_DATA_V WHERE STOCK_DAY >= '" + dateFrom + "' AND STOCK_DAY <= '" + dateTo + "'";
if (!string.IsNullOrEmpty(stockCode))
{
sql += " AND STOCK_CODE LIKE '%" + stockCode + "%'";
}
if (!string.IsNullOrEmpty(stockName))
{
sql += " AND STOCK_NAME LIKE '%" + stockName + "%'";
}
if (!string.IsNullOrEmpty(market))
{
sql += " AND STOCK_ADDR = '" + market + "'";
}
if (!string.IsNullOrEmpty(field))
{
sql += " AND FIELD = '" + field + "'";
}
if (!string.IsNullOrEmpty(province))
{
sql += " AND PROVINCE = '" + province + "'";
}
if (!string.IsNullOrEmpty(chart))
{
sql += " AND CHART = '" + chart + "'";
}
sql += " ORDER BY STOCK_CODE";
this.AutoFill(data, sql);
}
public IHttpActionResult FindStateStock(StockQueryCondition condition)
{
//需要和用户关注行业和技术关联
var query = service.FindStateStockBy(new dm.dto.StockQueryCondition
{
user_id = condition.user_id,
price = condition.price,
pe = condition.pe,
pb = condition.pb,
mv = condition.mv,
fv = condition.fv,
cate = condition.cate,
tech = condition.tech,
cycle = condition.cycle
});
//if (condition.user_id == "guest")
//{
// return Ok(query.Take(5).ToList());
//}
return(Ok(query));
}
