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