Example #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <Model.tb_user> DataTableToList(DataTable dt)
        {
            List <Model.tb_user> modelList = new List <Model.tb_user>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                Model.tb_user model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new Model.tb_user();
                    if (dt.Rows[n]["u_id"] != null && dt.Rows[n]["u_id"].ToString() != "")
                    {
                        model.u_id = int.Parse(dt.Rows[n]["u_id"].ToString());
                    }
                    if (dt.Rows[n]["u_log"] != null && dt.Rows[n]["u_log"].ToString() != "")
                    {
                        model.u_log = dt.Rows[n]["u_log"].ToString();
                    }
                    if (dt.Rows[n]["u_pwd"] != null && dt.Rows[n]["u_pwd"].ToString() != "")
                    {
                        model.u_pwd = dt.Rows[n]["u_pwd"].ToString();
                    }
                    if (dt.Rows[n]["u_no"] != null && dt.Rows[n]["u_no"].ToString() != "")
                    {
                        model.u_no = dt.Rows[n]["u_no"].ToString();
                    }
                    if (dt.Rows[n]["u_name"] != null && dt.Rows[n]["u_name"].ToString() != "")
                    {
                        model.u_name = dt.Rows[n]["u_name"].ToString();
                    }
                    if (dt.Rows[n]["u_tel"] != null && dt.Rows[n]["u_tel"].ToString() != "")
                    {
                        model.u_tel = dt.Rows[n]["u_tel"].ToString();
                    }
                    if (dt.Rows[n]["u_email"] != null && dt.Rows[n]["u_email"].ToString() != "")
                    {
                        model.u_email = dt.Rows[n]["u_email"].ToString();
                    }
                    if (dt.Rows[n]["u_type"] != null && dt.Rows[n]["u_type"].ToString() != "")
                    {
                        model.u_type = int.Parse(dt.Rows[n]["u_type"].ToString());
                    }
                    if (dt.Rows[n]["u_sex"] != null && dt.Rows[n]["u_sex"].ToString() != "")
                    {
                        model.u_sex = dt.Rows[n]["u_sex"].ToString();
                    }
                    if (dt.Rows[n]["u_address"] != null && dt.Rows[n]["u_address"].ToString() != "")
                    {
                        model.u_address = dt.Rows[n]["u_address"].ToString();
                    }
                    if (dt.Rows[n]["u_adddate"] != null && dt.Rows[n]["u_adddate"].ToString() != "")
                    {
                        model.u_adddate = dt.Rows[n]["u_adddate"].ToString();
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
Example #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Model.tb_user model)
 {
     return(dal.Update(model));
 }
Example #3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(Model.tb_user model)
 {
     return(dal.Add(model));
 }