com.huiyou.Bll/AddressService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using com.huiyou.Dal;
using com.huiyou.Model;
using com.huiyou.Model.Tables;
using com.huiyou.Common;
using System.Data;

namespace com.huiyou.Bll
{
    public class AddressService
    {
        public static int GetMaxId()
        {
            string sql = "select ISNULL(max(ID),0) from Tb_Address";
            int id = Convert.ToInt32(DBHelper.SelectValue(sql));
            return id;
        }

        public static Tb_Address GetDefaultAddress(int userId)
        {
            string sql = "select * from Tb_Address where CurStatus=0 and UserId=" + userId;
            List<Tb_Address> rst = TableFactory.GetList<Tb_Address>(sql);
            Tb_Address address = null;

            foreach (var add in rst)
            {
                if (add.IsDefault == 1)
                    address = add;
            }

            if (address == null && rst.Count > 0)
                address = rst[0];

            return address;
        }

        public static void SetAsDefault(int id)
        {
            string sql = "select UserId from Tb_Address where id=" + id;
            DataTable dt = DBHelper.SelectDataSet(sql).Tables[0];
            if (dt.Rows.Count <= 0) return;

            string userId = dt.Rows[0]["userId"].ToString();

            sql = "update Tb_Address set IsDefault=0 where UserId=" + userId;
            DBHelper.Execute(sql);

            sql = "update Tb_Address set IsDefault=1 where id=" + id;
            DBHelper.Execute(sql);
        }

        public static Tb_Address GetById(int id)
        {
            string sql = "select * from Tb_Address where id=" + id;
            List<Tb_Address> rst = TableFactory.GetList<Tb_Address>(sql);
            if (rst.Count == 0) return null;