Example #1
0
        public override SqlParameter[] GetParameters()
        {
            M_Payment model = this;

            if (model.PayTime <= DateTime.MinValue)
            {
                model.PayTime = DateTime.Now;
            }
            if (model.SuccessTime <= DateTime.MinValue)
            {
                model.SuccessTime = DateTime.Now;
            }
            if (model.MoneyReal == 0)
            {
                model.MoneyReal = model.MoneyPay;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.PaymentID;
            sp[1].Value  = model.UserID;
            sp[2].Value  = model.PaymentNum;
            sp[3].Value  = model.PayPlatID;
            sp[4].Value  = model.MoneyPay;
            sp[5].Value  = model.MoneyTrue;
            sp[6].Value  = model.PayTime;
            sp[7].Value  = model.SuccessTime;
            sp[8].Value  = model.Status;
            sp[9].Value  = model.PlatformInfo;
            sp[10].Value = model.Remark;
            sp[11].Value = model.CStatus;
            sp[12].Value = model.AlipayNO;
            sp[13].Value = model.PayNo;
            sp[14].Value = model.ArriveMoney;
            sp[15].Value = model.ArriveDetail;
            sp[16].Value = model.MoneyID;
            sp[17].Value = model.MoneyReal;
            sp[18].Value = model.IsDel;
            sp[19].Value = model.UsePoint;
            sp[20].Value = model.SysRemark;
            sp[21].Value = model.UsePointArrive;
            sp[22].Value = model.PayType;
            sp[23].Value = model.PrePayInfo;
            sp[24].Value = model.code;
            return(sp);
        }
Example #2
0
        public M_Payment GetModelFromReader(DbDataReader rdr)
        {
            M_Payment model = new M_Payment();

            model.PaymentID      = Convert.ToInt32(rdr["PaymentID"]);
            model.UserID         = Convert.ToInt32(rdr["UserID"]);
            model.PaymentNum     = rdr["PaymentNum"].ToString();
            model.PayPlatID      = Convert.ToInt32(rdr["PayPlatID"]);
            model.MoneyPay       = Convert.ToDouble(rdr["MoneyPay"]);
            model.MoneyTrue      = Convert.ToDouble(rdr["MoneyTrue"]);
            model.PayTime        = ConvertToDate(rdr["PayTime"]);
            model.SuccessTime    = ConvertToDate(rdr["SuccessTime"]);
            model.Status         = Convert.ToInt32(rdr["Status"]);
            model.PlatformInfo   = ConverToStr(rdr["PlatformInfo"]);
            model.Remark         = ConverToStr(rdr["Remark"]);
            model.CStatus        = Convert.ToBoolean(rdr["CStatus"]);
            model.AlipayNO       = ConverToStr(rdr["AlipayNO"]);
            model.PayNo          = ConverToStr(rdr["PayNo"]);
            model.ArriveMoney    = ConverToDouble(rdr["ArriveMoney"]);
            model.ArriveDetail   = ConverToStr(rdr["ArriveDetail"]);
            model.MoneyID        = ConvertToInt(rdr["MoneyID"]);
            model.MoneyReal      = Convert.ToDouble(rdr["MoneyReal"]);
            model.IsDel          = ConvertToInt(rdr["IsDel"]);
            model.UsePoint       = ConverToDouble(rdr["UsePoint"]);
            model.SysRemark      = ConverToStr(rdr["SysRemark"]);
            model.UsePointArrive = ConverToDouble(rdr["UsePointArrive"]);
            model.PrePayInfo     = ConverToStr(rdr["PrePayInfo"]);
            model.PayType        = ConvertToInt(rdr["PayType"]);
            model.code           = ConverToStr(rdr["code"]);
            //兼容旧系统
            if (MoneyReal < 0)
            {
                MoneyReal = MoneyPay;
            }
            rdr.Close();
            return(model);
        }