public static bool Save(DeliveryAddressModel obj)
        {
            #region
            try
            {
                SqlParameter[] dbParams = GetDeliveryAddressParams(obj);

                if (obj.DeliveryAddressID == 0)
                {
                    obj.DeliveryAddressID = Convert.ToInt32(SQLHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, "DeliveryAddress_InsertUpdate", dbParams));
                    return obj.DeliveryAddressID > 0 ? true : false;
                }
                else
                {
                    var affectNum = SQLHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "DeliveryAddress_InsertUpdate", dbParams);
                    return affectNum > 0 ? true : false;
                }
            }
            catch (Exception e)
            {
                Exception ex = new Exception("DeliveryAddress-->InsertOrUpdate-->" + e.Message);

                ExceptionMessageDAL.Record(ex);
            }

            return false;
            #endregion
        }
 private static void FillModelFrom(SqlDataReader reader, DeliveryAddressModel obj)
 {
     #region
     if (reader != null && !reader.IsClosed)
     {
         obj.DeliveryAddressID = reader.IsDBNull(reader.GetOrdinal("DeliveryAddressID")) ? 0 : reader.GetInt64(reader.GetOrdinal("DeliveryAddressID"));
         obj.UserID = reader.IsDBNull(reader.GetOrdinal("UserID")) ? 0 : reader.GetInt64(reader.GetOrdinal("UserID"));
         obj.Consignee = reader.IsDBNull(reader.GetOrdinal("Consignee")) ? String.Empty : reader.GetString(reader.GetOrdinal("Consignee"));
         obj.AreaID = reader.IsDBNull(reader.GetOrdinal("AreaID")) ? 0 : reader.GetInt32(reader.GetOrdinal("AreaID"));
         obj.CityID = reader.IsDBNull(reader.GetOrdinal("CityID")) ? 0 : reader.GetInt32(reader.GetOrdinal("CityID"));
         obj.Address = reader.IsDBNull(reader.GetOrdinal("Address")) ? String.Empty : reader.GetString(reader.GetOrdinal("Address"));
         obj.Postcode = reader.IsDBNull(reader.GetOrdinal("Postcode")) ? String.Empty : reader.GetString(reader.GetOrdinal("Postcode"));
         obj.Phone = reader.IsDBNull(reader.GetOrdinal("Phone")) ? String.Empty : reader.GetString(reader.GetOrdinal("Phone"));
         obj.Mobile = reader.IsDBNull(reader.GetOrdinal("Mobile")) ? String.Empty : reader.GetString(reader.GetOrdinal("Mobile"));
         obj.IsDefault = reader.IsDBNull(reader.GetOrdinal("IsDefault")) ? false : reader.GetBoolean(reader.GetOrdinal("IsDefault"));
     }
     #endregion
 }
        private static SqlParameter[] GetDeliveryAddressParams(DeliveryAddressModel obj)
        {
            #region
            SqlParameter[] dbParams ={
                     SQLHelper.MakeParam(PARAM_DELIVERY_ADDRESS_I, SqlDbType.BigInt,0,obj.DeliveryAddressID),
                     SQLHelper.MakeParam(PARAM_USER_I, SqlDbType.BigInt,0,obj.UserID),
                     SQLHelper.MakeParam(PARAM_CONSIGNEE, SqlDbType.NVarChar, 20,obj.Consignee),
                     SQLHelper.MakeParam(PARAM_AREA_I, SqlDbType.Int,0,obj.AreaID),
                     SQLHelper.MakeParam(PARAM_CITY_I, SqlDbType.Int,0,obj.CityID),
                     SQLHelper.MakeParam(PARAM_ADDRESS, SqlDbType.NVarChar, 100,obj.Address),
                     SQLHelper.MakeParam(PARAM_POSTCODE, SqlDbType.NVarChar, 10,obj.Postcode),
                     SQLHelper.MakeParam(PARAM_PHONE, SqlDbType.NVarChar, 20,obj.Phone),
                     SQLHelper.MakeParam(PARAM_MOBILE, SqlDbType.NVarChar, 20,obj.Mobile),
                     SQLHelper.MakeParam(PARAM_IS_DEFAULT, SqlDbType.Bit,0,obj.IsDefault)
            };

            return dbParams;
            #endregion
        }
 /// <summary>
 /// 增加或者保存收货地址
 /// </summary>
 /// <returns></returns>
 public static bool SaveDeliveryAddress(DeliveryAddressModel deliveryAddress)
 {
     return DeliveryAddressDAL.Save(deliveryAddress);
 }