Пример #1
0
        /// <summary>
        /// ERP FOrderReceiveMoney.cs 中调用
        /// </summary>
        /// <returns></returns>
        public bool Delete()
        {
            this.Load();
            OrderStatement os = new OrderStatement();

            os.Id = this.OrderStatementId;

            string sql = string.Format(" delete from OrderReceiveMoney where Id={0} ", this.Id);

            if (m_dbo.ExecuteNonQuery(sql))
            {
                os.UpdateStatus();
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #2
0
        /// <summary>
        /// ERP FOrderReceiveMoney.cs 中调用
        /// </summary>
        /// <returns></returns>
        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("@OrderStatementId", m_OrderStatementId));
            arrayList.Add(new SqlParameter("@ReceiveMoney", Math.Round(m_ReceiveMoney, 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("@ReceiveDate", m_ReceiveDate));
            arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
            arrayList.Add(new SqlParameter("@ChargeOff", m_ChargeOff));//add by quxiaoshan 2014-11-07

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

            if (this.Id > 0)
            {
                OrderStatement os = new OrderStatement();
                os.Id = this.OrderStatementId;
                os.UpdateStatus();
            }
            return(this.Id);
        }