加入购物车功能实现

来源:互联网 发布:手机制作结婚照软件 编辑:程序博客网 时间:2024/04/30 10:05

表有汇PC端购物车功能实现

加入购物车实际上就是将你选择的商品的ID、颜色、数量新增进购物车表

商品介绍页面:


成功后提示:


购物车界面:


加入购物车的表和表的关系

加入购物车用到的表有:商品表(dt_goods)、购物车表(dt_shoppingCar)、用户表(dt_users

商品表表的字段有:商品id、标题、副标题、商品编号、库存数量、市场价格、销售价格、积分、颜色、宽度、长度、表扣、机芯id、防水深度id、品牌id、材质id、、调用别名、URL跳转地址、图片地址、SEO标题、SEO关键字、SEO描述、摘要、详细内容、排序、浏览次数、状态、阅读权限、关联投票ID、是否允许评论、是否置顶、是否推荐、是否热门、是否幻灯片、是管理员发布、用户名、创建时间、修改时间

列名

数据类型

主键/外键

说明

id

Int

主键

商品id

title

nvarchar(255)

 

标题

sub_title

nvarchar(255)

 

副标题

goods_no

nvarchar(100)

 

商品编号

stock_quantity

Int

 

库存数量

market_price

decimal(9, 2)

 

市场价格

sell_price

decimal(9, 2)

 

销售价格

point

int

 

积分

color

nvarchar(255)

 

颜色

width

nvarchar(255)

 

宽度

length

nvarchar(255)

 

长度

buckles

nvarchar(255)

 

表扣

movement

int

外键

机芯id

waterproof_id

int

外键

防水深度id

brand_id

int

外键

品牌id

material

int

外键

材质id

call_index

nvarchar(100)

 

调用别名

link_url

nvarchar(255)

 

url跳转地址

img_url

nvarchar(255)

 

图片地址

seo_title

nvarchar(255)

 

Seo标题

seo_keywords

nvarchar(255)

 

Seo关键字

seo_description

nvarchar(255)

 

Seo描述

zhaiyao

nvarchar(255)

 

摘要

content

next

 

详细内容

sort_id

int

 

排序

click

int

 

浏览次数

status

tinyint

 

状态

groupids_view

nvarchar(255)

 

阅读权限

vote_id

int

 

关联投票id

is_msg

int

 

是否允许评论

is_top

int

 

是否置顶

is_red

int

 

是否推荐

is_hot

int

 

是否热门

is_slide

int

 

是否幻灯片

is_sys

int

 

是否管理员发布

user_name

nvarchar(100)

 

用户名

add_time

datetime

 

创建时间

update_time

datetime

 

修改时间



购物车表的字段有:购物车id、商品id、用户id、数量、颜色、有效否。

列名

数据类型

主键/外键

说明

id

int

主键

购物车id

goods_id

int

外键

商品id

user_id

int

外键

用户id

quantity

int

 

数量

color

nvarchar

 

颜色

youxiaofou

bit

 

有效否


用户表的字段有:用户id、用户组id、用户名、密码、6位随机字符串,加密用到、电子邮箱用户昵称、头像、性别、生日、联系电话、手机号码、QQ号码、联系地址、安全问题、问题答案、预存款、用户积分、经验值、用户状态、注册时间、注册IP、经度、纬度、城市、介绍、执照照片、场地照片、身份证号                                       

列名

数据类型

主键/外键

说明

id

int

主键

用户id

group_id

int

外键

用户组id

user_name

nvarchar(100)

 

用户名

password

nvarchar(100)

 

密码

salt

nvarchar(20)

 

6位随机字符串加密用到

email

nvarchar(50)

 

电子邮箱

nick_name

nvarchar(100)

 

用户昵称

avatar

nvarchar(255)

 

头像

sex

nvarchar(20)

 

性别

birthday

datetime

 

生日

telphone

nvarchar(50)

 

联系电话

mobile

nvarchar(20)

 

手机号码

qq

nvarchar(30)

 

QQ号码

address

nvarchar(255)

 

联系地址

safe_question

nvarchar(255)

 

安全问题

safe_answer

nvarchar(255)

 

问题答案

amount

decimal(9, 2)

 

预存款

point

int

 

用户积分

exp

int

 

经验值

status

tinyint

 

用户状态

reg_time

datetime

 

注册时间

reg_ip

nvarchar(30)

 

注册IP

longitude

nvarchar(100)

 

经度

latitude

nvarchar(100)

 

纬度

city

nvarchar(100)

 

城市

content

ntext

 

介绍

license_img

nvarchar(255)

 

执照照片

place_img

nvarchar(255)

 

场地照片

shenfenzheng

nvarchar(255)

 

身份证号

关系图:


功能模块的具体实现:这个功能是利用dtcms3.0进行的二次开发(如想了解系统架构可以参考http://wenku.baidu.com/view/b8b080d2d15abe23482f4d3f.html)

商品介绍页代码:

 <dl class="head green">                    <dt>购物商城</dt>                    <dd>                        <span>当前位置:<a href="<%linkurl("index","")%>">首页 </a>><a href="<%linkurl("goods","")%>">购物商城</a>{category_nav}</span>                    </dd>                </dl>                <div class="line20">                </div>                <!--商品图片-->                <div class="left294">                    <!--幻灯片开始-->                    <div class="pictureDIV">                        <div id="preview" class="spec-preview">                            <span class="jqzoom">                                <img /></span>                        </div>                        <!--缩图开始-->                        <div class="spec-scroll">                            <a class="prev"><</a> <a class="next">></a>                            <div class="items">                                <ul>                                    <%if(model.albums!=null)%>                                    <%foreach(DTcms.Model.goods_albums modelt in model.albums)%>                                    <li>                                        <img bimg="{modelt.original_path}" src="{modelt.thumb_path}" onmousemove="preview(this);" /></li>                                    <%/foreach%>                                    <%/if%>                                </ul>                            </div>                        </div>                        <!--缩图结束-->                    </div>                    <!--幻灯片结束-->                </div>                <!--/商品图片-->                <!--商品属性-->                <div class="pro-attr right356">                    <h1>                        {model.title}</h1>                    <div class="pro-items">                        <dl>                            <dt>商品货号:</dt>                            <dd>                                {model.goods_no}                                </dd>                        </dl>                        <dl>                            <dt>销售价格:</dt>                            <dd><b class="red">¥{model.sell_price}</b></dd>                        </dl>                        <dl>                            <dt>颜色选择:</dt>                            <%if(yanse!=null)%>                                                        <dd>                            <%for(int i=0;i<yanse.Length;i++)%>                            <a id="<%=str[i]%>" href="javascript:void()" style="border: 1px solid #CCCCCC; margin-top:10px;"                             onclick="selected(this.id);">                            <b class="green" style="font-family:宋体; font-size:8;"><%=yanse[i]%></b>                            </a>                              <%/for%>                                                        </dd>                                                        <%else%>                            <dd><b class="red">抱歉,该商品没有颜色选择</b></dd>                            <%/if%>                              <script>                                  var count = 0;                                   function selected(id) {                                                                                                                 if (count != id) {                                          $('#goods_color').val(id);                                          var kk = document.getElementById(id);                                          kk.style.border = "2px solid red";                                                                                    if (parseInt(count) != 0) {                                              var hh = document.getElementById(count);                                              hh.style.border = "1px solid #CCCCCC";                                          }                                          count = id;                                                                       }                                      else {  }                                                                        }                              </script>                        </dl>                        <!--<dl>                            <dt>会员价格:</dt>                            <dd>                                <%set decimal user_price=get_user_goods_price(model.id)%>                                <%if(user_price>-1)%>                                <b class="red">¥{user_price}</b>                                <%else%>                                登录可见                                <%/if%>                            </dd>                        </dl>-->                        <dl>                            <dt>上架时间:</dt>                            <dd>                                {model.add_time}</dd>                        </dl>                    </div>                    <div class="pro-btns">                        <div class="input-box">                            购买数量:<input name="goods_id" id="goods_id" type="hidden" value="{model.id}" /><input                            <input name="goods_color" id="goods_color" type="hidden" value="" />                            <input type="text" name="goods_quantity" id="goods_quantity" value="1" class="txt" style="ime-mode: disabled" />                        </div>                        <div class="btn-box">                            <%if({model.stock_quantity}>0)%>                            <a href="javascript:void(0);" class="add" onclick="CartAdd(this, '{config.webpath}', 0, '<%linkurl("shopping","cart")%>');">                                加入购物车</a> <a href="javascript:void(0);" class="buy" onclick="CartAdd(this, '{config.webpath}', 1, '<%linkurl("shopping","confirm")%>');">                                    立即购买</a>                            <%else%>                            <a title="该商品供货紧张,无法加入购物车" class="add-over">加入购物车</a> <a title="该商品供货紧张,无法立即购买" class="buy-over">                                立即购买</a>                            <%/if%>                        </div>                    </div>                    <div class="line10">                    </div>                    <!--分享-->                    <%template src="_share2_js.html"%>                    <!--/分享-->                </div>                <!--/商品属性-->

与加入购物车相对应的js代码:

//添加进购物车function CartAdd(obj, webpath, linktype, linkurl) {    if ($("#goods_id").val() == "" || $("#goods_quantity").val() == "" || $("#goods_color").val() == "") {        return false;   //判断商品ID、数量、颜色其中一个是否为空,如果为空就返回false    }    $.ajax({  //使用ajax异步操作        type: "post", //这里使用post提交,提交时不显示具体的参数;而get提交与post反之,get:传送数据量小,处理效率高,安全性低,会被缓存        url: webpath + "tools/submit_ajax.ashx?action=cart_goods_add",//路径及参数值        data: { //发送到服务器的数据            "goods_id": $("#goods_id").val(),            "goods_quantity": $("#goods_quantity").val(),            "goods_color":$("#goods_color").val()        },        dataType: "json", //数据类型        beforeSend: function (XMLHttpRequest) {            //发送前动作        },        success: function (data, textStatus) { //成功后的动作            if (data.status == 1) {  //判断返回值,从而执行不同操作,当然data.status == 1 是成功的返回值                if (linktype == 1) {                    location.href = linkurl;                } else {  //添加成功的提示操作                    $("#cart_info_hint").remove();                     var HintHtml = '<div id="cart_info_hint" class="msg_tips cart_info">'+ '<div class="ico"></div>'+ '<div class="msg">'+ '<strong>商品已成功添加到购物车!</strong>'+ '<p>购物车共有<b>' + data.quantity + '</b>件商品,合计:<b class="red">' + data.amount + '</b>元</p>'+ '<a class="btn btn-success" title="去购物车结算" href="' + linkurl + '">去结算</a>  '+ '<a title="再逛逛" href="javascript:;" onclick="HintRemove(\'cart_info_hint\');">再逛逛</a>'+ '<a class="close" title="关闭" href="javascript:;" onclick="HintRemove(\'cart_info_hint\');"><span>关闭</span></a>'+ '</div>'+ '</div>'                    $(obj).after(HintHtml); //添加节点                }            } else if (data.status == 0) {  //返回值为0时的提示操作,当data.status == 0时就是失败了,原因:商品ID或者颜色的值没有传到submit_ajax.ashx的cart_goods_add方法                $("#cart_info_hint").remove();                var HintHtml = '<div id="cart_info_hint" class="msg_tips cart_info">'+ '<div class="ico error"></div>'+ '<div class="msg">'+ '<strong>商品添加到购物车失败!</strong>'+ '<p>' + data.msg + '</p>'+ '<a class="close" title="关闭" href="javascript:void(0);" onclick="HintRemove(\'cart_info_hint\');"><span>关闭</span></a>'+ '</div>'+ '</div>'                $(obj).after(HintHtml); //添加节点                //alert(data.msg);            }            else if (data.status == 2) {  //返回值为2时的提示操作,当data.status == 2时就是还没有登陆                $("#cart_info_hint").remove();                var HintHtml = '<div id="cart_info_hint" class="msg_tips cart_info">'+ '<div class="ico error"></div>'+ '<div class="msg">'+ '<strong>商品添加到购物车失败!</strong>'+ '<p>' + data.msg + '<a href="javascript:void(0)" onclick="eee()">马上登陆</a>吧!</p>'  //马上 亲,您还没有登录呢,+ '<a class="close" title="关闭" href="javascript:void(0);" onclick="HintRemove(\'cart_info_hint\');"><span>关闭</span></a>'+ '</div>'+ '</div>'                $(obj).after(HintHtml); //添加节点            }        },        error: function (XMLHttpRequest, textStatus, errorThrown) {            alert("状态:" + textStatus + ";出错提示:" + errorThrown);        },        timeout: 20000    });    return false;}

ajax相对应的方法:

public class submit_ajax : IHttpHandler, IRequiresSessionState{    public void ProcessRequest(HttpContext context)    {            //取得处事类型        string action = DTRequest.GetQueryString("action");        switch (action)        {            case "cart_goods_add": //购物车加入商品            cart_goods_add(context);            break;        }    }<pre name="code" class="html">    #region 购物车加入商品OK==============可以了,把cooke换过来了=============        private void cart_goods_add(HttpContext context)        {            string goods_id = DTRequest.GetFormString("goods_id");   //商品ID            int goods_quantity = DTRequest.GetFormInt("goods_quantity", 1);  //商品数量            string goods_color_id = DTRequest.GetFormString("goods_color");  //商品颜色ID            if (goods_id == "" || goods_color_id == "")            {                context.Response.Write("{\"status\":0, \"msg\":\"您提交的商品参数有误!\"}");                return;            }            //查找会员组,用户ID:user_id            int group_id = 0;            int user_id = 0;            Model.users groupModel = new Web.UI.BasePage().GetUserInfo();            //groupModel.id            if (groupModel != null)            {                group_id = groupModel.group_id;                user_id = groupModel.id;                Model.shoppingcar carModel = new Model.shoppingcar();                carModel.goods_id = Convert.ToInt32(goods_id);                carModel.user_id = user_id;                carModel.quantity = goods_quantity;                string yanse = new BLL.goods().get_Title(Convert.ToInt32(goods_color_id));                                BLL.shoppingcar car = new BLL.shoppingcar();  //实例化购物车类BLL                DataTable dt = car.getList(user_id).Tables[0];  //查询该用户的购物车                for (int i = 0; i < dt.Rows.Count; i++)  //利用for循环遍历该用户购物车的每一行数据                {                    string str_goods_id = dt.Rows[i]["goods_id"].ToString(); //从数据库查询该用户的购物车,并获取商品ID                     int id = Convert.ToInt32(dt.Rows[i]["id"]);             //购物车ID                    string color =dt.Rows[i]["color"].ToString();       //获取颜色                    if (str_goods_id == goods_id && color == yanse)  //如果存在相同的商品ID和颜色,就执行if方法                    {                        carModel.id = id;                        carModel.quantity = carModel.quantity + 1;  //数量加1                    }                    else    //如果是商品ID等与颜色不同要增加; 商品ID不同也需要增加,这就执行else方法                    {                        carModel.color = yanse;                    }                }                //因为加入购物车是对于单个商品来说,所以是添加还是修改就放到外面来实现就好,如果放到for里面就重复了几次操作                if (carModel.id > 0) { car.Update(carModel); }  //如果相同就修改一条数据                else { int bit = car.Add(carModel); }           //没有相同的商品,就添加一条数据                                             //Web.UI.ShopCart.Add(carModel);   //这里是加入数据库的数据表                //统计购物车                  //Web.UI.ShopCart.Add(goods_id, goods_quantity);   //这是加入cooke                //获取购物车商品信息                Model.car_total car_total = new Model.car_total();                string str = car.get_quantity(user_id);                string[] ss = str.Split(';');//用;进行分割                //判断数量、积分、金额判断是否为空,如果为空整型的转化就会出错                if (Convert.ToInt32(ss[0]) > 0)  //因为在BLL传过来的时候已经给了它一个初始值,所以在这里是可以转换成整形的                {                    car_total.total_quantity = Convert.ToInt32(ss[0]);    //查询购物车商品件数                }                if (Convert.ToInt32(ss[1]) > 0)                {                    car_total.real_amount = Convert.ToInt32(ss[1]);       //查询购物车商品总金额                }                if (Convert.ToInt32(ss[2]) > 0)                {                    car_total.total_point = Convert.ToInt32(ss[2]);       //查询购物车商品总积分                }                context.Response.Write("{\"status\":1, \"msg\":\"商品已成功添加到购物车!\", \"quantity\":" + car_total.total_quantity + ", \"amount\":" + car_total.real_amount + "}");            }            else             {                context.Response.Write("{\"status\":2, \"msg\":\"亲,您还没有登录呢!\", \"quantity\":" + 0 + ", \"amount\":" + 0 + "}");            }            return;        }        #endregion

}

逻辑层Bll对应的方法

/// <summary>        /// 查询购物车的商品数量、积分、金额        /// </summary>        /// <param name="user_id"></param>        /// <returns></returns>        public string get_quantity(int user_id)        {            DataTable dt = new DataTable();            dt=dal.get_quantity(user_id).Tables[0];            int quantity = 0;            int sell_price = 0;            int point = 0;            for (int i = 0; i < dt.Rows.Count; i++)  //对购物车内的商品进行数量金额积分的计算            {                if (dt.Rows[i]["quantity"] != Convert.DBNull)   //如果dt.Rows[i]["quantity"]为空的话就转换不到整形,所以这里用Convert.DBNull进行判断                {                    quantity += Convert.ToInt32(dt.Rows[i]["quantity"]);                }                if (dt.Rows[i]["sell_price"] != Convert.DBNull && dt.Rows[i]["quantity"] != Convert.DBNull)                {                    sell_price += Convert.ToInt32(dt.Rows[i]["sell_price"]) * Convert.ToInt32(dt.Rows[i]["quantity"]);                }                if (dt.Rows[i]["point"] != Convert.DBNull && dt.Rows[i]["quantity"] != Convert.DBNull)                {                    point += Convert.ToInt32(dt.Rows[i]["point"]) *Convert.ToInt32(dt.Rows[i]["quantity"]);                }            }            string str = "";            str = quantity + ";" + sell_price + ";" + point;            return str;        }        /// <summary>        /// 查询        /// </summary>        /// <param name="user_id"></param>        /// <returns></returns>        public DataSet getList(int user_id)        {            //get_quantity(user_id);            //DataTable dt = dal.getList(user_id).Tables[0];            return dal.getList(user_id);        }<pre name="code" class="csharp">/// <summary>        /// 增加一条数据        /// </summary>        public int Add(Model.shoppingcar model)        {                        return dal.Add(model);        }        /// <summary>        /// 修改一条数据        /// </summary>        /// <param name="model"></param>        /// <returns></returns>        public bool Update(Model.shoppingcar model)        {                        //int goods_quantity = Convert.ToInt32(new BLL.goods().GetQuantity(goods_id));            return dal.Update(model);        }

数据层DAL与逻辑层BLL对应的方法

/// <summary>        /// 返回购物车商品数量、价格、积分总数        /// </summary>        /// <param name="user_id">根据用户ID来查询</param>        /// <returns></returns>         public DataSet get_quantity(int user_id)         {             StringBuilder strSql = new StringBuilder();             strSql.Append("select a.quantity,b.sell_price,b.point FROM " + databaseprefix + "shoppingCar a left join dt_goods b on a.goods_id=b.id");             strSql.Append(" where user_id=" + user_id + " and youxiaofou=1");             return DbHelperSQL.Query(strSql.ToString());         }/// <summary>         /// 查询购物车        /// </summary>        /// <param name="user_id">根据当前‘用户ID’来查询该用户的购物车</param>        /// <returns></returns>         public DataSet getList(int user_id)         {             StringBuilder strSql = new StringBuilder();             strSql.Append("select a.*,b.sell_price,b.title,b.img_url,b.point FROM " + databaseprefix + "shoppingCar a left join dt_goods b on a.goods_id=b.id");             strSql.Append(" where user_id=" + user_id + " and youxiaofou=1");             strSql.Append(" order by a.id desc");                          return DbHelperSQL.Query(strSql.ToString());         } /// <summary>        /// 增加一条数据        /// </summary>         public int Add(Model.shoppingcar model)         {             StringBuilder strSql = new StringBuilder();             strSql.Append("insert into " + databaseprefix + "shoppingCar(");             strSql.Append("goods_id,user_id,quantity,color,youxiaofou)");             strSql.Append(" values (");             strSql.Append("@goods_id,@user_id,@quantity,@color,@youxiaofou)");             strSql.Append(";select @@IDENTITY");             SqlParameter[] parameter ={                                        new SqlParameter("@goods_id",SqlDbType.Int,4),                                        new SqlParameter("@user_id",SqlDbType.Int,4),                                        new SqlParameter("@quantity",SqlDbType.Int,4),                                        new SqlParameter("@color",SqlDbType.NVarChar,150),                                        new SqlParameter("@youxiaofou",SqlDbType.Bit)                                       };             parameter[0].Value = model.goods_id;             parameter[1].Value = model.user_id;             parameter[2].Value = model.quantity;             parameter[3].Value = model.color;             parameter[4].Value = model.youxiaofou;             object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameter);             if (obj == null)             {                 return 0;             }             else             {                 return Convert.ToInt32(obj);             }         }        /// <summary>        /// 修改,即更新一行数据        /// </summary>        /// <param name="id">购物车ID</param>        /// <param name="quantity">数量</param>         public bool Update(Model.shoppingcar model)         {             StringBuilder strSql = new StringBuilder();             strSql.Append("update " + databaseprefix + "shoppingCar set ");             strSql.Append("quantity=@quantity,color=@color");             strSql.Append(" where id=@id");             SqlParameter[] parameters = {new SqlParameter("@id", SqlDbType.Int,4),new SqlParameter("@quantity", SqlDbType.Int,4),                    new SqlParameter("@color", SqlDbType.NVarChar,150)                                          };             parameters[0].Value = model.id;             parameters[1].Value = model.quantity;             parameters[2].Value = model.color;             int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);             if (rows > 0)             {                 return true;             }             else             {                 return false;             }         }

实现此功能用到的Model

购物车的model:

using System;using System.Collections.Generic;using System.Text;namespace DTcms.Model{    /// <summary>    /// 购物车实体类    /// </summary>    [Serializable]    public partial class shoppingcar    {        public shoppingcar() { }        #region Model        private int _id;        private int _goods_id;        private int _user_id;        private int _quantity = 1;        private string _color;        private Boolean _youxiaofou = true;        /// <summary>        /// 购物车ID        /// </summary>        public int id        {            set { _id = value; }            get { return _id; }        }        /// <summary>        /// 商品ID        /// </summary>        public int goods_id        {            set { _goods_id = value; }            get { return _goods_id; }        }        /// <summary>        /// 用户ID        /// </summary>        public int user_id         {            set { _user_id = value; }            get { return _user_id; }        }        /// <summary>        /// 商品数量        /// </summary>        public int quantity        {            set { _quantity = value; }            get { return _quantity; }        }        public string color        {            set { _color = value; }            get { return _color; }        }        /// <summary>        /// 有效否        /// </summary>        public Boolean youxiaofou        {            set { _youxiaofou = value; }            get { return _youxiaofou; }        }        #endregion    }    /// <summary>    /// 购物车属性类    /// </summary>    [Serializable]    public partial class car_total    {        public car_total()        { }        #region Model        private int _total_num = 0;        private int _total_quantity = 0;        private decimal _payable_amount = 0M;        private decimal _real_amount = 0M;        private int _total_point = 0;        /// <summary>        /// 商品种数        /// </summary>        public int total_num        {            set { _total_num = value; }            get { return _total_num; }        }        /// <summary>        /// 商品总数量        /// </summary>        public int total_quantity        {            set { _total_quantity = value; }            get { return _total_quantity; }        }        /// <summary>        /// 应付商品总金额        /// </summary>        public decimal payable_amount        {            set { _payable_amount = value; }            get { return _payable_amount; }        }        /// <summary>        /// 实付商品总金额        /// </summary>        public decimal real_amount        {            set { _real_amount = value; }            get { return _real_amount; }        }        /// <summary>        /// 总积分        /// </summary>        public int total_point        {            set { _total_point = value; }            get { return _total_point; }        }        #endregion    }}

用户的model层:

using System;namespace DTcms.Model{    #region 用户信息实体类    /// <summary>    /// users实体类    /// </summary>    [Serializable]    public partial class users    {        public users() { }        private int _id;        private int _group_id = 0;        private string _user_name;        private string _password;        private string _salt;        private string _email = "";        private string _nick_name = "";        private string _avatar = "";        private string _sex = "保密";        private DateTime? _birthday;        private string _telphone = "";        private string _mobile = "";        private string _qq = "";        private string _address = "";        private string _safe_question = "";        private string _safe_answer = "";        private decimal _amount = 0M;        private int _point = 0;        private int _exp = 0;        private int _status = 0;        private DateTime _reg_time = DateTime.Now;        private string _reg_ip;        private string _longitude ;//经度        private string _latitude;//维度        private string _city ;//城市限定        private string _content;//内容        private string _license_img;//执照        private string _place_img;//产地        private string _shenfenzheng = "";        /// <summary>        /// 自增ID        /// </summary>        public int id        {            set { _id = value; }            get { return _id; }        }        /// <summary>        /// 用户组别        /// </summary>        public int group_id        {            set { _group_id = value; }            get { return _group_id; }        }        /// <summary>        /// 用户名        /// </summary>        public string user_name        {            set { _user_name = value; }            get { return _user_name; }        }        /// <summary>        /// 用户密码        /// </summary>        public string password        {            set { _password = value; }            get { return _password; }        }        /// <summary>        /// 用户注册密钥Key        /// </summary>        public string salt        {            set { _salt = value; }            get { return _salt; }        }        /// <summary>        /// 电子邮箱        /// </summary>        public string email        {            set { _email = value; }            get { return _email; }        }        /// <summary>        /// 用户昵称        /// </summary>        public string nick_name        {            set { _nick_name = value; }            get { return _nick_name; }        }        /// <summary>        /// 用户头像        /// </summary>        public string avatar        {            set { _avatar = value; }            get { return _avatar; }        }        /// <summary>        /// 用户性别        /// </summary>        public string sex        {            set { _sex = value; }            get { return _sex; }        }        /// <summary>        /// 生日        /// </summary>        public DateTime? birthday        {            set { _birthday = value; }            get { return _birthday; }        }        /// <summary>        /// 联系电话        /// </summary>        public string telphone        {            set { _telphone = value; }            get { return _telphone; }        }        /// <summary>        /// 手机号码        /// </summary>        public string mobile        {            set { _mobile = value; }            get { return _mobile; }        }        /// <summary>        /// QQ号码        /// </summary>        public string qq        {            set { _qq = value; }            get { return _qq; }        }        /// <summary>        /// 联系地址        /// </summary>        public string address        {            set { _address = value; }            get { return _address; }        }        /// <summary>        /// 安全问题        /// </summary>        public string safe_question        {            set { _safe_question = value; }            get { return _safe_question; }        }        /// <summary>        /// 问题答案        /// </summary>        public string safe_answer        {            set { _safe_answer = value; }            get { return _safe_answer; }        }        /// <summary>        /// 预存款        /// </summary>        public decimal amount        {            set { _amount = value; }            get { return _amount; }        }        /// <summary>        /// 用户积分        /// </summary>        public int point        {            set { _point = value; }            get { return _point; }        }        /// <summary>        /// 经验值        /// </summary>        public int exp        {            set { _exp = value; }            get { return _exp; }        }        /// <summary>        /// 用户状态,0正常,1待验证,2待审核,3锁定        /// </summary>        public int status        {            set { _status = value; }            get { return _status; }        }        /// <summary>        /// 注册时间        /// </summary>        public DateTime reg_time        {            set { _reg_time = value; }            get { return _reg_time; }        }        /// <summary>        /// 注册IP        /// </summary>        public string reg_ip        {            set { _reg_ip = value; }            get { return _reg_ip; }        }        /// <summary>        /// 经度        /// </summary>        public string longitude        {            set { _longitude = value; }            get { return _longitude; }        }        /// <summary>        /// 维度        /// </summary>        public string latitude        {            set { _latitude = value; }            get { return _latitude; }        }        /// <summary>        /// 城市限定        /// </summary>        public string city        {            set { _city = value; }            get { return _city; }        }        /// <summary>        /// 公司介绍        /// </summary>        public string content        {            set { _content = value; }            get { return _content; }        }        /// <summary>        /// 执照照片        /// </summary>        public string license_img        {            set { _license_img = value; }            get { return _license_img; }        }        /// <summary>        /// 场地照片        /// </summary>        public string place_img        {            set { _place_img = value; }            get { return _place_img; }        }        public string shenfenzheng         {            set { _shenfenzheng = value; }            get { return _shenfenzheng; }        }    }    #endregion Model}

仅供学习,禁止商业用途







0 0
原创粉丝点击