/// <summary>
        /// 添加账号
        /// </summary>
        /// <param name="rowType">是否添加类型</param>
        /// <param name="operationEntity">实体</param>
        /// <returns></returns>
        public bool RoleOperationAdd(int rowType, Entity.ManagerRoleOperation operationEntity)
        {
            SqlParameter[] para =
            {
                new SqlParameter("@RowType",         SqlDbType.NVarChar,          50),
                new SqlParameter("@OperationId",     SqlDbType.UniqueIdentifier),
                new SqlParameter("@RoleId",          SqlDbType.Int),
                new SqlParameter("@MemuName",        SqlDbType.NVarChar,          50),
                new SqlParameter("@MemuCode",        SqlDbType.NVarChar,          50),
                new SqlParameter("@OperationCode",   SqlDbType.NVarChar,          50),
                new SqlParameter("@OperationName",   SqlDbType.NVarChar,          50),
                new SqlParameter("@OperationType",   SqlDbType.NVarChar,          50),
                new SqlParameter("@OperationNumber", SqlDbType.Int,               50),
            };
            para[0].Value = rowType;
            para[1].Value = operationEntity.OperationId;
            para[2].Value = operationEntity.RoleId;
            para[3].Value = operationEntity.MemuName;
            para[4].Value = operationEntity.MemuCode;
            para[5].Value = operationEntity.OperationCode;
            para[6].Value = operationEntity.OperationName;
            para[7].Value = operationEntity.OperationType;
            para[8].Value = operationEntity.OperationNumber;
            int outafter = 0;

            return(DbHelperSQL.RunProcedure("ManagerRoleOperationAdd", para, out outafter) > 0);
        }
示例#2
0
        /// <summary>
        /// 更新数据
        /// </summary>
        /// <param name="context"></param>
        private static void UpdateData(HttpContext context)
        {
            string strRowType         = context.Request["RowType"];
            string strRoleId          = context.Request["RoleId"];
            string strMemuName        = context.Request["MemuName"];
            string strMemuCode        = context.Request["MemuCode"];
            string strOperationName   = context.Request["OperationName"];
            string strOperationCode   = context.Request["OperationCode"];
            string strOperationType   = context.Request["OperationType"];
            string strOperationNumber = context.Request["OperationNumber"];

            Entity.ManagerRoleOperation entity = new Entity.ManagerRoleOperation()
            {
                MemuCode        = strMemuCode,
                MemuName        = strMemuName,
                OperationCode   = strOperationCode,
                OperationId     = Guid.NewGuid(),
                OperationName   = strOperationName,
                OperationNumber = int.Parse(strOperationNumber),
                OperationType   = strOperationType,
                RoleId          = int.Parse(strRoleId)
            };
            DataAccess.RunProcedure runProc = new DataAccess.RunProcedure();
            if (runProc.RoleOperationAdd(int.Parse(strRowType), entity))
            {
                context.Response.Write("保存成功");
            }
            else
            {
                context.Response.Write("保存失败");
            }
        }