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