Пример #1
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@ApplyId", ApplyId));
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@Status", Status));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@ConfirmLevel", ConfirmLevel));
            arrayList.Add(new SqlParameter("@Amount", Amount));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("ConfirmProcess", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("ConfirmProcess", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #2
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@OutBranchId", OutBranchId));
            arrayList.Add(new SqlParameter("@InBranchId", InBranchId));
            arrayList.Add(new SqlParameter("@OutStoreId", OutStoreId));
            arrayList.Add(new SqlParameter("@OutStoreUserId", OutStoreUserId));
            arrayList.Add(new SqlParameter("@InStoreId", InStoreId));
            arrayList.Add(new SqlParameter("@InStoreUserId", InStoreUserId));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@UpdateDate", UpdateDate));
            arrayList.Add(new SqlParameter("@OutStoreDate", OutStoreDate));
            arrayList.Add(new SqlParameter("@InStoreDate", InStoreDate));
            arrayList.Add(new SqlParameter("@Status", Status));
            arrayList.Add(new SqlParameter("@IsInner", IsInner));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Transfer", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Transfer", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #3
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@ComId", ComId));
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@MemberName", MemberName));
            arrayList.Add(new SqlParameter("@DeptId", DeptId));
            arrayList.Add(new SqlParameter("@DeptName", DeptName));
            arrayList.Add(new SqlParameter("@ChooseDeptId", ChooseDeptId));
            arrayList.Add(new SqlParameter("@ChooseDeptName", ChooseDeptName));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("BuyAdmin", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("BuyAdmin", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #4
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@BiddingName", BiddingName));
            arrayList.Add(new SqlParameter("@BiddingUrl", BiddingUrl));
            arrayList.Add(new SqlParameter("@Brddingrecording", Brddingrecording));
            arrayList.Add(new SqlParameter("@CrawlUrl", CrawlUrl));
            arrayList.Add(new SqlParameter("@Biddingcharset", Biddingcharset));
            arrayList.Add(new SqlParameter("@Crawtitle", Crawtitle));
            arrayList.Add(new SqlParameter("@Istitle", Istitle));
            arrayList.Add(new SqlParameter("@Crawarea", Crawarea));
            arrayList.Add(new SqlParameter("@CrawTime", CrawTime));
            arrayList.Add(new SqlParameter("@CrawPosition", CrawPosition));
            arrayList.Add(new SqlParameter("@Crawfrequency", Crawfrequency));
            arrayList.Add(new SqlParameter("@Remark", Remark));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("CrawInfo", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("CrawInfo", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #5
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@BranchId", m_BranchId));
            arrayList.Add(new SqlParameter("@Name", m_Name));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@UserId", m_UserId));
            arrayList.Add(new SqlParameter("@AddTime", m_AddTime));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("VIPCounter", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("VIPCounter", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #6
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@OrderId", OrderId));
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@OrderSumMoney", OrderSumMoney));
            arrayList.Add(new SqlParameter("@OrderTime", OrderTime));
            arrayList.Add(new SqlParameter("@PayState", PayState));
            arrayList.Add(new SqlParameter("@PayRemarks", PayRemarks));
            arrayList.Add(new SqlParameter("@IsInner", IsInner));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (Id > 0)
            {
                m_dbo.UpdateData("OrderPayState", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                Id = m_dbo.InsertData("OrderPayState", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(Id);
        }
Пример #7
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@Status", Status));
            arrayList.Add(new SqlParameter("@SumMoney", SumMoney));
            arrayList.Add(new SqlParameter("@MemberAddressId", MemberAddressId));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@ConfirmLevel", ConfirmLevel));
            arrayList.Add(new SqlParameter("@OperatorId", OperatorId));
            arrayList.Add(new SqlParameter("@NewDeptId", NewDeptId));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("VIPApply", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("VIPApply", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #8
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@BranchId", m_BranchId));
            arrayList.Add(new SqlParameter("@Name", m_Name));
            arrayList.Add(new SqlParameter("@IsAvalible", m_IsAvalible));
            arrayList.Add(new SqlParameter("@Place", m_Place));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@IsDefault", m_IsDefault));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("Store", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Store", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #9
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@FK_CustomerId", FK_CustomerId));
            arrayList.Add(new SqlParameter("@FK_UsersId", FK_UsersId));
            arrayList.Add(new SqlParameter("@Contents", Contents));
            arrayList.Add(new SqlParameter("@CreateTime", CreateTime));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@UpdatePerson", UpdatePerson));
            arrayList.Add(new SqlParameter("@NextTime", NextTime));
            arrayList.Add(new SqlParameter("@ReviewPerson", ReviewPerson));
            arrayList.Add(new SqlParameter("@ReviewPhone", ReviewPhone));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("CustomerReview", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("CustomerReview", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #10
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@SDeptName", SDeptName));
            arrayList.Add(new SqlParameter("@SComId", SComId));
            arrayList.Add(new SqlParameter("@SCode", SCode));
            arrayList.Add(new SqlParameter("@SPCode", SPCode));
            arrayList.Add(new SqlParameter("@SLevel", SLevel));
            arrayList.Add(new SqlParameter("@SUpdateTime", SUpdateTime));
            arrayList.Add(new SqlParameter("@SUserId", SUserId));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("StoreDept", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("StoreDept", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #11
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@Titel", Titel));
            arrayList.Add(new SqlParameter("@UserId", UserId));
            arrayList.Add(new SqlParameter("@Type", Type));
            arrayList.Add(new SqlParameter("@ImagePath", ImagePath));
            arrayList.Add(new SqlParameter("@Coutent", Coutent));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@BranchId", BranchId));
            arrayList.Add(new SqlParameter("@VideoPath", VideoPath));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_UpLoad", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_UpLoad", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #12
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@PurchaseId", m_PurchaseId));
            arrayList.Add(new SqlParameter("@GoodsId", m_GoodsId));
            arrayList.Add(new SqlParameter("@StoreId", m_StoreId));
            arrayList.Add(new SqlParameter("@Model", m_Model));
            arrayList.Add(new SqlParameter("@BillsPrice", m_BillsPrice));
            arrayList.Add(new SqlParameter("@InPrice", m_InPrice));
            arrayList.Add(new SqlParameter("@Num", m_Num));
            arrayList.Add(new SqlParameter("@Amount", m_Amount));
            arrayList.Add(new SqlParameter("@OldStore", m_OldStore));
            arrayList.Add(new SqlParameter("@OldAC", m_OldAC));
            arrayList.Add(new SqlParameter("@ReceivedNum", m_ReceivedNum));
            arrayList.Add(new SqlParameter("@Emergency", m_Emergency));
            arrayList.Add(new SqlParameter("@TaxInPrice", TaxInPrice));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("PurchaseDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("PurchaseDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #13
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@OrderId", m_OrderId));
            arrayList.Add(new SqlParameter("@UserId", m_UserId));
            arrayList.Add(new SqlParameter("@Status", m_Status));
            arrayList.Add(new SqlParameter("@IsInner", m_IsInner));
            arrayList.Add(new SqlParameter("@OperateTime", m_OperateTime));
            arrayList.Add(new SqlParameter("@UserName", m_UserName));
            arrayList.Add(new SqlParameter("@StatusId", m_StatusId));
            arrayList.Add(new SqlParameter("@TPIStatus", m_TPIStatus));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("OrderStatusDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("OrderStatusDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #14
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@LBBH", LBBH));
            arrayList.Add(new SqlParameter("@LBMC", LBMC));
            arrayList.Add(new SqlParameter("@PMBH", PMBH));
            arrayList.Add(new SqlParameter("@PMMC", PMMC));
            arrayList.Add(new SqlParameter("@PPBH", PPBH));
            arrayList.Add(new SqlParameter("@PPMC", PPMC));
            arrayList.Add(new SqlParameter("@XHBH", XHBH));
            arrayList.Add(new SqlParameter("@XHMC", XHMC));
            arrayList.Add(new SqlParameter("@Xyghbh", Xyghbh));
            arrayList.Add(new SqlParameter("@AddTime", AddTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_HNSCGoods", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_HNSCGoods", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #15
0
        public int save()
        {
            ArrayList arrayList = new ArrayList();

            if (this.Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", this.Id));
            }
            arrayList.Add(new SqlParameter("@GoodsId", this.GoodsId));
            arrayList.Add(new SqlParameter("@Point", this.Point));
            arrayList.Add(new SqlParameter("@MaxNum", this.MaxNum));
            arrayList.Add(new SqlParameter("@IsValid", this.IsValid));
            arrayList.Add(new SqlParameter("@GiftName", this.GiftName));
            arrayList.Add(new SqlParameter("@UserId", this.UserId));
            arrayList.Add(new SqlParameter("@UpdateTime", this.UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("Gift", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Gift", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #16
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@ProjectId", ProjectId));
            arrayList.Add(new SqlParameter("@Category1", Category1));
            arrayList.Add(new SqlParameter("@Category2", Category2));
            arrayList.Add(new SqlParameter("@Category", Category));
            arrayList.Add(new SqlParameter("@CategoryId", CategoryId));
            arrayList.Add(new SqlParameter("@TypeName", TypeName));
            arrayList.Add(new SqlParameter("@TypeId", TypeId));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@CategoryCode", CategoryCode));
            arrayList.Add(new SqlParameter("@Discount", Discount));
            arrayList.Add(new SqlParameter("@UserId", UserId));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_Category", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_Category", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #17
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@ComId", ComId));
            arrayList.Add(new SqlParameter("@VIPUrl", VIPUrl));
            arrayList.Add(new SqlParameter("@LogoUrl", LogoUrl));
            arrayList.Add(new SqlParameter("@LoginImgUrl", LoginImgUrl));
            arrayList.Add(new SqlParameter("@IsEnable", IsEnable));
            arrayList.Add(new SqlParameter("@IsMultLang", IsMultLang));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@SystemName", SystemName));
            arrayList.Add(new SqlParameter("@SystemEnName", SystemEnName));
            arrayList.Add(new SqlParameter("@CounterIcon", CounterIcon));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("VIPSiteInfo", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("VIPSiteInfo", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #18
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@PurchaseId", m_PurchaseId));
            arrayList.Add(new SqlParameter("@StoreId", m_StoreId));
            arrayList.Add(new SqlParameter("@PurchaseId", m_PurchaseId));
            arrayList.Add(new SqlParameter("@StoreId", m_StoreId));
            arrayList.Add(new SqlParameter("@UserId", m_UserId));
            arrayList.Add(new SqlParameter("@GoodsId", m_GoodsId));
            arrayList.Add(new SqlParameter("@OldNum", m_OldNum));
            arrayList.Add(new SqlParameter("@Num", m_Num));
            arrayList.Add(new SqlParameter("@NewNum", m_NewNum));
            arrayList.Add(new SqlParameter("@OldPrice", m_OldPrice));
            arrayList.Add(new SqlParameter("@NewPrice", m_NewPrice));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("PurchaseDetailLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("PurchaseDetailLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #19
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@TypeName", m_TypeName));
            arrayList.Add(new SqlParameter("@EnTypeName", m_EnTypeName));
            arrayList.Add(new SqlParameter("@Code", m_Code));
            arrayList.Add(new SqlParameter("@PCode", m_PCode));
            arrayList.Add(new SqlParameter("@Level", m_Level));
            arrayList.Add(new SqlParameter("@PriceRate", m_PriceRate));
            arrayList.Add(new SqlParameter("@Alias", m_Alias));
            arrayList.Add(new SqlParameter("@IsVisible", m_IsVisible));
            arrayList.Add(new SqlParameter("@Rate", m_Rate));
            arrayList.Add(new SqlParameter("@GuiGe", m_GuiGe));
            arrayList.Add(new SqlParameter("@JiaGe", m_JiaGe));
            arrayList.Add(new SqlParameter("@BieMing", m_BieMing));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@PY", CommenClass.StringTools.GetFirstPYLetter("(" + m_TypeName + ")" + m_EnTypeName)));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("GoodsType", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("GoodsType", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #20
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@TPI_OrderId", TPI_OrderId));
            arrayList.Add(new SqlParameter("@GoodsId", GoodsId));
            arrayList.Add(new SqlParameter("@SkuName", SkuName));
            arrayList.Add(new SqlParameter("@prDetailId", prDetailId));
            arrayList.Add(new SqlParameter("@Num", Num));
            arrayList.Add(new SqlParameter("@AgreementPrice", AgreementPrice));
            arrayList.Add(new SqlParameter("@Price", Price));
            arrayList.Add(new SqlParameter("@Amount", Amount));
            arrayList.Add(new SqlParameter("@status", status));
            arrayList.Add(new SqlParameter("@InvoiceRequireId", InvoiceRequireId));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_OrderDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_OrderDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #21
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@CounterId", CounterId));
            arrayList.Add(new SqlParameter("@GoodsId", GoodsId));
            arrayList.Add(new SqlParameter("@VIPPrice", VIPPrice));
            arrayList.Add(new SqlParameter("@Remark", Remark));
            arrayList.Add(new SqlParameter("@ExportDate", ExportDate));
            arrayList.Add(new SqlParameter("@Level", Level));
            arrayList.Add(new SqlParameter("@IsSales", IsSales));
            arrayList.Add(new SqlParameter("@IsSpecial", IsSpecial));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("VIPCounterDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("VIPCounterDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #22
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@PurchaseUserId", m_PurchaseUserId));
            arrayList.Add(new SqlParameter("@Title", m_Title));
            arrayList.Add(new SqlParameter("@SumMoney", Math.Round(m_SumMoney, 2)));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@ConfirmUserId", m_ConfirmUserId));
            arrayList.Add(new SqlParameter("@BranchId", m_BranchId));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("PurchaseCashConfirm", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("PurchaseCashConfirm", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #23
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@Name", Name));
            arrayList.Add(new SqlParameter("@BranchId", BranchId));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@Code", Code));
            arrayList.Add(new SqlParameter("@PCode", PCode));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("sys_dept", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("sys_dept", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #24
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@MemberId", m_MemberId));
            arrayList.Add(new SqlParameter("@RealName", m_RealName));
            arrayList.Add(new SqlParameter("@Address", GetAddress()));
            arrayList.Add(new SqlParameter("@Province", m_Province));
            arrayList.Add(new SqlParameter("@City", m_City));
            arrayList.Add(new SqlParameter("@Area", m_Area));
            arrayList.Add(new SqlParameter("@Street", m_Street));
            arrayList.Add(new SqlParameter("@Mansion", m_Mansion));
            arrayList.Add(new SqlParameter("@Room", m_Room));
            arrayList.Add(new SqlParameter("@TelPhone", m_TelPhone));
            arrayList.Add(new SqlParameter("@Mobile", m_Mobile));
            arrayList.Add(new SqlParameter("@Email", m_Email));
            arrayList.Add(new SqlParameter("@IsDefault", m_IsDefault));
            arrayList.Add(new SqlParameter("@IdCard", m_IdCard));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("MemberAddress", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("MemberAddress", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #25
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@TransferId", TransferId));
            arrayList.Add(new SqlParameter("@GoodsId", GoodsId));
            arrayList.Add(new SqlParameter("@Model", Model));
            arrayList.Add(new SqlParameter("@Unit", Unit));
            arrayList.Add(new SqlParameter("@AC", AC));
            arrayList.Add(new SqlParameter("@Num", Num));
            arrayList.Add(new SqlParameter("@Amount", Amount));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@UpdateDate", UpdateDate));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TransferDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TransferDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #26
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@ComId", ComId));
            arrayList.Add(new SqlParameter("@DeptId", DeptId));
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@IsDept", IsDept));
            arrayList.Add(new SqlParameter("@IsPersonal", IsPersonal));
            arrayList.Add(new SqlParameter("@Budget", YearBudget));
            arrayList.Add(new SqlParameter("@MonthBudget", MonthBudget));
            arrayList.Add(new SqlParameter("@MaxOrderNum", MaxOrderNum));
            arrayList.Add(new SqlParameter("@StartDate", StartDate));
            arrayList.Add(new SqlParameter("@EndDate", EndDate));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Budget", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Budget", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #27
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@InvoiceTaxNo", InvoiceTaxNo));
            arrayList.Add(new SqlParameter("@InvoiceAddress", InvoiceAddress));
            arrayList.Add(new SqlParameter("@InvoicePhone", InvoicePhone));
            arrayList.Add(new SqlParameter("@InvoiceBank", InvoiceBank));
            arrayList.Add(new SqlParameter("@InvoiceAccount", InvoiceAccount));
            arrayList.Add(new SqlParameter("@InvoiceMemo", InvoiceMemo));
            arrayList.Add(new SqlParameter("@MemberName", MemberName));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("InvoiceMemberInfo", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("InvoiceMemberInfo", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #28
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@ConfigType", ConfigType));
            arrayList.Add(new SqlParameter("@ConfigValue", ConfigValue));
            arrayList.Add(new SqlParameter("@MemberId", MemberId));
            arrayList.Add(new SqlParameter("@DeptId", DeptId));
            arrayList.Add(new SqlParameter("@ComId", ComId));
            arrayList.Add(new SqlParameter("@StartTime", StartTime));
            arrayList.Add(new SqlParameter("@EndTime", EndTime));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("OrderConfig", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("OrderConfig", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #29
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@GoodsId", GoodsId));
            arrayList.Add(new SqlParameter("@CategoryCode", CategoryCode));
            arrayList.Add(new SqlParameter("@ProjectId", ProjectId));
            arrayList.Add(new SqlParameter("@IsUserType", IsUserType));
            arrayList.Add(new SqlParameter("@Updatetime", Updatetime));
            arrayList.Add(new SqlParameter("@Type", Type));
            arrayList.Add(new SqlParameter("@Note", Note));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_MessagePush", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_MessagePush", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Пример #30
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@TypeId", TypeId));
            arrayList.Add(new SqlParameter("@Name", Name));
            arrayList.Add(new SqlParameter("@Sort", Sort));
            arrayList.Add(new SqlParameter("@IsGroup", IsGroup));
            arrayList.Add(new SqlParameter("@GoodsParamGroupId", GoodsParamGroupId));
            arrayList.Add(new SqlParameter("@UserId", UserId));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("GoodsParam", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("GoodsParam", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }