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