/// <summary> /// 更新数据 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> public async System.Threading.Tasks.Task <bool> Update(CL_Comm entity) { string sql = $"update {ReName($"{Prefix}Comm")} set {ReName("ContentId")}=@ContentId,{ReName("Content")}=@Content,{ReName("Recycle")}=@Recycle,{ReName("Updated")}=@Updated where {ReName("CommID")}=@CommID"; List <DbParameter> parlist = new List <DbParameter>(); parlist.Add(CreateParam("@CommID", entity.CommID)); parlist.Add(CreateParam("@ContentId", entity.ContentId)); parlist.Add(CreateParam("@Content", entity.Content)); parlist.Add(CreateParam("@Recycle", entity.Recycle)); parlist.Add(CreateParam("@Updated", entity.Updated)); return(await ExecuteNonQueryMem(sql, parlist.ToArray())); }
/// <summary> /// 插入数据 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> public async System.Threading.Tasks.Task <bool> Insert(CL_Comm entity) { string sql = $"insert into {ReName($"{Prefix}Comm")}({ReName("CommID")},{ReName("ContentId")},{ReName("Content")},{ReName("Recycle")},{ReName("Updated")},{ReName("CreateUid")},{ReName("CreateIP")},{ReName("CreateDate")})values(@CommID,@ContentId,@Content,@Recycle,@Updated,@CreateUid,@CreateIP,@CreateDate)"; List <DbParameter> parlist = new List <DbParameter>(); parlist.Add(CreateParam("@CommID", entity.CommID)); parlist.Add(CreateParam("@ContentId", entity.ContentId)); parlist.Add(CreateParam("@Content", entity.Content)); parlist.Add(CreateParam("@Recycle", entity.Recycle)); parlist.Add(CreateParam("@Updated", entity.Updated)); parlist.Add(CreateParam("@CreateUid", entity.CreateUid)); parlist.Add(CreateParam("@CreateIP", entity.CreateIP)); parlist.Add(CreateParam("@CreateDate", entity.CreateDate)); if (await ExecuteNonQueryMem(sql, parlist.ToArray())) { return(true); } return(false); }