/// <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);
}
}
}