Exemple #1
0
 private void map(CustomerCommendInfo oParam, DataRow tempdr)
 {
     oParam.SysNo         = Util.TrimIntNull(tempdr["SysNo"]);
     oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]);
     oParam.FriendName    = Util.TrimNull(tempdr["FriendName"]);
     oParam.CommendEmail  = Util.TrimNull(tempdr["CommendEmail"]);
     oParam.CommendTime   = Util.TrimDateNull(tempdr["CommendTime"]);
     oParam.CommendStatus = Util.TrimIntNull(tempdr["CommendStatus"]);
 }
Exemple #2
0
        public CustomerCommendInfo LoadCustomerCommend(string CommendEmail)
        {
            string  sql = "select * from customer_commend where commendemail=" + Util.ToSqlString(CommendEmail);
            DataSet ds  = SqlHelper.ExecuteDataSet(sql);

            if (!Util.HasMoreRow(ds))
            {
                return(null);
            }

            CustomerCommendInfo oInfo = new CustomerCommendInfo();

            map(oInfo, ds.Tables[0].Rows[0]);
            return(oInfo);
        }
Exemple #3
0
        public void CommendCustomerEmailVerified(int CustomerSysNo, string CommendEmail)
        {
            TransactionOptions options = new TransactionOptions();

            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout        = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {
                CustomerCommendInfo oInfo = LoadCustomerCommend(CommendEmail);
                if (oInfo == null)
                {
                    throw new BizException("");
                }
                decimal increment    = 5; //推荐的好友通过Email验证赠送5¥运费
                int     rowsAffected = new FreeShipFeeDac().SetFreeShipFee(CustomerSysNo, increment);
                if (rowsAffected != 1)
                {
                    throw new BizException("客户运费余额更新失败,可能因为运费余额不足。");
                }

                UpdateCustomerCommendStatus(CommendEmail, (int)AppEnum.CommendStatus.Registered);  //更新推荐状态

                if (increment != 0)
                {
                    int    freeShipFeeLogType       = (int)AppEnum.FreeShipFeeLogType.CustomerRegister;
                    string freeShipFeeLogMemo       = "推荐客户注册送运费 - " + CommendEmail;
                    CustomerFreeShipFeeLogInfo oLog = new CustomerFreeShipFeeLogInfo(CustomerSysNo, freeShipFeeLogType, increment, freeShipFeeLogMemo);
                    oLog.LogCheck = oLog.CalcLogCheck();

                    if (1 != new FreeShipFeeDac().Insert(oLog))
                    {
                        throw new BizException("增加运费余额失败");
                    }
                }

                scope.Complete();
            }
        }
Exemple #4
0
        public int Insert(CustomerCommendInfo oParam)
        {
            string     sql = @"INSERT INTO Customer_Commend
                            (
                            CustomerSysNo, FriendName, CommendEmail, CommendTime, CommendStatus
                            )
                            VALUES (
                            @CustomerSysNo, @FriendName, @CommendEmail, @CommendTime, @CommendStatus
                            );set @SysNo = SCOPE_IDENTITY();";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo         = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
            SqlParameter paramFriendName    = new SqlParameter("@FriendName", SqlDbType.NVarChar, 200);
            SqlParameter paramCommendEmail  = new SqlParameter("@CommendEmail", SqlDbType.NVarChar, 200);
            SqlParameter paramCommendTime   = new SqlParameter("@CommendTime", SqlDbType.DateTime);
            SqlParameter paramCommendStatus = new SqlParameter("@CommendStatus", SqlDbType.Int, 4);

            paramSysNo.Direction = ParameterDirection.Output;
            if (oParam.CustomerSysNo != AppConst.IntNull)
            {
                paramCustomerSysNo.Value = oParam.CustomerSysNo;
            }
            else
            {
                paramCustomerSysNo.Value = System.DBNull.Value;
            }
            if (oParam.FriendName != AppConst.StringNull)
            {
                paramFriendName.Value = oParam.FriendName;
            }
            else
            {
                paramFriendName.Value = System.DBNull.Value;
            }
            if (oParam.CommendEmail != AppConst.StringNull)
            {
                paramCommendEmail.Value = oParam.CommendEmail;
            }
            else
            {
                paramCommendEmail.Value = System.DBNull.Value;
            }
            if (oParam.CommendTime != AppConst.DateTimeNull)
            {
                paramCommendTime.Value = oParam.CommendTime;
            }
            else
            {
                paramCommendTime.Value = System.DBNull.Value;
            }
            if (oParam.CommendStatus != AppConst.IntNull)
            {
                paramCommendStatus.Value = oParam.CommendStatus;
            }
            else
            {
                paramCommendStatus.Value = System.DBNull.Value;
            }

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramCustomerSysNo);
            cmd.Parameters.Add(paramFriendName);
            cmd.Parameters.Add(paramCommendEmail);
            cmd.Parameters.Add(paramCommendTime);
            cmd.Parameters.Add(paramCommendStatus);

            return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
        }
Exemple #5
0
        public int Update(CustomerCommendInfo oParam)
        {
            string     sql = @"UPDATE Customer_Commend SET 
                            CustomerSysNo=@CustomerSysNo, FriendName=@FriendName, 
                            CommendEmail=@CommendEmail, CommendTime=@CommendTime, 
                            CommendStatus=@CommendStatus
                            WHERE SysNo=@SysNo";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo         = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
            SqlParameter paramFriendName    = new SqlParameter("@FriendName", SqlDbType.NVarChar, 200);
            SqlParameter paramCommendEmail  = new SqlParameter("@CommendEmail", SqlDbType.NVarChar, 200);
            SqlParameter paramCommendTime   = new SqlParameter("@CommendTime", SqlDbType.DateTime);
            SqlParameter paramCommendStatus = new SqlParameter("@CommendStatus", SqlDbType.Int, 4);

            if (oParam.SysNo != AppConst.IntNull)
            {
                paramSysNo.Value = oParam.SysNo;
            }
            else
            {
                paramSysNo.Value = System.DBNull.Value;
            }
            if (oParam.CustomerSysNo != AppConst.IntNull)
            {
                paramCustomerSysNo.Value = oParam.CustomerSysNo;
            }
            else
            {
                paramCustomerSysNo.Value = System.DBNull.Value;
            }
            if (oParam.FriendName != AppConst.StringNull)
            {
                paramFriendName.Value = oParam.FriendName;
            }
            else
            {
                paramFriendName.Value = System.DBNull.Value;
            }
            if (oParam.CommendEmail != AppConst.StringNull)
            {
                paramCommendEmail.Value = oParam.CommendEmail;
            }
            else
            {
                paramCommendEmail.Value = System.DBNull.Value;
            }
            if (oParam.CommendTime != AppConst.DateTimeNull)
            {
                paramCommendTime.Value = oParam.CommendTime;
            }
            else
            {
                paramCommendTime.Value = System.DBNull.Value;
            }
            if (oParam.CommendStatus != AppConst.IntNull)
            {
                paramCommendStatus.Value = oParam.CommendStatus;
            }
            else
            {
                paramCommendStatus.Value = System.DBNull.Value;
            }

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramCustomerSysNo);
            cmd.Parameters.Add(paramFriendName);
            cmd.Parameters.Add(paramCommendEmail);
            cmd.Parameters.Add(paramCommendTime);
            cmd.Parameters.Add(paramCommendStatus);

            return(SqlHelper.ExecuteNonQuery(cmd));
        }
Exemple #6
0
 public int InsertCustomerCommend(CustomerCommendInfo oParam)
 {
     return(new FreeShipFeeDac().Insert(oParam));
 }