public static string CreateQueryDepositCodeSql(QueryDepositCodeParameter parameter)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("dbo.Flex_GetDepositCode");
AppentSqlParameter(sb, parameter.FromTradeDay.ToStandardDatetimeString());
AppentSqlParameter(sb, parameter.ToTradeDay.ToStandardDatetimeString());
AppentSqlParameter(sb, parameter.AccountCodeStr);
AppentSqlParameter(sb, ((int)parameter.PaymentType).ToString());
return sb.ToString(0, sb.Length - 1);
}
public static string[] GetAllFundNo(QueryObject queryObj)
{
QueryDepositCodeParameter parameter = new QueryDepositCodeParameter
{
FromTradeDay=queryObj.BeginDatetime,
ToTradeDay=queryObj.EndDatetime,
AccountCodeStr= queryObj.AccountStr,
PaymentType= queryObj.Type
};
string sql = ProcedureStrFactory.CreateQueryDepositCodeSql(parameter);
_Log.InfoFormat("GetAllFundNo sql:{0}", sql);
DataSet ds = DataAccess.GetData(sql, ConfigHelper.ConnectionString);
_Log.InfoFormat("GetAllFundNo count:{0}", ds.Tables[0].Rows.Count);
List<string> list = new List<string>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add((string)dr["Code"]);
}
return list.ToArray();
}