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