/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_sysuser model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_sysuser set "); if (!String.IsNullOrEmpty(model.username)) { setSql.Append("username=@username,"); } if (!String.IsNullOrEmpty(model.password)) { setSql.Append("password=@password,"); } 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 List <tb_calllog> GetList(tb_calllog model, ref int total) { List <tb_calllog> 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_calllog "); if (!String.IsNullOrEmpty(model.phone)) { whereSql.Append(" and phone=@phone"); } if (!String.IsNullOrEmpty(model.calltype)) { whereSql.Append(" and calltype=@calltype"); } if (model.addtime != null) { whereSql.Append(" and addtime=@addtime"); } 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_calllog>(pageSqlStr, model)?.ToList(); total = conn.ExecuteScalar <int>(CountSql, model); } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_calllog model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_calllog set "); if (!String.IsNullOrEmpty(model.phone)) { setSql.Append("phone=@phone,"); } if (!String.IsNullOrEmpty(model.calltype)) { setSql.Append("calltype=@calltype,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 Update(tb_document model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_document set "); if (!String.IsNullOrEmpty(model.title)) { setSql.Append("title=@title,"); } if (!String.IsNullOrEmpty(model.content)) { setSql.Append("content=@content,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <returns></returns> public List <T> GetList <T>(string sql) { List <T> list = null; using (IDbConnection conn = DapperHelper.OpenConnection(DB.CMS_Catering)) { list = conn.Query <T>(sql)?.ToList(); } return(list); }
/// <summary> /// 得到一个对象实体 /// </summary> public tb_roomface GetInfo(tb_roomface model) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from tb_roomface"); strSql.Append(" where id=@id "); using (IDbConnection conn = DapperHelper.OpenConnection()) { model = conn.Query <tb_roomface>(strSql.ToString(), model)?.FirstOrDefault(); } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_roomlease model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_roomlease set "); if (!String.IsNullOrEmpty(model.roomid)) { setSql.Append("roomid=@roomid,"); } if (!String.IsNullOrEmpty(model.company)) { setSql.Append("company=@company,"); } if (!String.IsNullOrEmpty(model.time)) { setSql.Append("time=@time,"); } if (!String.IsNullOrEmpty(model.linkman)) { setSql.Append("linkman=@linkman,"); } if (!String.IsNullOrEmpty(model.phone)) { setSql.Append("phone=@phone,"); } if (!String.IsNullOrEmpty(model.emergencylinkman)) { setSql.Append("emergencylinkman=@emergencylinkman,"); } if (!String.IsNullOrEmpty(model.emergencyphone)) { setSql.Append("emergencyphone=@emergencyphone,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 Update(tb_feature model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_feature set "); if (!String.IsNullOrEmpty(model.img)) { setSql.Append("img=@img,"); } if (!String.IsNullOrEmpty(model.type)) { setSql.Append("type=@type,"); } if (!String.IsNullOrEmpty(model.code)) { setSql.Append("code=@code,"); } if (!String.IsNullOrEmpty(model.version)) { setSql.Append("version=@version,"); } if (!String.IsNullOrEmpty(model.remark)) { setSql.Append("remark=@remark,"); } if (model.isdel) { setSql.Append("isdel=@isdel,"); } if (model.sortnum != null) { setSql.Append("sortnum=@sortnum,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 Update(tb_restaurant model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_restaurant set "); if (!String.IsNullOrEmpty(model.buildingid)) { setSql.Append("buildingid=@buildingid,"); } if (!String.IsNullOrEmpty(model.name)) { setSql.Append("name=@name,"); } if (!String.IsNullOrEmpty(model.address)) { setSql.Append("address=@address,"); } if (!String.IsNullOrEmpty(model.hold)) { setSql.Append("hold=@hold,"); } if (!String.IsNullOrEmpty(model.phone)) { setSql.Append("phone=@phone,"); } if (!String.IsNullOrEmpty(model.dinnertime)) { setSql.Append("dinnertime=@dinnertime,"); } if (model.isopen != null) { setSql.Append("isopen=@isopen,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 List <tb_feature> GetList(tb_feature model, ref int total) { List <tb_feature> 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_feature "); if (!String.IsNullOrEmpty(model.img)) { whereSql.Append(" and img=@img"); } if (!String.IsNullOrEmpty(model.type)) { whereSql.Append(" and type=@type"); } if (!String.IsNullOrEmpty(model.code)) { whereSql.Append(" and code=@code"); } if (!String.IsNullOrEmpty(model.version)) { whereSql.Append(" and version=@version"); } if (!String.IsNullOrEmpty(model.remark)) { whereSql.Append(" and remark=@remark"); } if (model.isdel) { whereSql.Append(" and isdel=@isdel"); } if (model.sortnum != null) { whereSql.Append(" and sortnum=@sortnum"); } if (model.addtime != null) { whereSql.Append(" and addtime=@addtime"); } 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_feature>(pageSqlStr, model)?.ToList(); total = conn.ExecuteScalar <int>(CountSql, model); } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_file model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_file set "); if (model.typeid != null) { setSql.Append("typeid=@typeid,"); } if (model.filetypeid != null) { setSql.Append("filetypeid=@filetypeid,"); } if (!String.IsNullOrEmpty(model.infoid)) { setSql.Append("infoid=@infoid,"); } if (!String.IsNullOrEmpty(model.name)) { setSql.Append("name=@name,"); } if (!String.IsNullOrEmpty(model.intro)) { setSql.Append("intro=@intro,"); } if (!String.IsNullOrEmpty(model.address)) { setSql.Append("address=@address,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 Update(tb_park model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_park set "); if (model.buildingid != null) { setSql.Append("buildingid=@buildingid,"); } if (!String.IsNullOrEmpty(model.parkname)) { setSql.Append("parkname=@parkname,"); } if (!String.IsNullOrEmpty(model.address)) { setSql.Append("address=@address,"); } if (model.parknumber != null) { setSql.Append("parknumber=@parknumber,"); } if (!String.IsNullOrEmpty(model.fee)) { setSql.Append("fee=@fee,"); } if (model.isopen != null) { setSql.Append("isopen=@isopen,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 List <tb_park> GetList(tb_park model, ref int total) { List <tb_park> 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_park "); if (model.buildingid != null) { whereSql.Append(" and buildingid=@buildingid"); } if (!String.IsNullOrEmpty(model.parkname)) { whereSql.Append(" and parkname=@parkname"); } if (!String.IsNullOrEmpty(model.address)) { whereSql.Append(" and address=@address"); } if (model.parknumber != null) { whereSql.Append(" and parknumber=@parknumber"); } if (!String.IsNullOrEmpty(model.fee)) { whereSql.Append(" and fee=@fee"); } if (model.isopen != null) { whereSql.Append(" and isopen=@isopen"); } if (model.addtime != null) { whereSql.Append(" and addtime=@addtime"); } 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_park>(pageSqlStr, model)?.ToList(); total = conn.ExecuteScalar <int>(CountSql, model); } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_favorite model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_favorite set "); if (!String.IsNullOrEmpty(model.favoritetype)) { setSql.Append("favoritetype=@favoritetype,"); } if (!String.IsNullOrEmpty(model.favoriteid)) { setSql.Append("favoriteid=@favoriteid,"); } if (model.favoritedate != null) { setSql.Append("favoritedate=@favoritedate,"); } if (model.isdel) { setSql.Append("isdel=@isdel,"); } if (!String.IsNullOrEmpty(model.favoriteintro)) { setSql.Append("favoriteintro=@favoriteintro,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 DeleteList(string idlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from tb_roomface "); strSql.Append(" where id in (" + idlist + ") "); using (IDbConnection conn = DapperHelper.OpenConnection()) { int count = conn.Execute(strSql.ToString()); if (count > 0) { return(true); } else { return(false); } } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(tb_qqlicense model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from tb_qqlicense "); strSql.Append(" where "); using (IDbConnection conn = DapperHelper.OpenConnection()) { int count = conn.Execute(strSql.ToString(), model); if (count > 0) { return(true); } else { return(false); } } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(tb_restaurantenvironment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from tb_restaurantenvironment "); 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> /// 是否存在该记录 /// </summary> public bool Exists(tb_roomface model) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from tb_roomface"); 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 List <tb_role_module> GetList(tb_role_module model, ref int total) { List <tb_role_module> list; StringBuilder strSql = new StringBuilder(); StringBuilder whereSql = new StringBuilder(" where 1 = 1 "); strSql.Append(" select ROW_NUMBER() OVER(ORDER BY roleid desc) AS RID, * from tb_role_module "); 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_role_module>(pageSqlStr, model)?.ToList(); total = conn.ExecuteScalar <int>(CountSql, model); } return(list); }
/// <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 Update(tb_operationlog model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_operationlog set "); if (!String.IsNullOrEmpty(model.username)) { setSql.Append("username=@username,"); } if (!String.IsNullOrEmpty(model.ip)) { setSql.Append("ip=@ip,"); } if (!String.IsNullOrEmpty(model.target)) { setSql.Append("target=@target,"); } if (!String.IsNullOrEmpty(model.action)) { setSql.Append("action=@action,"); } if (model.addtime != null) { setSql.Append("addtime=@addtime,"); } 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 Update(tb_pcctv model) { StringBuilder strSql = new StringBuilder(); StringBuilder setSql = new StringBuilder(); strSql.Append("update tb_pcctv set "); if (!String.IsNullOrEmpty(model.pid)) { setSql.Append("pid=@pid,"); } if (model.pcctvlevel != null) { setSql.Append("pcctvlevel=@pcctvlevel,"); } if (!String.IsNullOrEmpty(model.pcctvname)) { setSql.Append("pcctvname=@pcctvname,"); } if (!String.IsNullOrEmpty(model.classification)) { setSql.Append("classification=@classification,"); } if (!String.IsNullOrEmpty(model.remark)) { setSql.Append("remark=@remark,"); } 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_meetingroom model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_meetingroom("); strSql.Append("id,buildingid,intro,phone,floor,roomnumber,desktype,hold,fee,isopen,roomtype,package,addtime)"); strSql.Append(" values ("); strSql.Append("@id,@buildingid,@intro,@phone,@floor,@roomnumber,@desktype,@hold,@fee,@isopen,@roomtype,@package,@addtime)"); 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_qqlicense model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_qqlicense("); strSql.Append("id,openid,addtime,subscribe,nickname,sex,city,country,province,language,headimgurl,subscribe_time,unionid,code,userType,userid)"); strSql.Append(" values ("); strSql.Append("@id,@openid,@addtime,@subscribe,@nickname,@sex,@city,@country,@province,@language,@headimgurl,@subscribe_time,@unionid,@code,@userType,@userid)"); 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_calllog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_calllog("); strSql.Append("phone,calltype,addtime,id)"); strSql.Append(" values ("); strSql.Append("@phone,@calltype,@addtime,@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_operationlog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_operationlog("); strSql.Append("id,username,ip,target,action,addtime)"); strSql.Append(" values ("); strSql.Append("@id,@username,@ip,@target,@action,@addtime)"); 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_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_user("); strSql.Append("id,code,nickname,phonenum,address,longitude,latitude,remark,createdate,updatedate,pwd,province,city,county,location,sex,job,age,constellation,hav,tall,schedule,sgin,hobby,birth,wx,issingle,company,companyaddress,realname,avatar,isdel,addtime)"); strSql.Append(" values ("); strSql.Append("@id,@code,@nickname,@phonenum,@address,@longitude,@latitude,@remark,@createdate,@updatedate,@pwd,@province,@city,@county,@location,@sex,@job,@age,@constellation,@hav,@tall,@schedule,@sgin,@hobby,@birth,@wx,@issingle,@company,@companyaddress,@realname,@avatar,@isdel,@addtime)"); 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_sysuser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_sysuser("); strSql.Append("id,username,password)"); strSql.Append(" values ("); strSql.Append("@id,@username,@password)"); 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_roomface model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_roomface("); strSql.Append("id,roomid,name,intro,pic,addtime)"); strSql.Append(" values ("); strSql.Append("@id,@roomid,@name,@intro,@pic,@addtime)"); 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_park model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_park("); strSql.Append("id,buildingid,parkname,address,parknumber,fee,isopen,addtime)"); strSql.Append(" values ("); strSql.Append("@id,@buildingid,@parkname,@address,@parknumber,@fee,@isopen,@addtime)"); using (IDbConnection conn = DapperHelper.OpenConnection()) { int count = conn.Execute(strSql.ToString(), model); if (count > 0) { return(true); } else { return(false); } } }