private static ArrayList GetIncomeAndPayout(string sql) { ArrayList list = new ArrayList(); using (NullableDataReader reader = DBHelper.ExecuteReaderSql(sql)) { if (reader.Read()) { list.Add(reader[0]); } if (reader.NextResult() && reader.Read()) { list.Add(reader[0]); } } return(list); }
public IList <StockItemInfo> GetListByStockId(int stockId) { IList <StockItemInfo> list = new List <StockItemInfo>(); string strSql = "SELECT P.ProductNum, P.ProductName, P.Unit, S.* FROM PE_StockItem s INNER JOIN PE_CommonProduct p ON s.productId = p.productId AND s.TableName = P.TableName WHERE StockId = @StockId ; SELECT P.PresentNum AS ProductNum, P.PresentName AS ProductName, P.Unit, S.* FROM PE_StockItem s INNER JOIN PE_Present P ON s.productId = P.PresentID AND ISNULL(s.TableName,'')= '' WHERE s.StockId = @StockId"; using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, new Parameters("@StockId", DbType.Int32, stockId))) { while (reader.Read()) { list.Add(StockItemFromrdr(reader)); } if (!reader.NextResult()) { return(list); } while (reader.Read()) { list.Add(StockItemFromrdr(reader)); } } return(list); }
public IList <ComplainItemInfo> GetList(int startRowIndexId, int maxNumberRows, int searchType, int field, string keyword) { IList <ComplainItemInfo> list = new List <ComplainItemInfo>(); Database database = DatabaseFactory.CreateDatabase(); DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList"); database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId); database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows); database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "S.ItemID"); database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "S.*, C.ClientName AS ShortedForm"); database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC"); database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_ComplainItem S INNER JOIN PE_Client C ON S.ClientID = C.ClientID"); database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, 10); StringBuilder builder = new StringBuilder(0x100); builder.Append("1 = 1"); if (string.IsNullOrEmpty(keyword)) { switch (searchType) { case 0: goto Label_01D7; case 1: builder.Append(" AND DATEDIFF(d, S.DateAndTime, GETDATE()) < 10"); goto Label_01D7; case 2: builder.Append(" AND DATEDIFF(d, S.DateAndTime, GETDATE()) < 30"); goto Label_01D7; case 3: builder.Append(" AND FirstReceiver LIKE '%" + DBHelper.FilterBadChar(PEContext.Current.Admin.AdminName) + "%'"); goto Label_01D7; } } else { switch (field) { case 0: builder.Append(" AND S.ClientID = " + DBHelper.ToNumber(keyword)); goto Label_01D7; case 1: builder.Append(" AND C.ClientName LIKE '%" + DBHelper.FilterBadChar(keyword) + "%'"); goto Label_01D7; case 2: builder.Append(" AND DATEDIFF(d, S.DateAndTime, '" + DBHelper.FilterBadChar(keyword) + "') = 0"); goto Label_01D7; case 3: builder.Append(" AND S.Defendant = '" + DBHelper.FilterBadChar(keyword) + "'"); goto Label_01D7; case 0x63: builder.Append(ComplexSearch(keyword)); goto Label_01D7; } } Label_01D7: database.AddInParameter(storedProcCommand, "@Filter", DbType.String, builder.ToString()); using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand))) { while (reader.Read()) { list.Add(ComplainFromDataReader(reader)); } reader.NextResult(); } this.m_Total = (int)database.GetParameterValue(storedProcCommand, "@Total"); return(list); }