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