Exemple #1
0
        /// <summary>
        /// 基础数据 列表
        /// </summary>
        public ActionResult baseList(tb_base model)
        {
            int count = 0;

            ViewBag.baseList = dbase.GetList(model, ref count);
            ViewBag.page     = Utils.ShowPage(count, model.PageSize, model.PageIndex, 5);
            return(View());
        }
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public tb_base GetInfo(tb_base model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * from tb_base");
            strSql.Append("  where id=@id ");
            using (IDbConnection conn = DapperHelper.OpenConnection())
            {
                model = conn.Query <tb_base>(strSql.ToString(), model)?.FirstOrDefault();
            }
            return(model);
        }
Exemple #3
0
 /// <summary>
 /// 基础数据 保存
 /// </summary>
 public JsonResult baseSave(tb_base model)
 {
     if (model == null)
     {
         return(ResultTool.jsonResult(false, "参数错误!"));
     }
     if (!String.IsNullOrEmpty(model.id))
     {
         bool boolResult = dbase.Update(model);
         return(ResultTool.jsonResult(boolResult, boolResult ? "成功!" : "更新失败!"));
     }
     else
     {
         model.id = Guid.NewGuid().ToString("N");
         bool boolResult = dbase.Add(model);
         return(ResultTool.jsonResult(boolResult, boolResult ? "成功!" : "添加失败!"));
     }
 }
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(tb_base model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from tb_base");
            strSql.Append("  where id=@id ");
            using (IDbConnection conn = DapperHelper.OpenConnection())
            {
                int count = conn.Execute(strSql.ToString(), model);
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(tb_base model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder setSql = new StringBuilder();

            strSql.Append("update tb_base set ");
            if (model.parentid != null)
            {
                setSql.Append("parentid=@parentid,");
            }
            if (!String.IsNullOrEmpty(model.name))
            {
                setSql.Append("name=@name,");
            }
            if (!String.IsNullOrEmpty(model.code))
            {
                setSql.Append("code=@code,");
            }
            if (!String.IsNullOrEmpty(model.remark))
            {
                setSql.Append("remark=@remark,");
            }
            if (model.sortnum != null)
            {
                setSql.Append("sortnum=@sortnum,");
            }
            strSql.Append(setSql.ToString().TrimEnd(','));
            strSql.Append(" where id=@id ");
            using (IDbConnection conn = DapperHelper.OpenConnection())
            {
                int count = conn.Execute(strSql.ToString(), model);
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(tb_base model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into tb_base(");
            strSql.Append("parentid,name,code,remark,id,sortnum)");
            strSql.Append(" values (");
            strSql.Append("@parentid,@name,@code,@remark,@id,@sortnum)");
            using (IDbConnection conn = DapperHelper.OpenConnection())
            {
                int count = conn.Execute(strSql.ToString(), model);
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <tb_base> GetList(tb_base model, ref int total)
        {
            List <tb_base> list;
            StringBuilder  strSql   = new StringBuilder();
            StringBuilder  whereSql = new StringBuilder(" where 1 = 1 ");

            strSql.Append(" select  ROW_NUMBER() OVER(ORDER BY id desc) AS RID, * from tb_base ");
            if (model.parentid != null)
            {
                whereSql.Append(" and parentid=@parentid");
            }
            if (!String.IsNullOrEmpty(model.name))
            {
                whereSql.Append(" and name=@name");
            }
            if (!String.IsNullOrEmpty(model.code))
            {
                whereSql.Append(" and code=@code");
            }
            if (!String.IsNullOrEmpty(model.remark))
            {
                whereSql.Append(" and remark=@remark");
            }
            if (model.sortnum != null)
            {
                whereSql.Append(" and sortnum=@sortnum");
            }
            strSql.Append(whereSql);
            string CountSql   = "SELECT COUNT(1) as RowsCount FROM (" + strSql.ToString() + ") AS CountList";
            string pageSqlStr = "select * from ( " + strSql.ToString() + " ) as Temp_PageData where Temp_PageData.RID BETWEEN {0} AND {1}";

            pageSqlStr = string.Format(pageSqlStr, (model.PageSize * (model.PageIndex - 1) + 1).ToString(), (model.PageSize * model.PageIndex).ToString());
            using (IDbConnection conn = DapperHelper.OpenConnection())
            {
                list  = conn.Query <tb_base>(pageSqlStr, model)?.ToList();
                total = conn.ExecuteScalar <int>(CountSql, model);
            }
            return(list);
        }
Exemple #8
0
 /// <summary>
 /// 基础数据 详情
 /// </summary>
 public ActionResult baseInfo(tb_base model)
 {
     model = dbase.GetInfo(model);
     return(View(model ?? new tb_base()));
 }
Exemple #9
0
        /// <summary>
        /// 基础数据 删除
        /// </summary>
        public JsonResult baseDelete(tb_base model)
        {
            bool boolResult = dbase.Delete(model);

            return(ResultTool.jsonResult(boolResult, boolResult ? "成功!" : "删除失败!"));
        }