예제 #1
0
 private void LoadFromRow(DataRow row)
 {
     Id = DBTool.GetIntFromRow(row, "Id", 0);
     ThirdPartyOrderId = DBTool.GetStringFromRow(row, "ThirdPartyOrderId", "");
     ProjectId         = DBTool.GetIntFromRow(row, "ProjectId", 0);
     RealName          = DBTool.GetStringFromRow(row, "RealName", "");
     Province          = DBTool.GetStringFromRow(row, "Province", "");
     City             = DBTool.GetStringFromRow(row, "City", "");
     County           = DBTool.GetStringFromRow(row, "County", "");
     Town             = DBTool.GetStringFromRow(row, "Town", "");
     Address          = DBTool.GetStringFromRow(row, "Address", "");
     Zip              = DBTool.GetStringFromRow(row, "Zip", "");
     Phone            = DBTool.GetStringFromRow(row, "Phone", "");
     Mobile           = DBTool.GetStringFromRow(row, "Mobile", "");
     Email            = DBTool.GetStringFromRow(row, "Email", "");
     Remark           = DBTool.GetStringFromRow(row, "Remark", "");
     InvoiceTitle     = DBTool.GetStringFromRow(row, "InvoiceTitle", "");
     InvoiceState     = DBTool.GetIntFromRow(row, "InvoiceState", 0);
     InvoiceType      = DBTool.GetIntFromRow(row, "InvoiceType", 0);
     InvoiceContent   = DBTool.GetIntFromRow(row, "InvoiceContent", 0);
     Amount           = DBTool.GetDecimalFromRow(row, "Amount", 0);
     Freight          = DBTool.GetIntFromRow(row, "Freight", 0);
     Payment          = DBTool.GetStringFromRow(row, "Payment", "");
     ReviewId         = DBTool.GetIntFromRow(row, "ReviewId", 0);
     OrderStatus      = DBTool.GetStringFromRow(row, "OrderStatus", "");
     IsTransformation = DBTool.GetIntFromRow(row, "IsTransformation", 0);
     OrderTime        = DBTool.GetDateTimeFromRow(row, "OrderTime");
     ItemDeliveryId   = DBTool.GetStringFromRow(row, "ItemDeliveryId", "");
     DeliveryCode     = DBTool.GetStringFromRow(row, "DeliveryCode", "");
     PrId             = DBTool.GetStringFromRow(row, "PrId", "");
 }
예제 #2
0
        public bool LoadFromComId(int ComId)
        {
            string  sql = string.Format(" select * from VIPCounterCompany where ComId={0} order by Id desc", ComId);//如果不小心为一个公司插入了多个专柜,读取最新的一个专柜 quxiaoshan 2015-5-21
            DataSet ds  = m_dbo.GetDataSet(sql);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                Id         = DBTool.GetIntFromRow(row, "Id", 0);
                ComId      = DBTool.GetIntFromRow(row, "ComId", 0);
                CounterId  = DBTool.GetIntFromRow(row, "CounterId", 0);
                UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime");
                Discount   = DBTool.GetDecimalFromRow(row, "Discount", 1);
                return(true);
            }
            return(false);
        }
예제 #3
0
 private void LoadFromRow(DataRow row)
 {
     Id                = DBTool.GetIntFromRow(row, "Id", 0);
     GoodsId           = DBTool.GetIntFromRow(row, "GoodsId", 0);
     BranchId          = DBTool.GetIntFromRow(row, "BranchId", 0);
     IsVisible         = DBTool.GetIntFromRow(row, "IsVisible", 0);
     IsAllow           = DBTool.GetIntFromRow(row, "IsAllow", 0);
     IsPublic          = DBTool.GetIntFromRow(row, "IsPublic", 0);
     UserId            = DBTool.GetIntFromRow(row, "UserId", 0);
     UpdateTime        = DBTool.GetDateTimeFromRow(row, "UpdateTime");
     IsWeb             = DBTool.GetIntFromRow(row, "IsWeb", 0);
     Price             = DBTool.GetDecimalFromRow(row, "Price", 0);
     PriceRate         = DBTool.GetDecimalFromRow(row, "PriceRate", 0);
     IsChangePrice     = DBTool.GetIntFromRow(row, "IsChangePrice", 0);
     IsChangeRecommend = DBTool.GetIntFromRow(row, "IsChangeRecommend", 0);
     Recommend         = DBTool.GetIntFromRow(row, "Recommend", 0);
 }
예제 #4
0
        public bool Load()
        {
            string sql = string.Format("select * from TPI_GoodsCompare where 1=1");

            if (GoodsId > 0)
            {
                sql += string.Format(" and GoodsId={0}", GoodsId);
            }
            if (Id > 0)
            {
                sql += string.Format(" and Id={0}", Id);
            }
            if (XHMC != "" && XHMC != null)
            {
                sql += string.Format("and XHMC='{0}'", XHMC);
            }
            DataSet ds = m_dbo.GetDataSet(sql);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                Id          = DBTool.GetIntFromRow(row, "Id", 0);
                HNSCGoodsId = DBTool.GetIntFromRow(row, "HNSCGoodsId", 0);
                LBBH        = DBTool.GetStringFromRow(row, "LBBH", "");
                LBMC        = DBTool.GetStringFromRow(row, "LBMC", "");
                PMBH        = DBTool.GetStringFromRow(row, "PMBH", "");
                PMMC        = DBTool.GetStringFromRow(row, "PMMC", "");
                PPBH        = DBTool.GetStringFromRow(row, "PPBH", "");
                PPMC        = DBTool.GetStringFromRow(row, "PPMC", "");
                XHBH        = DBTool.GetStringFromRow(row, "XHBH", "");
                XHMC        = DBTool.GetStringFromRow(row, "XHMC", "");
                Xyghbh      = DBTool.GetStringFromRow(row, "Xyghbh", "");
                GoodsId     = DBTool.GetIntFromRow(row, "GoodsId", 0);
                IsInStore   = DBTool.GetIntFromRow(row, "IsInStore", 0);
                State       = DBTool.GetIntFromRow(row, "State", 0);
                IsShelves   = DBTool.GetIntFromRow(row, "IsShelves", 0);
                Note        = DBTool.GetStringFromRow(row, "Note", "");
                UpdateTime  = DBTool.GetDateTimeFromRow(row, "UpdateTime");
                Price       = DBTool.GetDecimalFromRow(row, "Price", 0);
                sjjg        = DBTool.GetDecimalFromRow(row, "sjjg", 0);
                Reason      = DBTool.GetStringFromRow(row, "Reason", "");
                return(true);
            }
            return(false);
        }
예제 #5
0
        public bool Load()
        {
            string  sql = string.Format("select * from VIPCounterCompany where id={0}", Id);
            DataSet ds  = m_dbo.GetDataSet(sql);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                Id         = DBTool.GetIntFromRow(row, "Id", 0);
                ComId      = DBTool.GetIntFromRow(row, "ComId", 0);
                CounterId  = DBTool.GetIntFromRow(row, "CounterId", 0);
                UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime");
                Discount   = DBTool.GetDecimalFromRow(row, "Discount", 1);
                UserId     = DBTool.GetIntFromRow(row, "UserId", 0);
                return(true);
            }
            return(false);
        }
예제 #6
0
        public bool Load()
        {
            string  sql = string.Format("select * from OrderPayState where OrderId={0}", OrderId);
            DataSet ds  = m_dbo.GetDataSet(sql);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                Id            = DBTool.GetIntFromRow(row, "Id", 0);
                OrderId       = DBTool.GetIntFromRow(row, "OrderId", 0);
                MemberId      = DBTool.GetIntFromRow(row, "MemberId", 0);
                OrderSumMoney = DBTool.GetDecimalFromRow(row, "OrderSumMoney", 0);
                OrderTime     = DBTool.GetDateTimeFromRow(row, "OrderTime");
                PayState      = DBTool.GetIntFromRow(row, "PayState", 0);
                IsInner       = DBTool.GetIntFromRow(row, "IsInner", 0);
                PayRemarks    = DBTool.GetStringFromRow(row, "PayRemarks", "");
                UpdateTime    = DBTool.GetDateTimeFromRow(row, "UpdateTime");
                return(true);
            }
            return(false);
        }
예제 #7
0
        public bool Load()
        {
            string  sql = string.Format("select * from TPI_OrderDetail where id={0}", Id);
            DataSet ds  = m_dbo.GetDataSet(sql);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                Id               = DBTool.GetIntFromRow(row, "Id", 0);
                TPI_OrderId      = DBTool.GetIntFromRow(row, "TPI_OrderId", 0);
                GoodsId          = DBTool.GetIntFromRow(row, "GoodsId", 0);
                SkuName          = DBTool.GetStringFromRow(row, "SkuName", "");
                prDetailId       = DBTool.GetStringFromRow(row, "prDetailId", "");
                Num              = DBTool.GetIntFromRow(row, "Num", 0);
                AgreementPrice   = DBTool.GetDecimalFromRow(row, "AgreementPrice", 0);
                Price            = DBTool.GetDecimalFromRow(row, "Price", 0);
                Amount           = DBTool.GetDecimalFromRow(row, "Amount", 0);
                status           = DBTool.GetIntFromRow(row, "status", 0);
                InvoiceRequireId = DBTool.GetIntFromRow(row, "InvoiceRequireId", 0);
                return(true);
            }
            return(false);
        }
예제 #8
0
        public bool Load()
        {
            string  sql = string.Format("select * from TPI_Category where id={0}", Id);
            DataSet ds  = m_dbo.GetDataSet(sql);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                Id           = DBTool.GetIntFromRow(row, "Id", 0);
                ProjectId    = DBTool.GetIntFromRow(row, "ProjectId", 0);
                Category1    = DBTool.GetStringFromRow(row, "Category1", "");
                Category2    = DBTool.GetStringFromRow(row, "Category2", "");
                Category     = DBTool.GetStringFromRow(row, "Category", "");
                CategoryId   = DBTool.GetIntFromRow(row, "CategoryId", 0);
                TypeName     = DBTool.GetStringFromRow(row, "TypeName", "");
                TypeId       = DBTool.GetIntFromRow(row, "TypeId", 0);
                UpdateTime   = DBTool.GetDateTimeFromRow(row, "UpdateTime");
                CategoryCode = DBTool.GetStringFromRow(row, "CategoryCode", "");
                Discount     = DBTool.GetDecimalFromRow(row, "Discount", 0);
                UserId       = DBTool.GetIntFromRow(row, "UserId", 0);
                return(true);
            }
            return(false);
        }