/// <summary>获取指定类型的板块
/// </summary>
/// <param name="lstStockBlockType"></param>
/// <returns></returns>
public DataTable GetStockBlock(List <StockBlockType> lstStockBlockType)
{
const string sqlMod = "SELECT * FROM StockBlock WHERE BKType IN ({0})";
List <string> lstName = BLL.ConvertBlockTypeList2Name(lstStockBlockType);
string sParm = SysFunction.SParm(lstName.ToArray(), true);
return(SQLHelper.ExecuteDataTable(string.Format(sqlMod, sParm), CommandType.Text, _cnn));
}
/// <summary> 清空指定的板块信息
/// </summary>
/// <param name="lstStockBlockType">为 Null 则清空所有</param>
public void ClearStockBlock(List <StockBlockType> lstStockBlockType = null)
{
if (lstStockBlockType == null)
{
base.TruncateTable("StockBlock");
}
else
{
if (lstStockBlockType.Count > 0)
{
const string modSql = "DELETE FROM StockBlock WHERE BKType IN ({0})";
List <string> lstName = BLL.ConvertBlockTypeList2Name(lstStockBlockType);
string sParm = SysFunction.SParm(lstName.ToArray(), true);
SQLHelper.ExecuteNonQuery(string.Format(modSql, sParm), CommandType.Text, _cnn);
}
}
}
