コード例 #1
0
        /// <summary>
        ///获取审核记录
        /// </summary>
        /// <param name="SysNo"></param>
        /// <returns></returns>
        public DataTable GetAuditHistory(int SysNo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetAuditHistory");

            cmd.SetParameterValue("@SysNo", SysNo);
            return(cmd.ExecuteDataTable());
        }
コード例 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            int categoryId = 2;

            //找出属性
            using (DataCommand cmd = DataCommandManager.GetDataCommand("MetaType"))
            {
                cmd.SetParameterValue("@CategoryId", categoryId);
                DataTable     dt = cmd.ExecuteDataTable();
                StringBuilder sb = new StringBuilder();

                foreach (DataRow dataRow in dt.Rows)
                {
                    string name            = dataRow["Name"].ToString();
                    string htmlContorlType = dataRow["HtmlContorlType"].ToString();
                    switch (htmlContorlType)
                    {
                    case "password":
                        sb.AppendFormat("  <input id=\"{0}\" type=\"password\" /><br/>", name);
                        break;

                    case "input":
                        sb.AppendFormat("  <input id=\"{0}\" type=\"text\" /><br/>", name);
                        break;

                    default:
                        break;
                    }
                }
                Html = sb.ToString();
            }
        }
コード例 #3
0
ファイル: ShoppingOrderDA.cs プロジェクト: sanlonezhang/ql
        public static string CreateGroupBuyingTicketSequence()
        {
            DataCommand command = DataCommandManager.GetDataCommand("CreateGroupBuyingTicketSequence");
            DataTable   dt      = command.ExecuteDataTable();

            return(dt.Rows[0][0].ToString());
        }
コード例 #4
0
        /// <summary>
        /// 根据属性得到所有属性值
        /// </summary>
        /// <param name="PropertySysNo"></param>
        /// <returns>DataTable</returns>
        public DataTable GetPropertyValueByPropertySysNo(int PropertySysNo)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("GetPropertyValueByPropertySysNo");

            dc.SetParameterValue("@PropertySysNo", PropertySysNo);
            return(dc.ExecuteDataTable());
        }
コード例 #5
0
        /// <summary>
        /// 根据产品线类别SysNo得到产品线
        /// </summary>
        /// <param name="CategorySysNo"></param>
        /// <returns>DataTable</returns>
        public DataTable GetProductLineByProductLineCategorySysNo(int CategorySysNo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetProductLineByProductLineCategorySysNo");

            cmd.SetParameterValue("@CategorySysNo", CategorySysNo);
            return(cmd.ExecuteDataTable());
        }
コード例 #6
0
        public DataTable GetWaitingRegisters(int?soSysNo)
        {
            DataCommand command = DataCommandManager.GetDataCommand("QueryWaitingRegisterForRefund");

            if (soSysNo == null)
            {
                List <int> waitingSO = ObjectFactory <IRefundDA> .Instance.GetWaitingSOForRefund();

                if (waitingSO != null && waitingSO.Count > 0)
                {
                    string sql = "C.[SOSysNo] IN(";

                    waitingSO.ForEach(item => sql += item + ",");

                    sql  = sql.TrimEnd(',');
                    sql += ")";

                    command.ReplaceParameterValue("#SOSysNo#", sql);
                }
                else
                {
                    command.ReplaceParameterValue("#SOSysNo#", "C.[SOSysNo] IS NULL");
                }
            }
            else
            {
                command.ReplaceParameterValue("#SOSysNo#", "C.[SOSysNo] = @SOSysNo");
            }

            command.SetParameterValue("@SOSysNo", soSysNo);
            command.SetParameterValue("@RefundStatus", RMARefundStatus.Abandon);

            return(command.ExecuteDataTable());
        }
コード例 #7
0
        public DataTable GetAccessoriesQueryConditionBySysNo(int SysNo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetAccessoriesQueryConditionBySysNo");

            cmd.SetParameterValue("@SysNo", SysNo);
            return(cmd.ExecuteDataTable());
        }
コード例 #8
0
        /// <summary>
        /// 查询商品
        /// </summary>
        /// <param name="filter"></param>
        /// <param name="totalCount"></param>
        /// <returns></returns>
        public DataTable QueryProductEx(NeweggProductQueryFilter filter, out int totalCount)
        {
            DataCommand command = DataCommandManager.GetDataCommand("QueryProductEx");

            filter.CompanyCode      = "8601";
            filter.CurrentUserSysNo = ServiceContext.Current.UserSysNo;
            CreateQueryProductCommand(filter, command);
            var sort      = filter.PagingInfo.SortBy;
            var sortField = "";
            var sortType  = "";

            if (!String.IsNullOrEmpty(sort))
            {
                var input    = Regex.Replace(filter.PagingInfo.SortBy.Trim(), "\\s+", " ");
                var pageArry = input.Split(' ');
                if (pageArry.Length == 2)
                {
                    sortField = pageArry[0];
                    sortType  = pageArry[1];
                }
            }
            command.SetParameterValue("@SortField", sortField);
            command.SetParameterValue("@SortType", sortType);
            command.SetParameterValue("@PageSize", filter.PagingInfo.PageSize);
            command.SetParameterValue("@PageCurrent", filter.PagingInfo.PageIndex);
            var columnConfig = new EnumColumnList
            {
                { "Status", typeof(ProductStatus) }
            };
            var table = command.ExecuteDataTable(columnConfig);

            totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
            return(table);
        }
コード例 #9
0
ファイル: PropertyQueryDA.cs プロジェクト: sanlonezhang/ql
        /// <summary>
        /// 查询属性
        /// </summary>
        /// <param name="queryCriteria"></param>
        /// <param name="totalCount"></param>
        /// <returns></returns>
        public DataTable QueryPropertyList(PropertyQueryFilter queryCriteria, out int totalCount)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("QueryPropertyList");

            if (string.IsNullOrEmpty(queryCriteria.PropertyName))
            {
                dc.SetParameterValue("@PropertyDescription", "");
            }
            else
            {
                dc.SetParameterValue("@PropertyDescription", "%" + queryCriteria.PropertyName.Trim() + "%");
            }

            dc.SetParameterValue("@IsActive", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
            dc.SetParameterValue("@CompanyCode", "8601");

            dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
            dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
            dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);

            var source = dc.ExecuteDataTable();

            totalCount = (int)dc.GetParameterValue("@TotalCount");

            return(source);
        }
コード例 #10
0
        /// <summary>
        /// 根据用户编号获取用户
        /// </summary>
        /// <param name="customerID">用户编号</param>
        /// <returns></returns>
        public static ArrayList GetCustomerByCustomerID(int customerID)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetCustomerByCustomerID");

            cmd.SetParameterValue("@CustomerID", customerID);
            return(DbHelper.DatatableConvertArrayList(cmd.ExecuteDataTable()));
        }
コード例 #11
0
        public object GetApplyForLoan()
        {
            DataTable dt;

            using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertApplyForLoan"))
            {
                cmd.CommandText = "select * from ApplyForLoan";
                dt = cmd.ExecuteDataTable();
            }


            var resultObj = new JQGridDataResult
            {
                // 总页数
                PageCount = 1,
                // 当前页
                PageIndex = 1,
                // 总记录数
                Total = dt.Rows.Count,
                // 数据
                Data = dt
            };

            return(resultObj);
        }
コード例 #12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     using (DataCommand cmd = DataCommandManager.GetDataCommand("TestSqlite"))
     {
         DataTable dt = cmd.ExecuteDataTable();
     }
 }
コード例 #13
0
        public DataTable QueryWHArea()
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("QueryWarehouse");

            cmd.SetParameterValue("@CompanyCode", "8601");
            return(cmd.ExecuteDataTable());
        }
コード例 #14
0
        /// <summary>
        /// 根据query得到CPSUser信息
        /// </summary>
        /// <param name="query"></param>
        /// <param name="totalCount"></param>
        /// <returns></returns>
        public DataTable GetCpsUser(CpsUserQueryFilter query, out int totalCount)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetCpsUser");

            cmd.SetParameterValue("@Status", query.AuditStatus);
            cmd.SetParameterValue("@UserType", query.UserType);
            cmd.SetParameterValue("@WebSiteType", query.WebSiteType);
            cmd.SetParameterValue("@IsAvailable", query.IsActive);
            cmd.SetParameterValue("@CustomerID", query.CustomerID);
            cmd.SetParameterValue("@ReceivablesName", query.ReceivablesName);
            cmd.SetParameterValue("@Email", query.Email);
            cmd.SetParameterValue("@Phone", query.Phone);
            cmd.SetParameterValue("@ImMessenger", query.ImMessenger);
            cmd.SetParameterValue("@RegisterDateFrom", query.RegisterDateFrom);
            cmd.SetParameterValue("@RegisterDateTo", query.RegisterDateTo);
            cmd.SetParameterValue("@PageIndex", query.PageInfo.PageIndex);
            cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize);
            cmd.SetParameterValue("@SortFiled", query.PageInfo.SortBy);
            EnumColumnList enumList = new EnumColumnList
            {
                { "Status", typeof(AuditStatus) },
                { "UserType", typeof(UserType) },
                { "IsAvailable", typeof(IsActive) },
                { "BankLock", typeof(IsLock) },
                { "BankAccountType", typeof(UserType) }
            };
            DataTable dt = new DataTable();

            dt         = cmd.ExecuteDataTable(enumList);
            totalCount = (int)cmd.GetParameterValue("@TotalCount");
            return(dt);
        }
コード例 #15
0
        public DataTable GetPurchaseOrderAccessories(int poSysNo)
        {
            DataCommand dataCommand = DataCommandManager.GetDataCommand("GetProductAccessoriesByPOSysno");

            dataCommand.SetParameterValue("@POSysNo", poSysNo);
            return(dataCommand.ExecuteDataTable());
        }
コード例 #16
0
        public virtual DataTable QueryProductCardInventoryByProductSysNo(int productSysNo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("QueryProductCardInventory");

            cmd.SetParameterValue("@ProductSysNo", productSysNo);
            return(cmd.ExecuteDataTable());
        }
コード例 #17
0
        public DataTable GetNeedSendMailPOForAutoCloseJob(int poSysNo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetNeedSendEmailPO");

            cmd.SetParameterValue("@PoSysNo", poSysNo);
            return(cmd.ExecuteDataTable());
        }
コード例 #18
0
ファイル: ProductConsultDA.cs プロジェクト: sanlonezhang/ql
        /// <summary>
        ///  获取厂商关于咨询的回复列表
        /// </summary>
        /// <param name="consultSysNo"></param>
        /// <returns></returns>
        public List <ProductConsultReply> GetProductConsultFactoryReplyList(int consultSysNo)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("ProductConsult_GetProductConsultFactoryReplyList");

            dc.SetParameterValue("@ConsultSysNo", consultSysNo);
            //EnumColumnList enumList = new EnumColumnList();
            //enumList.Add("Status", typeof(ECCentral.BizEntity.MKT.ReplyStatus));//前台展示状态
            //enumList.Add("Type", typeof(ECCentral.BizEntity.MKT.NYNStatus));//是否存在回复

            CodeNamePairColumnList pairList = new CodeNamePairColumnList();

            pairList.Add("Type", "MKT", "ConsultCategory");
            pairList.Add("Status", "MKT", "FactoryReplyStatus");

            DataTable dt = dc.ExecuteDataTable(pairList);
            List <ProductConsultReply> list = new List <ProductConsultReply>();

            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    list.Add(DataMapper.GetEntity <ProductConsultReply>(dr));
                }
            }
            return(list);
        }
コード例 #19
0
        /// <summary>
        /// 查询PM
        /// </summary>
        /// <param name="queryCriteria"></param>
        /// <param name="totalCount"></param>
        /// <returns></returns>
        public DataTable QueryProductManagerInfo(ProductManagerQueryFilter queryCriteria, out int totalCount)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("QueryProductManagerInfo");

            if (string.IsNullOrEmpty(queryCriteria.UserName))
            {
                dc.SetParameterValue("@PMUserName", "");
            }
            else
            {
                dc.SetParameterValue("@PMUserName", "%" + queryCriteria.UserName.Trim() + "%");
            }
            dc.SetParameterValue("@PMID", string.IsNullOrEmpty(queryCriteria.UserID) ? "" : queryCriteria.UserID);

            dc.SetParameterValue("@Status", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
            dc.SetParameterValue("@CompanyCode", "8601");

            dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
            dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
            dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);

            var source = dc.ExecuteDataTable();

            totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));

            return(source);
        }
コード例 #20
0
ファイル: VendorStoreQueryDA.cs プロジェクト: sanlonezhang/ql
        public DataTable QueryVendorStoreList(int vendorSysNo)
        {
            DataCommand dataCommand = DataCommandManager.GetDataCommand("GetVendorStoreInfoList");

            dataCommand.SetParameterValue("@VendorSysNo", vendorSysNo);
            return(dataCommand.ExecuteDataTable());
        }
コード例 #21
0
        /// <summary>
        /// 得到某类下所有的属性
        /// </summary>
        /// <param name="GetPropertyByCategory3SysNo"></param>
        /// <returns>DataTable</returns>
        public DataTable GetPropertyByCategory3SysNo(int Category3SysNo)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("GetPropertyByCategory3SysNo");

            dc.SetParameterValue("@Category3SysNo", Category3SysNo);
            return(dc.ExecuteDataTable());
        }
コード例 #22
0
        /// <summary>
        /// 获取所有需要审核的类别信息
        /// </summary>
        /// <param name="query"></param>
        /// <param name="TotalCount"></param>
        /// <returns></returns>
        public DataTable GetCategoryRequestApprovalList(CategoryRequestApprovalQueryFilter query, out int TotalCount)
        {
            DataCommand dc = null;

            switch (query.Category)
            {
            case CategoryType.CategoryType1:
                dc = DataCommandManager.GetDataCommand("GetCategoryRequest1List");
                break;

            case CategoryType.CategoryType2:
                dc = DataCommandManager.GetDataCommand("GetCategoryRequest2List");
                break;

            case CategoryType.CategoryType3:
                dc = DataCommandManager.GetDataCommand("GetCategoryRequest3List");
                break;

            default:
                dc = DataCommandManager.GetDataCommand("GetCategoryRequest1List");
                break;
            }
            dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
            dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
            dc.SetParameterValue("@CreateUserSysNo", 0);
            dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
            DataTable dt = new DataTable();

            dt         = dc.ExecuteDataTable();
            TotalCount = (int)dc.GetParameterValue("@TotalCount");
            return(dt);
        }
コード例 #23
0
ファイル: ProductExtDA.cs プロジェクト: sanlonezhang/ql
        public DataTable GetProductExtByQuery(ProductExtQueryFilter query, out int totalCount)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("GetItemExtList");

            dc.SetParameterValue("@ProductID", query.ProductID);
            dc.SetParameterValue("@ProductStatus", query.ProductStatus);

            if (query.ProductType != null)
            {
                dc.SetParameterValue("@ProductType", LegacyEnumMapper.ConvertProductType(query.ProductType.Value));
            }
            else
            {
                dc.SetParameterValue("@ProductType", null);
            }
            dc.SetParameterValue("@Manufacturer", query.Manufacturer);
            dc.SetParameterValue("@ProductPrice", query.ProductPrice);
            dc.SetParameterValue("@IsPermitRefund", query.IsPermitRefund);
            dc.SetParameterValue("@Category1", query.Category1);
            dc.SetParameterValue("@Category2", query.Category2);
            dc.SetParameterValue("@Category3", query.Category3);
            dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
            dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
            dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
            EnumColumnList enumList = new EnumColumnList
            {
                { "Status", typeof(ProductStatus) },
                { "IsPermitRefund", typeof(IsDefault) }
            };
            DataTable dt = new DataTable();

            dt         = dc.ExecuteDataTable(enumList);
            totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
            return(dt);
        }
コード例 #24
0
        public DataTable QueryVendorPayBalanceByVendorSysNo(int vendorSysNo)
        {
            DataCommand command = DataCommandManager.GetDataCommand("GetVendorPayBalanceByVendorSysNo");

            command.SetParameterValue("@VendorSysNo", vendorSysNo);
            return(command.ExecuteDataTable());
        }
コード例 #25
0
        public DataTable GetRmaPolicyLog(RmaPolicyLogQueryFilter filter, out int totalCount)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetRmaPolicyLog");

            cmd.SetParameterValue("@RmaPolicySysNo", filter.RmaPolicySysNO);
            cmd.SetParameterValue("@RmaPolicy", filter.RmaPolicy);
            cmd.SetParameterValue("@UpdateDateTo", filter.UpdateDateTo);
            cmd.SetParameterValue("@UpdateDateFrom", filter.UpdateDateFrom);
            cmd.SetParameterValue("@EditUserName", filter.EidtUserName);
            cmd.SetParameterValue("@pageIndex", filter.PagingInfo.PageIndex);
            cmd.SetParameterValue("@pageSize", filter.PagingInfo.PageSize);
            cmd.SetParameterValue("@sortField", filter.PagingInfo.SortBy);
            EnumColumnList enumList = new EnumColumnList
            {
                { "Status", typeof(RmaPolicyStatus) },
                { "Type", typeof(RmaPolicyType) },
                { "IsOnlineRequst", typeof(IsOnlineRequst) },
                { "OperationType", typeof(RmaLogActionType) },
            };
            DataTable dt = new DataTable();

            dt         = cmd.ExecuteDataTable(enumList);
            totalCount = (int)cmd.GetParameterValue("@totalCount");
            return(dt);
        }
コード例 #26
0
        /// <summary>
        /// 查询生产商
        /// </summary>
        /// <returns></returns>
        public virtual DataTable QueryManufacturer(ManufacturerQueryFilter queryCriteria, out int totalCount)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("QueryManufacturer");

            if (string.IsNullOrEmpty(queryCriteria.ManufacturerNameLocal))
            {
                dc.SetParameterValue("@ManufacturerName", "");
            }
            else
            {
                dc.SetParameterValue("@ManufacturerName", "%" + queryCriteria.ManufacturerNameLocal.Trim() + "%");
            }

            dc.SetParameterValue("@Status", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
            dc.SetParameterValue("@CompanyCode", "8601");

            dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
            dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
            dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);

            var source = dc.ExecuteDataTable(5, typeof(ManufacturerStatus));;

            totalCount = (int)dc.GetParameterValue("@TotalCount");
            return(source);
        }
コード例 #27
0
ファイル: CallingLogQueryDA.cs プロジェクト: sanlonezhang/ql
        public virtual DataTable GetUpdateUser(string CompanyCode)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("GetUpdateUser");

            cmd.SetParameterValue("@CompanyCode", CompanyCode);
            return(cmd.ExecuteDataTable());
        }
コード例 #28
0
ファイル: GiftCardDA.cs プロジェクト: sanlonezhang/ql
        /// <summary>
        /// 获取详细的礼品卡操作日志
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public List <GiftCardRedeemLog> GetGiftCardRedeemLogJoinSOMaster(string code)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("GiftCard_GetGiftCardRedeemLogJoinSOMaster");

            dc.SetParameterValue("@Code", code);

            EnumColumnList enumList = new EnumColumnList();

            enumList.Add("OrderStatus", typeof(ECCentral.BizEntity.SO.SOStatus));
            enumList.Add("RedeemStatus", typeof(ValidStatus));

            var dt = dc.ExecuteDataTable(enumList);

            if (dt != null && dt.Rows.Count > 0)
            {
                List <GiftCardRedeemLog> list = new List <GiftCardRedeemLog>();
                foreach (DataRow dr in dt.Rows)
                {
                    list.Add(DataMapper.GetEntity <GiftCardRedeemLog>(dr));
                }
                return(list);
            }
            else
            {
                return(null);
            }
            //using (IDataReader reader = dc.ExecuteDataReader())
            //{
            //    return DataMapper.GetEntityList<GiftCardOperateLog, List<GiftCardOperateLog>>(reader);
            //}
        }
コード例 #29
0
ファイル: GiftCardDA.cs プロジェクト: sanlonezhang/ql
        /// <summary>
        ///
        /// </summary>
        /// <param name="sysNo"></param>
        /// <param name="exchangeRate"></param>
        /// <param name="iPayPeriodType"></param>
        /// <returns></returns>
        public List <GiftCardFabrication> GetGiftCardFabricationItem(int sysNo, decimal exchangeRate, int iPayPeriodType)
        {
            //DataCommand dc = DataCommandManager.GetDataCommand("GiftCard_GetGiftCardFabricationItem");
            DataCommand dc = DataCommandManager.GetDataCommand("GiftVoucherProduct_GetFabricationItem");

            dc.SetParameterValue("@GiftCardFabricationSysNo", sysNo);
            //dc.SetParameterValue("@C3SysNo", AppSettingManager.GetSetting("MKT", "C3SysNoForGiftCardFabrication"));
            //dc.SetParameterValue("@ManufacturerSysNo", AppSettingManager.GetSetting("MKT", "ManufacturerSysNoForGiftCardFabrication"));
            //dc.SetParameterValue("@ExchangeRate", exchangeRate);
            //dc.SetParameterValue("@PayPeriodType", iPayPeriodType);
            //dc.SetParameterValue("@CompanyCode", "8601");

            var dt = dc.ExecuteDataTable();

            if (dt != null && dt.Rows.Count > 0)
            {
                List <GiftCardFabrication> list = new List <GiftCardFabrication>();
                foreach (DataRow dr in dt.Rows)
                {
                    list.Add(DataMapper.GetEntity <GiftCardFabrication>(dr));
                }
                return(list);
            }
            return(null);
        }
コード例 #30
0
 public DataTable GetUserInfo(int userId)
 {
     using (DataCommand cmd = DataCommandManager.GetDataCommand("GetUserInfo"))
     {
         cmd.SetParameterValue("@UserId", userId);
         return(cmd.ExecuteDataTable());
     }
 }