private static void SetTaxis(int siteId, int formId, int taxis) { var sqlString = $"UPDATE {TableName} SET {nameof(FormInfo.Taxis)} = {taxis} WHERE {nameof(FormInfo.Id)} = {formId}"; Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString); FormManager.ClearCache(siteId); }
public void Delete(int siteId, int formId) { if (formId <= 0) { return; } _repository.Delete(formId); FieldManager.Repository.DeleteByFormId(formId); LogManager.Repository.DeleteByFormId(formId); FormManager.ClearCache(siteId); }
public static void Delete(int siteId, int formId) { if (formId <= 0) { return; } var sqlString = $"DELETE FROM {TableName} WHERE {nameof(FormInfo.Id)} = {formId}"; Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString); FieldDao.DeleteByFormId(formId); LogDao.DeleteByFormId(formId); FormManager.ClearCache(siteId); }
public int Insert(FormInfo formInfo) { if (formInfo.SiteId == 0) { return(0); } if (formInfo.ChannelId == 0 && formInfo.ContentId == 0 && string.IsNullOrEmpty(formInfo.Title)) { return(0); } if (formInfo.ContentId == 0) { formInfo.Taxis = GetMaxTaxis(formInfo.SiteId) + 1; } formInfo.Id = _repository.Insert(formInfo); FormManager.ClearCache(formInfo.SiteId); return(formInfo.Id); }
public static int Insert(FormInfo formInfo) { if (formInfo.SiteId == 0) { return(0); } if (formInfo.ChannelId == 0 && formInfo.ContentId == 0 && string.IsNullOrEmpty(formInfo.Title)) { return(0); } int formId; if (formInfo.ContentId == 0) { formInfo.Taxis = GetMaxTaxis(formInfo.SiteId) + 1; } var sqlString = $@"INSERT INTO {TableName} ({nameof(FormInfo.SiteId)}, {nameof(FormInfo.ChannelId)}, {nameof(FormInfo.ContentId)}, {nameof(FormInfo.Title)}, {nameof(FormInfo.Description)}, {nameof(FormInfo.Taxis)}, {nameof(FormInfo.IsReply)}, {nameof(FormInfo.RepliedCount)}, {nameof(FormInfo.TotalCount)}, {nameof(FormInfo.AddDate)}, {nameof(FormInfo.Settings)}) VALUES (@{nameof(FormInfo.SiteId)}, @{nameof(FormInfo.ChannelId)}, @{nameof(FormInfo.ContentId)}, @{nameof(FormInfo.Title)}, @{nameof(FormInfo.Description)}, @{nameof(FormInfo.Taxis)}, @{nameof(FormInfo.IsReply)}, @{nameof(FormInfo.RepliedCount)}, @{nameof(FormInfo.TotalCount)}, @{nameof(FormInfo.AddDate)}, @{nameof(FormInfo.Settings)})"; var parameters = new List <IDataParameter> { Context.DatabaseApi.GetParameter(nameof(formInfo.SiteId), formInfo.SiteId), Context.DatabaseApi.GetParameter(nameof(formInfo.ChannelId), formInfo.ChannelId), Context.DatabaseApi.GetParameter(nameof(formInfo.ContentId), formInfo.ContentId), Context.DatabaseApi.GetParameter(nameof(formInfo.Title), formInfo.Title), Context.DatabaseApi.GetParameter(nameof(formInfo.Description), formInfo.Description), Context.DatabaseApi.GetParameter(nameof(formInfo.Taxis), formInfo.Taxis), Context.DatabaseApi.GetParameter(nameof(formInfo.IsReply), formInfo.IsReply), Context.DatabaseApi.GetParameter(nameof(formInfo.RepliedCount), formInfo.RepliedCount), Context.DatabaseApi.GetParameter(nameof(formInfo.TotalCount), formInfo.TotalCount), Context.DatabaseApi.GetParameter(nameof(formInfo.AddDate), formInfo.AddDate), Context.DatabaseApi.GetParameter(nameof(formInfo.Settings), formInfo.Settings) }; using (var conn = Context.DatabaseApi.GetConnection(Context.ConnectionString)) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { formId = Context.DatabaseApi.ExecuteNonQueryAndReturnId(TableName, nameof(FormInfo.Id), trans, sqlString, parameters.ToArray()); trans.Commit(); } catch { trans.Rollback(); throw; } } } FormManager.ClearCache(formInfo.SiteId); return(formId); }
private void SetTaxis(int siteId, int formId, int taxis) { _repository.Update(Q.Set(Attr.Taxis, taxis).Where(Attr.Id, formId)); FormManager.ClearCache(siteId); }