public InvokeResult NullifySelected(string strColumnIds) { InvokeResult result = new InvokeResult { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); string[] arrColumnIds = strColumnIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (arrColumnIds.Length == 0) { result.Success = false; result.ErrorCode = 59996; return(result); } string statementName = new ArticleColumn().GetUpdateMethodName(); foreach (string strColumnId in arrColumnIds) { ArticleColumn articleColumn = new ArticleColumn { ColumnId = strColumnId.ToGuid(), Status = 0 }; /***********************begin 自定义代码*******************/ articleColumn.OperatedBy = NormalSession.UserId.ToGuid(); articleColumn.OperatedOn = DateTime.Now; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = statementName, ParameterObject = articleColumn.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE }); } BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <ColumnWithArticle> HomePicArticles(ArticleColumn param) { CollectionInvokeResult <ColumnWithArticle> result = new CollectionInvokeResult <ColumnWithArticle> { Success = true }; int rownum = 4; try { IList <ColumnWithArticle> list_columnWithArticle = null; IList <ArticleColumn> columns = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <ArticleColumn>(param.ToStringObjectDictionary(false)); if (columns.Count > 0) { list_columnWithArticle = new List <ColumnWithArticle>(); foreach (var column in columns) { if (column.COL_Path == null) { column.COL_Path = column.COL_Name; } IList <Col_Article> articles = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <Col_Article>("Cms_Article_ByColumn", new { ROWNUM = rownum, ColumnId = column.ColumnId }.ToStringObjectDictionary(false)); foreach (var article in articles) { IList <Attachment> attachments = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <Attachment>("Cms_Attachment_ByArticle", new { ROWNUM = 1, SourceId = article.ArticleId, SourceTable = "Pub_Article", AttachmentTag = "ArticlePic" }.ToStringObjectDictionary(false)); article.Attachments = attachments; } list_columnWithArticle.Add(new ColumnWithArticle { Column = column, Articles = articles }); } } result.rows = list_columnWithArticle; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <ColumnWithArticle> HomeColumnsWithArticles(ArticleColumn param) { CollectionInvokeResult <ColumnWithArticle> result = new CollectionInvokeResult <ColumnWithArticle> { Success = true }; int rownum = 6; try { IList <ColumnWithArticle> list_columnWithArticle = null; IList <ArticleColumn> columns = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <ArticleColumn>("Cms_Index_LoadMoreColumns", param.ToStringObjectDictionary(false)); if (columns.Count > 0) { list_columnWithArticle = new List <ColumnWithArticle>(); foreach (var column in columns) { if (column.COL_Path == null) { column.COL_Path = column.COL_Name; } IList <Col_Article> articles = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <Col_Article>("Cms_Article_ByColumn", new { ROWNUM = rownum, ColumnId = column.ColumnId }.ToStringObjectDictionary(false)); list_columnWithArticle.Add(new ColumnWithArticle { Column = column, Articles = articles }); } } result.rows = list_columnWithArticle; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <ArticleColumn> HomeColumns(ArticleColumn param) { CollectionInvokeResult <ArticleColumn> result = new CollectionInvokeResult <ArticleColumn> { Success = true }; try { IList <ArticleColumn> columns = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <ArticleColumn>("Cms_Index_LoadMoreColumns", param.ToStringObjectDictionary(false)); result.rows = columns; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public ModelInvokeResult <ArticleColumnPK> Nullify(string strColumnId) { ModelInvokeResult <ArticleColumnPK> result = new ModelInvokeResult <ArticleColumnPK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); Guid?_ColumnId = strColumnId.ToGuid(); if (_ColumnId == null) { result.Success = false; result.ErrorCode = 59996; return(result); } ArticleColumn articleColumn = new ArticleColumn { ColumnId = _ColumnId, Status = 0 }; /***********************begin 自定义代码*******************/ articleColumn.OperatedBy = NormalSession.UserId.ToGuid(); articleColumn.OperatedOn = DateTime.Now; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = articleColumn.GetUpdateMethodName(), ParameterObject = articleColumn.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE }); /***********************begin 自定义代码*******************/ /***********************此处添加自定义代码*****************/ /***********************end 自定义代码*********************/ BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); result.instance = new ArticleColumnPK { ColumnId = _ColumnId }; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public ModelInvokeResult <ArticleColumnPK> Create(ArticleColumn articleColumn) { ModelInvokeResult <ArticleColumnPK> result = new ModelInvokeResult <ArticleColumnPK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); if (articleColumn.ColumnId == GlobalManager.GuidAsAutoGenerate) { articleColumn.ColumnId = Guid.NewGuid(); } /***********************begin 自定义代码*******************/ articleColumn.OperatedBy = NormalSession.UserId.ToGuid(); articleColumn.OperatedOn = DateTime.Now; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = articleColumn.GetCreateMethodName(), ParameterObject = articleColumn.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT }); /***********************begin 自定义代码*******************/ /***********************此处添加自定义代码*****************/ /***********************end 自定义代码*********************/ BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); result.instance = new ArticleColumnPK { ColumnId = articleColumn.ColumnId }; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }