Example #1
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@RoleId", m_RoleId));
            arrayList.Add(new SqlParameter("@AuthorityId", m_AuthorityId));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_RoleAuthority", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_RoleAuthority", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #2
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@Mobile", Mobile));
            arrayList.Add(new SqlParameter("@SMSCode", SMSCode));
            arrayList.Add(new SqlParameter("@SMSNumber", SMSNumber));
            arrayList.Add(new SqlParameter("@SendTime", SendTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("SmsStore", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("SmsStore", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #3
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@Mobile", Mobile));
            arrayList.Add(new SqlParameter("@SMSContent", SMSContent));
            arrayList.Add(new SqlParameter("@Status", Status));
            arrayList.Add(new SqlParameter("@Addtime", Addtime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sms", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sms", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #4
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("@DeliveryUserId", m_DeliveryUserId));
            arrayList.Add(new SqlParameter("@DistributeUserId", m_DistributeUserId));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@PrintNum", m_PrintNum));
            arrayList.Add(new SqlParameter("@Address", m_Address));
            arrayList.Add(new SqlParameter("@Latitude", m_Latitude));
            arrayList.Add(new SqlParameter("@Longitude", m_Longitude));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("OrderDelivery", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("OrderDelivery", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            OrderBox ob = new OrderBox();

            if (!ob.IsBoxOrder(this.OrderId))
            {
                if (this.Id > 0)//扫码装车不能在这里修改订单状态
                {
                    //修改订单状态
                    OrderStatus os = new OrderStatus();
                    os.LoadFromOrderId(this.OrderId);
                    os.UpdateStatus(CommenClass.OrderStatusType.配送, CommenClass.Order_Status.已接受, m_DeliveryUserId);
                }
            }
            return(this.Id);
        }
Example #5
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@LineName", m_LineName));
            arrayList.Add(new SqlParameter("@LineRange", m_LineRange));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));

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

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@RoleId", RoleId));
            arrayList.Add(new SqlParameter("@MenuId", MenuId));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_RoleMenu", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_RoleMenu", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #7
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@OrderBoxDeliveryId", OrderBoxDeliveryId));
            arrayList.Add(new SqlParameter("@OrderId", OrderId));
            arrayList.Add(new SqlParameter("@Content", Content));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Crm_DeliveryLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Crm_DeliveryLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #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("@PurchaseStatementId", m_PurchaseStatementId));
            arrayList.Add(new SqlParameter("@PayMoney", Math.Round(m_PayMoney, 2)));
            arrayList.Add(new SqlParameter("@PayStatus", m_PayStatus));
            arrayList.Add(new SqlParameter("@BankAccountId", m_BankAccountId));
            arrayList.Add(new SqlParameter("@PayType", m_PayType));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@UserId", m_UserId));
            arrayList.Add(new SqlParameter("@PayDate", m_PayDate));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@ChargeOff", Math.Round(m_ChargeOff, 2)));


            if (this.Id > 0)
            {
                m_dbo.UpdateData("PurchasePay", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
                //新增
            }
            else
            {
                this.Id = m_dbo.InsertData("PurchasePay", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
                //修改
            }
            if (this.Id > 0)
            {
                PurchaseStatement ps = new PurchaseStatement();
                ps.Id = this.PurchaseStatementId;
                ps.UpdateStatus();
            }
            return(this.Id);
        }
Example #9
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("@PlatName", PlatName));
            arrayList.Add(new SqlParameter("@Account", Account));
            arrayList.Add(new SqlParameter("@RegisterDate", RegisterDate));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("MemberThirdPlat", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("MemberThirdPlat", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #10
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@Url", m_Url));
            arrayList.Add(new SqlParameter("@ErrorMessage", m_ErrorMessage));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_ErrorLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_ErrorLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #11
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@DeptId", DeptId));
            arrayList.Add(new SqlParameter("@ComId", ComId));
            arrayList.Add(new SqlParameter("@StoreId", StoreId));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("StoreCustomerDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("StoreCustomerDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #12
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("@CategoryCode", CategoryCode));
            arrayList.Add(new SqlParameter("@AttrName", AttrName));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_Goodsparam", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_Goodsparam", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #13
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@UserId", UserId));
            arrayList.Add(new SqlParameter("@ProjectId", ProjectId));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@IsAdmin", IsAdmin));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_Authority", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_Authority", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@UserId", UserId));
            arrayList.Add(new SqlParameter("@ReviewDay", ReviewDay));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            arrayList.Add(new SqlParameter("@UpdatePerson", UpdatePerson));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("CustomerReviewParameter", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("CustomerReviewParameter", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #15
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@LoginName", LoginName));
            arrayList.Add(new SqlParameter("@PassWord", PassWord));
            arrayList.Add(new SqlParameter("@Name", Name));
            arrayList.Add(new SqlParameter("@BranchId", BranchId));
            arrayList.Add(new SqlParameter("@DeptId", DeptId));
            arrayList.Add(new SqlParameter("@IsSales", IsSales));
            arrayList.Add(new SqlParameter("@Telphone", Telphone));
            arrayList.Add(new SqlParameter("@Mobile", Mobile));
            arrayList.Add(new SqlParameter("@BirthDay", BirthDay));
            arrayList.Add(new SqlParameter("@IsYinLi", IsYinLi));
            arrayList.Add(new SqlParameter("@JoinDate", JoinDate));
            arrayList.Add(new SqlParameter("@IDCard", IDCard));
            arrayList.Add(new SqlParameter("@ModifyTime", ModifyTime));
            arrayList.Add(new SqlParameter("@IsValid", IsValid));
            arrayList.Add(new SqlParameter("@Position", Position));
            arrayList.Add(new SqlParameter("@SN1", SN1));
            arrayList.Add(new SqlParameter("@SN2", SN2));
            arrayList.Add(new SqlParameter("@IsAdmin", IsAdmin));
            arrayList.Add(new SqlParameter("@token", token));
            arrayList.Add(new SqlParameter("@tokenEndDate", tokenEndDate));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_Users", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_Users", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #16
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("@StoreId", m_StoreId));
            arrayList.Add(new SqlParameter("@SupplierId", m_SupplierId));
            arrayList.Add(new SqlParameter("@PurchaseType", m_PurchaseType));
            arrayList.Add(new SqlParameter("@SumMoney", Math.Round(m_SumMoney, 2)));
            arrayList.Add(new SqlParameter("@PurchaseDate", m_PurchaseDate));
            arrayList.Add(new SqlParameter("@PurchaseUserId", m_PurchaseUserId));
            arrayList.Add(new SqlParameter("@IsTax", m_IsTax));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@IsConfirm", m_IsConfirm));
            arrayList.Add(new SqlParameter("@IsCashConfirm", m_IsCashConfirm));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@UserId", m_UserId));
            arrayList.Add(new SqlParameter("@IsPaid", m_IsPaid));
            arrayList.Add(new SqlParameter("@PurchaseStatus", m_PurchaseStatus));
            arrayList.Add(new SqlParameter("@NeedToPurchaseId", m_NeedToPurchaseId));
            arrayList.Add(new SqlParameter("@ReceiptUserId", m_ReceiptUserId));
            arrayList.Add(new SqlParameter("@ConfirmDate", m_ConfirmDate));
            arrayList.Add(new SqlParameter("@Tax", Tax));
            arrayList.Add(new SqlParameter("@TaxRate", TaxRate));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Purchase", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Purchase", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #17
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (this.Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", this.Id));
            }
            arrayList.Add(new SqlParameter("@NoticeId", this.NoticeId));
            arrayList.Add(new SqlParameter("@UserId", this.UserId));
            arrayList.Add(new SqlParameter("@IsHaveSee", this.IsHaveSee));
            arrayList.Add(new SqlParameter("@UpdateTime", this.UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("NoticeRecord", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("NoticeRecord", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #18
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@CarId", CarId));
            arrayList.Add(new SqlParameter("@CarUserId", CarUserId));
            arrayList.Add(new SqlParameter("@StockOutUserId", StockOutUserId));
            arrayList.Add(new SqlParameter("@Status", Status));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("OrderBoxDelivery", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("OrderBoxDelivery", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #19
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@Code", Code));
            arrayList.Add(new SqlParameter("@Name", Name));
            arrayList.Add(new SqlParameter("@Parent", Parent));
            arrayList.Add(new SqlParameter("@Type", Type));
            arrayList.Add(new SqlParameter("@ProjectId", ProjectId));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_Province", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_Province", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #20
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("@Token", Token));
            arrayList.Add(new SqlParameter("@StartTime", StartTime));
            arrayList.Add(new SqlParameter("@EndTime", EndTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("EmailApply", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("EmailApply", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #21
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("@GoodsId", GoodsId));
            arrayList.Add(new SqlParameter("@Model", Model));
            arrayList.Add(new SqlParameter("@Num", Num));
            arrayList.Add(new SqlParameter("@VIPPrice", VIPPrice));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("VIPApplyDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("VIPApplyDetail", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #22
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@GoodsACId", GoodsACId));
            arrayList.Add(new SqlParameter("@OldAC", OldAC));
            arrayList.Add(new SqlParameter("@NewAC", NewAC));
            arrayList.Add(new SqlParameter("@UserId", UserId));
            arrayList.Add(new SqlParameter("@UpdateTime", DateTime.Now));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("GoodsACModify", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("GoodsACModify", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #23
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@DSFBrandId", DSFBrandId));
            arrayList.Add(new SqlParameter("@DSFBrandName", DSFBrandName));
            arrayList.Add(new SqlParameter("@BrandId", BrandId));
            arrayList.Add(new SqlParameter("@BrandName", BrandName));
            arrayList.Add(new SqlParameter("@ProjectId", ProjectId));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_DSFBrand", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_DSFBrand", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #24
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("@GoodsId", GoodsId));
            arrayList.Add(new SqlParameter("@Model", Model));
            arrayList.Add(new SqlParameter("@Num", Num));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("MemberCart", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("MemberCart", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #25
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@Name", m_Name));
            arrayList.Add(new SqlParameter("@GroupName", m_GroupName));
            arrayList.Add(new SqlParameter("@Memo", m_Memo));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));

            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_Role", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_Role", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #26
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@BId", BId));
            arrayList.Add(new SqlParameter("@Crawltitle", Crawltitle));
            arrayList.Add(new SqlParameter("@Crawlurl", Crawlurl));
            arrayList.Add(new SqlParameter("@Addtime", Addtime));
            arrayList.Add(new SqlParameter("@IsSend", IsSend));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("CrawlTable", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("CrawlTable", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #27
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (m_Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", m_Id));
            }
            arrayList.Add(new SqlParameter("@Version", m_Version));
            arrayList.Add(new SqlParameter("@Files", m_Files));
            arrayList.Add(new SqlParameter("@WhatsNew", m_WhatsNew));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@Name", m_Name));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_Updater", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_Updater", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #28
0
        public int Save()
        {
            ArrayList arrayList = new ArrayList();

            if (Id > 0)
            {
                arrayList.Add(new SqlParameter("@Id", Id));
            }
            arrayList.Add(new SqlParameter("@BranchId", BranchId));
            arrayList.Add(new SqlParameter("@Plate", Plate));
            arrayList.Add(new SqlParameter("@IsEnable", IsEnable));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("Sys_Car", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("Sys_Car", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #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("@ProjectId", ProjectId));
            arrayList.Add(new SqlParameter("@TheState", TheState));
            arrayList.Add(new SqlParameter("@Memo", Memo));
            arrayList.Add(new SqlParameter("@Ctime", Ctime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("TPI_AddGoodsLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("TPI_AddGoodsLog", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }
Example #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("@ComId", ComId));
            arrayList.Add(new SqlParameter("@Rate", Rate));
            arrayList.Add(new SqlParameter("@UserId", UserId));
            arrayList.Add(new SqlParameter("@UpdateTime", UpdateTime));
            if (this.Id > 0)
            {
                m_dbo.UpdateData("VIPCounterRate", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            else
            {
                this.Id = m_dbo.InsertData("VIPCounterRate", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
            }
            return(this.Id);
        }