bankrollitem.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

                }
            }
            return list;
        }

        public IList<BankrollItemInfo> GetList(int startRowIndexId, int maxNumberRows, int searchType, int field, string keyword)
        {
            Database db = DatabaseFactory.CreateDatabase();
            IList<BankrollItemInfo> list = new List<BankrollItemInfo>();
            DbCommand storedProcCommand = db.GetStoredProcCommand("PR_Common_GetList");
            db.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            db.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            db.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "B.ItemID");
            db.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "B.*,C.ShortedForm as ClientName");
            db.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            db.AddInParameter(storedProcCommand, "@Filter", DbType.String, "");
            db.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_BankrollItem B left join PE_Client C on B.ClientID=C.ClientID");
            db.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            switch (searchType)
            {
                case 1:
                    db.SetParameterValue(storedProcCommand, "@Filter", " datediff(dd,B.DateAndTime,getdate())<10 ");
                    break;

                case 2:
                    db.SetParameterValue(storedProcCommand, "@Filter", " datediff(mm,B.DateAndTime,getdate())<1 ");
                    break;

                case 3:
                    db.SetParameterValue(storedProcCommand, "@Filter", " B.Money>0 ");
                    break;

                case 4:
                    db.SetParameterValue(storedProcCommand, "@Filter", " B.Money<0 ");
                    break;

                case 5:
                    db.SetParameterValue(storedProcCommand, "@Filter", " B.Status=1");
                    break;

                case 6:
                    db.SetParameterValue(storedProcCommand, "@Filter", " B.Status=0");
                    break;

                case 10:
                    HighLevelSearch(field, keyword, db, storedProcCommand);
                    break;

                case 11:
                    ComplexSearch(keyword, db, storedProcCommand);
                    break;
            }
            using (NullableDataReader reader = new NullableDataReader(db.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    BankrollItemInfo item = BankrollItemFromrdr(reader);
                    item.ClientName = reader.GetString("ClientName");
                    list.Add(item);
                }
            }
            this.m_TotalOfBankrollItem = (int) db.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public int GetMaxItemId()
        {
            return DBHelper.GetMaxId("PE_BankrollItem", "ItemID");
        }

        private static Parameters GetParameters(BankrollItemInfo bankrollItemInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@UserName", DbType.String, bankrollItemInfo.UserName);
            parameters.AddInParameter("@ClientID", DbType.Int32, bankrollItemInfo.ClientId);
            parameters.AddInParameter("@DateAndTime", DbType.DateTime, bankrollItemInfo.DateAndTime);
            parameters.AddInParameter("@Money", DbType.Currency, bankrollItemInfo.Money);
            parameters.AddInParameter("@MoneyType", DbType.Int32, bankrollItemInfo.MoneyType);
            parameters.AddInParameter("@CurrencyType", DbType.Int32, bankrollItemInfo.CurrencyType);
            parameters.AddInParameter("@eBankID", DbType.Int32, bankrollItemInfo.EBankId);
            parameters.AddInParameter("@Bank", DbType.String, bankrollItemInfo.Bank);
            parameters.AddInParameter("@OrderID", DbType.Int32, bankrollItemInfo.OrderId);
            parameters.AddInParameter("@PaymentID", DbType.Int32, bankrollItemInfo.PaymentId);
            parameters.AddInParameter("@Remark", DbType.String, bankrollItemInfo.Remark);
            parameters.AddInParameter("@LogTime", DbType.DateTime, bankrollItemInfo.LogTime);
            parameters.AddInParameter("@Inputer", DbType.String, bankrollItemInfo.Inputer);
            parameters.AddInParameter("@IP", DbType.String, bankrollItemInfo.IP);
            parameters.AddInParameter("@Status", DbType.Int32, bankrollItemInfo.Status);
            return parameters;
        }

        public ArrayList GetTotalInComeAndPayOutAll()
        {
            return GetIncomeAndPayout("select Isnull(sum(money),0) from PE_BankrollItem Where [Money]>0 and Status=1 ; select Isnull(sum(money),0) from PE_BankrollItem Where Money<0 and Status=1");
        }

        public ArrayList GetTotalInComeAndPayOutAll(int clientId)
        {
            return GetIncomeAndPayout(string.Format("select Isnull(sum(money),0) from PE_BankrollItem Where clientId={0} and [Money]>0 and Status=1 ; select Isnull(sum(money),0) from PE_BankrollItem Where clientId={0} and Money<0 and Status=1", clientId));
        }

        public ArrayList GetTotalInComeAndPayOutAll(string userName)
        {
            return GetIncomeAndPayout(string.Format("select Isnull(sum(money),0) from PE_BankrollItem Where UserName='{0}' and [Money]>0 and Status=1 ; select Isnull(sum(money),0) from PE_BankrollItem Where UserName='{0}' and Money<0 and Status=1", userName));
        }

        public int GetTotalOfBankrollItem()
        {
            return this.m_TotalOfBankrollItem;
        }

        public int GetTotalOfBill()
        {
            return this.m_TotalOfBill;
        }

        private static void HighLevelSearch(int field, string keyword, Database db, DbCommand procdbComm)
        {
            if (!string.IsNullOrEmpty(keyword))
            {
                switch (field)
                {
                    case 0:
                        db.SetParameterValue(procdbComm, "@Filter", " C.ShortedForm like '%" + keyword + "%' ");
                        return;

                    case 1:
                        db.SetParameterValue(procdbComm, "@Filter", " B.UserName like '%" + keyword + "%' ");
                        return;

                    case 2:
                        db.SetParameterValue(procdbComm, "@Filter", " B.Bank='" + keyword + "' ");
                        return;

                    case 3:
                        db.SetParameterValue(procdbComm, "@Filter", " datediff( dd , B.DateAndTime,'" + keyword + "') = 0 ");
                        return;

                    case 4:
                        db.SetParameterValue(procdbComm, "@Filter", " B.ClientID=" + keyword + "");
                        return;

                    case 5:
                        db.SetParameterValue(procdbComm, "@Filter", "B.OrderID=" + keyword + " and B.Money<0");
                        return;

                    case 6:
                        db.SetParameterValue(procdbComm, "@Filter", " B.UserName= '" + keyword + "'");
                        return;

                    case 7:
                        db.SetParameterValue(procdbComm, "@Filter", " B.UserName='" + keyword + "' And B.Money>0 And B.Status=1");
                        return;

                    case 8:
                        db.SetParameterValue(procdbComm, "@Filter", " B.UserName='" + keyword + "' And B.Money<0 And B.Status=1");
                        return;

                    default:
                        return;
                }
            }
        }

        public bool Update(BankrollItemInfo bankrollItemInfo)
        {
            Parameters cmdParams = GetParameters(bankrollItemInfo);
            cmdParams.AddInParameter("@ItemId", DbType.Int32, bankrollItemInfo.ItemId);
            return DBHelper.ExecuteProc("PR_Accessories_BankrollItem_Update", cmdParams);
        }
    }
}