/// <summary>
/// 将列表数据转换为字符串参数
/// </summary>
/// <typeparam name="T">参数类型</typeparam>
/// <param name="lstParms">任意数据类型的参数集</param>
/// <param name="needSParm">是否需要两边加单引号</param>
/// <returns></returns>
public static string CastToSQLParmString <T>(List <T> lstParms, bool needSParm)
{
StringBuilder sb = new StringBuilder();
string retVal = "";
if (lstParms.Count > 0)
{
foreach (T parm in lstParms)
{
if (needSParm)
{
sb.Append(SysFunction.SParm(parm.ToString()) + ",");
}
else
{
sb.Append(parm.ToString() + ",");
}
}
retVal = sb.ToString();
retVal = retVal.Substring(0, retVal.Length - 1);
}
return(retVal);
}
/// <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);
}
}
}
