/// <summary>
/// 根据条件语句取得第一个实体
/// </summary>
/// <param name="m_where">条件语句，不包含“where”</param>
/// <returns></returns>
public static TemplateSearch Find(string m_where)
{
IDbHelper Sql = GetHelper();
TemplateSearch M = new TemplateSearch();
DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[GroupID],[TempName],[SysModel],[CutKeywords],[CutTitle],[ShowRecordCount],[TimeFormat],[Content],[ListVar] from [TemplateSearch] where " + m_where, true);
if (!Rs.Read())
{
M.ID = 0;
}
else
{
M.ID = Rs["ID"].ToInt32();
M.GroupID = Rs["GroupID"].ToInt32();
M.TempName = Rs["TempName"].ToString();
M.SysModel = Rs["SysModel"].ToInt32();
M.CutKeywords = Rs["CutKeywords"].ToInt32();
M.CutTitle = Rs["CutTitle"].ToInt32();
M.ShowRecordCount = Rs["ShowRecordCount"].ToInt32();
M.TimeFormat = Rs["TimeFormat"].ToString();
M.Content = Rs["Content"].ToString();
M.ListVar = Rs["ListVar"].ToString();
}
Rs.Close();
Rs = null;
return(M);
}
public async Task <TemplateSummary[]> List(TemplateSearch search, bool sudo, CancellationToken ct = default(CancellationToken))
{
var q = _store.List(search.Term)
.Include(t => t.Workspace) as IQueryable <Data.Template>;
if (sudo && search.pid.NotEmpty())
{
q = q.Where(t => t.ParentId == search.pid);
}
if (!sudo || search.WantsPublished)
{
q = q.Where(t => t.IsPublished && t.Audience == null);
}
q = q.OrderBy(t => t.Name);
if (search.Skip > 0)
{
q = q.Skip(search.Skip);
}
if (search.Take > 0)
{
q = q.Take(search.Take);
}
return(Mapper.Map <TemplateSummary[]>(
await q.ToArrayAsync(ct)
));
}
public async Task <ActionResult <TemplateSummary[]> > ListTemplates([FromQuery] TemplateSearch search, CancellationToken ct)
{
await Validate(search);
AuthorizeAll();
var result = await _svc.List(search, Actor.IsAdmin, ct);
return(Ok(result));
}
public IHttpActionResult GetList(TemplateSearch search)
{
AuthDetails authdet = LoginUserDetails();
var filters = new List <MySqlParameter>
{
datatableService.CreateSqlParameter("@pUserId", authdet.UserId, MySqlDbType.Int32)
};
var result = service.GetList(search, filters);
return(Ok(result));
}
/// <summary>
/// 将修改过的实体修改到数据库
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static int Update(TemplateSearch M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("update [TemplateSearch] set ");
sb.Append("[GroupID]=" + M.GroupID.ToS());
sb.Append(",");
sb.Append("[TempName]=N'" + M.TempName + "'");
sb.Append(",");
sb.Append("[SysModel]=" + M.SysModel.ToS());
sb.Append(",");
sb.Append("[CutKeywords]=" + M.CutKeywords.ToS());
sb.Append(",");
sb.Append("[CutTitle]=" + M.CutTitle.ToS());
sb.Append(",");
sb.Append("[ShowRecordCount]=" + M.ShowRecordCount.ToS());
sb.Append(",");
sb.Append("[TimeFormat]=N'" + M.TimeFormat + "'");
sb.Append(",");
sb.Append("[Content]=N'" + M.Content + "'");
sb.Append(",");
sb.Append("[ListVar]=N'" + M.ListVar + "'");
sb.Append(" where ID='" + M.ID + "'");
sb.Append("");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@ROWCOUNT");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";SELECT ROW_COUNT()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select SQL%ROWCOUNT");
}
return(Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32());
}
/// <summary>
/// 将数据插入表
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static void Insert(TemplateSearch M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [TemplateSearch]([GroupID],[TempName],[SysModel],[CutKeywords],[CutTitle],[ShowRecordCount],[TimeFormat],[Content],[ListVar]) values(");
sb.Append(M.GroupID.ToS());
sb.Append(",");
sb.Append("N'" + M.TempName + "'");
sb.Append(",");
sb.Append(M.SysModel.ToS());
sb.Append(",");
sb.Append(M.CutKeywords.ToS());
sb.Append(",");
sb.Append(M.CutTitle.ToS());
sb.Append(",");
sb.Append(M.ShowRecordCount.ToS());
sb.Append(",");
sb.Append("N'" + M.TimeFormat + "'");
sb.Append(",");
sb.Append("N'" + M.Content + "'");
sb.Append(",");
sb.Append("N'" + M.ListVar + "'");
sb.Append(")");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@Identity");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select last_insert_rowid()");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";select LAST_INSERT_ID()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select max(ID) from TemplateSearch");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select LAST_INSERT_ID()");
}
M.ID = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32();
}
public DataTable <TemplateDatatable> GetList(TemplateSearch search, List <MySqlParameter> filters)
{
try
{
using (var ctx = new AppDb())
{
var result = datatableService.GetDataTableResult <TemplateDatatable>("template_list_sp", search, filters);
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// DataTable转换为list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected static List <TemplateSearch> DataTableToList(DataTable dt)
{
List <TemplateSearch> Ms = new List <TemplateSearch>();
for (int i = 0; i < dt.Rows.Count; i++)
{
TemplateSearch M = new TemplateSearch();
M.ID = dt.Rows[i]["ID"].ToInt32();
M.GroupID = dt.Rows[i]["GroupID"].ToInt32();
M.TempName = dt.Rows[i]["TempName"].ToString();
M.SysModel = dt.Rows[i]["SysModel"].ToInt32();
M.CutKeywords = dt.Rows[i]["CutKeywords"].ToInt32();
M.CutTitle = dt.Rows[i]["CutTitle"].ToInt32();
M.ShowRecordCount = dt.Rows[i]["ShowRecordCount"].ToInt32();
M.TimeFormat = dt.Rows[i]["TimeFormat"].ToString();
M.Content = dt.Rows[i]["Content"].ToString();
M.ListVar = dt.Rows[i]["ListVar"].ToString();
Ms.Add(M);
}
return(Ms);
}
private async Task _validate(TemplateSearch model)
{
await Task.CompletedTask;
}
public static TemplateSearch CreateTemplateSearch(int id)
{
TemplateSearch templateSearch = new TemplateSearch();
templateSearch.ID = id;
return templateSearch;
}
public void AddToTemplateSearch(TemplateSearch templateSearch)
{
base.AddObject("TemplateSearch", templateSearch);
}
