コード例 #1
0
        public ModelInvokeResult <ArticleColumnPermitPK> Update(string strId, ArticleColumnPermit articleColumnPermit)
        {
            ModelInvokeResult <ArticleColumnPermitPK> result = new ModelInvokeResult <ArticleColumnPermitPK> {
                Success = true
            };

            try
            {
                int _Id = int.Parse(strId);
                List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
                /***********************begin 自定义代码*******************/
                articleColumnPermit.OperatedBy = NormalSession.UserId.ToGuid();
                articleColumnPermit.OperatedOn = DateTime.Now;
                /***********************end 自定义代码*********************/
                statements.Add(new IBatisNetBatchStatement {
                    StatementName = articleColumnPermit.GetUpdateMethodName(), ParameterObject = articleColumnPermit.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
                });
                /***********************begin 自定义代码*******************/
                /***********************此处添加自定义代码*****************/
                /***********************end 自定义代码*********************/
                BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
                result.instance = new ArticleColumnPermitPK {
                    Id = _Id
                };
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }
コード例 #2
0
        public InvokeResult NullifySelected(string strIds)
        {
            InvokeResult result = new InvokeResult {
                Success = true
            };

            try
            {
                List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
                string[] arrIds = strIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                if (arrIds.Length == 0)
                {
                    result.Success   = false;
                    result.ErrorCode = 59996;
                    return(result);
                }
                string statementName = new ArticleColumnPermit().GetUpdateMethodName();
                foreach (string strId in arrIds)
                {
                    ArticleColumnPermit articleColumnPermit = new ArticleColumnPermit {
                        Id = int.Parse(strId), Status = 0
                    };
                    /***********************begin 自定义代码*******************/
                    articleColumnPermit.OperatedBy = NormalSession.UserId.ToGuid();
                    articleColumnPermit.OperatedOn = DateTime.Now;

                    /***********************end 自定义代码*********************/
                    statements.Add(new IBatisNetBatchStatement {
                        StatementName = statementName, ParameterObject = articleColumnPermit.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
                    });
                }
                BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }
コード例 #3
0
        public InvokeResult SetUpColumnPermit2(string groupId, IList <string> permitIds)
        {
            InvokeResult result = new InvokeResult {
                Success = true
            };

            List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();

            try
            {
                ArticleColumnPermit articleColumnPermit = new ArticleColumnPermit();
                articleColumnPermit.OBJ_ID = groupId.ToGuid();
                statements.Add(new IBatisNetBatchStatement {
                    StatementName = articleColumnPermit.GetDeleteMethodName(), ParameterObject = articleColumnPermit.ToStringObjectDictionary(false), Type = SqlExecuteType.DELETE
                });

                foreach (var item in permitIds)
                {
                    string[] stra = item.Split('_');
                    articleColumnPermit.ColumnId   = stra[0].ToGuid();
                    articleColumnPermit.PermitType = byte.Parse(stra[1]);
                    articleColumnPermit.Category   = 0;
                    articleColumnPermit.OperatedBy = NormalSession.UserId.ToGuid();
                    articleColumnPermit.OperatedOn = DateTime.Now;

                    statements.Add(new IBatisNetBatchStatement {
                        StatementName = articleColumnPermit.GetCreateMethodName(), ParameterObject = articleColumnPermit.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
                    });
                }
                BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements);
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }
コード例 #4
0
        public InvokeResult DeleteSelected(string strIds)
        {
            InvokeResult result = new InvokeResult {
                Success = true
            };

            try
            {
                List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
                string[] arrIds = strIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                if (arrIds.Length == 0)
                {
                    result.Success   = false;
                    result.ErrorCode = 59996;
                    return(result);
                }
                string statementName = new ArticleColumnPermit().GetDeleteMethodName();
                foreach (string strId in arrIds)
                {
                    ArticleColumnPermitPK pk = new ArticleColumnPermitPK {
                        Id = int.Parse(strId)
                    };
                    DeleteCascade(statements, pk);
                    statements.Add(new IBatisNetBatchStatement {
                        StatementName = statementName, ParameterObject = pk, Type = SqlExecuteType.DELETE
                    });
                }
                BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
            }
            catch (Exception ex)
            {
                result.Success      = false;
                result.ErrorMessage = ex.Message;
            }
            return(result);
        }